SQL server database owners
August 21, 2019 Leave a comment
select SUSER_SNAME(owner_sid) As [Login], [name] from sys.databases
Windows servers tech tips
August 21, 2019 Leave a comment
select SUSER_SNAME(owner_sid) As [Login], [name] from sys.databases
May 26, 2018 Leave a comment
USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO
September 5, 2017 Leave a comment
SELECT name, recovery_model_desc
FROM sys.databases
GO
December 28, 2015 Leave a comment
ALTER DATABASE <dbasename> SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO
July 28, 2015 Leave a comment
USE master;
ALTER DATABASE [databasename] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [databasename] ;