I recently restored a database and it gave an error after restore about indexes and rowguid columns, but the database was there, so I'm going with it.
But it showed up as "databasename (single user)" and I couldn't use it because "there is already a user logged into this database".
so I had to change it, this link was very helpful:
http://remidian.com/mssql/remove-sql-server-database-from-single-user-mode.html
But it showed up as "databasename (single user)" and I couldn't use it because "there is already a user logged into this database".
so I had to change it, this link was very helpful:
http://remidian.com/mssql/remove-sql-server-database-from-single-user-mode.html
SELECT spid
FROM sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
WHERE d.name = 'DatabaseName';
KILL <spid returned above>
EXEC sp_dboption 'DatabaseName', 'single user', 'FALSE';
No comments:
Post a Comment