This script originally created by Greg Larsen has been modified by me. This procedure is used to create the restore commands needed to restore a database using the lates full and any transaction or differential backups. The parameter @dbname was added to just create the restore statements for a particular database. Leaving off this parameter […]
2005-06-07 (first published: 2005-05-19)
1,225 reads
For those site using SQL Server ids as opposed to Integrated security there may be instances where occasionally SQL Server logins might get 'orphaned'. That is the login is not a member of any server group that has general database access nor does that login have specific access to any particular database. Compile this proc […]
2004-03-01
279 reads
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Hi there I need help on creating a Linked Server to an MS Access...
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Hello - I have attached a Word document here with details about my issue....
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers