Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
Error 8170 says there is insufficient result space to convert a uniqueidentifier value to char. The simple fix is to give the VARCHAR its full 36 characters.
SQL Error Riddles: Parent Keys Not Found and Other Classics
SQL error riddles have been passed around for years. Here are the classics, told kindly, with the real SQL Server error behind each punchline.
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
Error 4214: BACKUP LOG cannot be performed because there is no current database backup. Take one full backup first, and the log backup will work.
SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase
Error 8501 says MSDTC on server is unavailable, often while configuring replication. Start the Distributed Transaction Coordinator service to fix it.
SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward
A reader restored a full backup, then hit Error 3117: the log or differential backup cannot be restored. Here is why it happens and what to do.
SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
My friend kept getting the server network address cannot be reached error while testing mirroring configured without domain on his laptop. Here is why.