What is the difference between dropping a database and taking a database offline?
No Answer is Posted For this Question
Be the First to Post Answer
where do you use Isolations?give me some exmpale?
What do you mean by an execution plan? How would you view it?
what command is used to create a table by copying the structure of another table?
What are the differences between lost updates and uncommitted dependencies?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is coalesce in sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to grant a permission in ms sql server using "grant execute" statements?
Is it possible to call a stored procedure within a stored procedure?
Tell me the difference between clustered and non-clustered index?
What are page splits? : SQL Server Architecture
What is stored procedure in SQL..??