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

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,


How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  


What is a user-defined function in the sql server and what is its advantage?

0 Answers  


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  


What is ms sql server triggers?

0 Answers  






where the connection string store in the database

0 Answers   HCL, Wipro,


How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  


How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,


what are triggers? : Sql server database administration

0 Answers  


Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


What is bcp? When does it use?

0 Answers  


Categories