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

Post New Answer

More SQL Server Interview Questions

where do you use Isolations?give me some exmpale?

1 Answers  


What do you mean by an execution plan? How would you view it?

0 Answers  


what command is used to create a table by copying the structure of another table?

7 Answers  


What are the differences between lost updates and uncommitted dependencies?

0 Answers  


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

0 Answers  






What is coalesce in sql server?

0 Answers  


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?

0 Answers  


How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  


Is it possible to call a stored procedure within a stored procedure?

0 Answers  


Tell me the difference between clustered and non-clustered index?

0 Answers  


What are page splits? : SQL Server Architecture

0 Answers  


What is stored procedure in SQL..??

2 Answers  


Categories