![]() ![]() ![]() I hope you have a good idea on how to take a database to offline and do maintenance activity. Right-click the database -> Properties -> Options Set Database Read-Only to True Click Yes at the dialog warning SQL Server will close all connections to. ![]() SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID(‘ In case if you want to see processes connected with the database, you can us this SQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |