Category Archives: SQLServerPedia Syndication

Content automatically syndicated to SQLServerPedia

Failed to Update Read-Only Database on Backup

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 , , , | 2 Comments

Redgate SQLPrompt – Backup your code snippets

You’ve got a new computer? And you want to copy your code snippets over? Or you’ve got a new colleague and want to share your stuff? Or you’ve got multiple machines an want to keep snippets in sync? You’ll want … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Error: There is not enough space on the disk

I was running a query in SQL Server Management Studio (SSMS), nothing too complicated, and got this error, unexpectedly: An error occurred while executing batch. Error message is: There is not enough space on the disk. There’s plenty of space … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

OBJECT_ID()’s second parameter

I received a supplier-supplied maintenance / check / troubleshooting script that did a whole heap of looking-to see-if-a-default-value-exists-and-if-it-doesn’t-then=create-it type stuff. As you would expect, it’s a load of They could have saved themselves a bit of typing (or, let’s be … Continue reading

Posted in SQLServerPedia Syndication | Tagged | Leave a comment

SQL Server Availability Groups and SQL Server Reporting Services – A Brief Rant Triggered By Someone Failing Something Over Without Understanding The Full Implications, Or, Pay Attention To Your DBA Because He Knows This Stuff And That’s What You Pay Him For

Is the headline longer than the body? Not now I’ve included the fix for this situation as well as the initial rant. Maybe next time. Yes, you may have an availability group – well done – and you may have … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

SQL Server Error 18456 Severity: 14 State: 73

A question asked on one of the forums today wasn’t easily answerable by Googling. Summary of the question “I have error 18456 State 73 – why?” Google seemed remarkably quiet on the subject of that particular state code. Even Aaron … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

Longrunning Query – xp_cmdshell?

Flicking through the ol’ Solarwinds activity monitor, I spotted this one day: That four day purple thing on the right? Not good. (The remaining images are from a reconstruction, partly to protect the not-so-innocent, and partly because the first job … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment