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?

2188

How to invoke a trigger on demand?

1151

How to create nested stored procedure?

1073

Explain “row_number()” in sql server with an example?

1057

Can I run multiple instances of sql server 2000 at the same time on one computer?

1121

Explain stored procedure?

1109

When is the use of update_statistics command?

1057

What is a field name?

1017

What is proper subset of candidate key?

1044

What is update_statistics command?

1121

What are the advantages of mirroring?

1041

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1940

what is the information that can be stored inside a bit column? : Sql server database administration

1010

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167

What is ddl command?

1034