You have modified 100 store procedures and want to replicate these changes fro

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?

Question Posted / newcomer

0 Answers
2129 Views
I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

What is a non equi join?

0 Answers

What is a join in sql?

0 Answers

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers Satyam,

What do you understand by a view? What does the with check option clause for a view do?

0 Answers

Tell me what is a linked server?

0 Answers

How to view existing indexes on an given table using sp_help?

0 Answers

What is the maximum size of column in sql server?

0 Answers

What are cursors?

8 Answers

Why we use functions in sql server?