Create the Procedure
Compile the procedure
Run the procedure: -
EXEC usp_checkdb @dbname = 'Enter DB'
SQl Hunt,
2019-05-03 (first published: 2015-04-10)
Create the Procedure
Compile the procedure
Run the procedure: -
EXEC usp_checkdb @dbname = 'Enter DB'
CREATE procedure usp_checkdb (@dbname nvarchar(128)) as begin /* Check, How to Run: EXEC usp_checkdb @dbname = 'Enter DB' */ IF (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname))) SELECT 'YES' IF (NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname))) SELECT 'No' END
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2019-05-03 (first published: 2014-12-24)
1,574 reads
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
575 reads
If you want to extract only deadlock details, use the script.
2019-05-03 (first published: 2014-12-03)
3,649 reads
If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.
2019-05-03 (first published: 2014-11-12)
1,703 reads
Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.
2019-05-03 (first published: 2014-10-13)
4,885 reads