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.
SQLAuthority News – Book Review – Programming SQL Server 2005 [ILLUSTRATED]
My review of Programming SQL Server 2005 by Bill Hamilton, which covers only the new features, from T-SQL and XML to SSIS, SSRS and Service Broker.
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 – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used
“What will be the order of the result set of a SELECT statement on clustered indexed table when the ORDER BY clause is not used?”
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.