Msg 1813 says CREATE DATABASE is aborted when you attach a database with a corrupt log. My step by step fix rebuilds the log and needs a server restart.
SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
Fix the SQL Server error Msg 4214 and Msg 3013, where BACKUP LOG fails because no current database backup exists. Here is why it happens.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.
SQL SERVER – SPACE Function Example
Does SQL Server have a SPACE function? Yes. SELECT SPACE(100) returns 100 spaces, and a short example uses it to join last and first names.
SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
Everything about restore and backup readers ask: can you restore without a backup? No. Here is the right restore order and a plan to stay safe.
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
Stop building ORDER BY strings and running them with EXEC in a stored procedure. I show how a CASE statement in ORDER BY sorts by a variable without dynamic SQL.
CHECKSUM: A Matching Result Does Not Prove Text Identity
CHECKSUM matches do not establish unchanged text. Preserve complete values and compare hyphen and trailing-space differences explicitly.