Tag Archives: Error Message

SQL Server Agent Job output to email

Posted on August 11, 2020 by thomasrushton

I came across a need for SQL Server Agent job output to be emailed out to the developer who created the code that the job was running. For various reasons, they don’t necessarily have access to the SQL Server itself … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Failed to Update Read-Only Database on Backup

Posted on March 3, 2019 by thomasrushton

A problem at work recently – the Netbackup-driven SQL backups were failing for just one database on a particular server. The database in question was, like one other, set to read-only. I ran DBCC CHECKDB, on the off-chance that this … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

SQL Server Non-Unique Clustered Indexes Are Evil!

Posted on June 4, 2017 by thomasrushton

Non-Unique Clustered Indexes Are Evil And We Have The Proof. You won’t believe it when you see it. Face it – I can’t write click-bait… I was reading Grant Fritchey’s (Blog|@gfritchey) comments in the SQL Server Central forum thread “Advice … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 2 Comments

SQL Server 2012 installation – Error while enabling Windows Feature NetFx3

Posted on December 3, 2014 by thomasrushton

Just a quickie, as I didn’t have the time to take screenshots. Installing SQL Server 2012 on a new Windows Server 2012 VM. Part-way through the installation, I got the following error message: TITLE: Microsoft SQL Server 2012 Service Pack … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Error Msg 60400, LS::initializeFiles User Exception

Posted on February 15, 2014 by thomasrushton

Today’s error message, brought to me by SQL Server / Quest Litespeed for SQL Server: Msg 60400, Level 16, State 1, Line 0 (LS::initializeFiles) user exception Looking at the Transaction Log backup file that it was trying to restore at … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Messages I hate…

Posted on June 22, 2010 by thomasrushton

I run a simple query against a group of databases using the multiple connection feature in SSMS 2008.  Nothing too complicated, just trying to see which (if any) databases are annoying me with a particular feature: sp_msforeachdb ‘if databasepropertyex(”?”, ”IsAutoShrink”) … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged | 7 Comments