-- SQL and OS Version information for current instance SELECT @@VERSION AS [SQL Server and OS Version Info];

The following script will generate output script with restore command to restore all log backup located at L:\Log_Backup\DB_Name\ exec...

/* The Code */ --If you want to get a list of current owners who aren't sa SELECT suser_sname(owner_sid) as DBOwner, Name as DBName FROM...

--Script to find autogrowth event from the default trace. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLARE...

Use msdb go select distinct j.Name as "Job Name", --j.job_id, case j.enabled when 1 then 'Enable' when 0 then 'Disable' end as "Job...

SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS...

-- Show data in table dbtest02 that do not exists in dbtest01 select * from dbtest02.dbo.article except select * from dbtest01.dbo.article