DBA > Job Interview Questions > Microsoft SQL Server FAQs

In SQL Server 2005, which of the following schem

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?

Answer
All of the above.
Explanation
SQL Server 2005 replicated databases support the following schema changes for objects:
* ALTER TABLE
* ALTER VIEW
* ALTER PROCEDURE
* ALTER FUNCTION
* ALTER TRIGGER (DML only)

(Continued on next question...)

Other Job Interview Questions