What is difference between rollback immediate and with no_wait during alter database?


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

Post New Answer

More SQL Server Interview Questions

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  


What is sql server locking?

0 Answers  


How to update values in a table with update statements in ms sql server?

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  






What is policy based management (pbm)? : sql server database administration

0 Answers  


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  


What is meant by indexing?

0 Answers  


What is table-valued sub query?

0 Answers  


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  


Do you know what is a with(nolock)?

0 Answers  


What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,


Categories