Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.
SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
What is the effect of a TRANSACTION on local variable values after ROLLBACK and after COMMIT? A short example I wrote for a Jr. Developer shows the answer.
SQL SERVER – Stored Procedure to Know Database Access Permission to Current User
Which databases can I use? Run EXEC sp_MShasdbaccess to see the database access permission of the current user. Our Jr. DBAs check it all the time.
SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver
EXEC xp_msver returns SQL Server version information plus server details like platform, language and file version, with no need to check Windows system info.
SQL SERVER – 2005 – Multiple Language Support
Multiple language support in SQL Server: sys.syslanguages holds the details for each language, including month and day names. One query lists them all.







