Second thing i observed, my database entered in single user mode, it appear on left pane window as "Database Name (Single User)"
How to Fix this:
Execute below query after connecting to SQL Server on any database
ALTER DATABASE DatabaseName SET MULTI_USER WITH ROLLBACK IMMEDIATE;
Your problem will get resolved and you will be able to execute query on your database.
No comments:
Post a Comment