-
SQL SERVER – Database in RESTORING State for Long Time
Today, I would like to share this with others after I did. Non recovery sate to recover the database. That…
-
Check if database exists?
USE YourDatabaseName GO SET @dbname = ‘YourDatabaseName’ IF NOT EXISTS(SELECT*FROMsys.databasesWHERE name = @dbname ) BEGIN –Do Something here…
-
SQL SchemaDiff (Compare Database Schemas)
Use MSSQL Schema Diff to compare database schemas. It quickly and easily locates structural differences between two SQL Server databases.…
-
SQL Database Schema Comparison Tool for SQL Server 2005/2008
Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database…
