I found DATEFORMAT in a Jr. DBA’s code. SET DATEFORMAT sets the order of month, day and year so SQL Server can read date strings in other formats.
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
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.
SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode
How we rename database copies on our development server: set it to single user mode, run sp_renamedb, then set it back. The file names do not change.