You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain the use of containers in ssis and also their types?

0 Answers  


What is a sql join?

0 Answers  


Is resultset an interface?

0 Answers  


How to list all columns in a table using odbc_columns()?

0 Answers  


What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  






Define left outer join in sql server joins?

0 Answers  


How to get a list of columns in a view using the "sp_help" stored procedure?

0 Answers  


Do you know data definition language, data control language and data manipulation language?

0 Answers  


wht's the differece between sqlserver05 and sqlserver2000

3 Answers  


What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,


What are page splits?

0 Answers  


If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,


Categories