Tag Archives: checkDbexist

Check existing databases then create

— CHECK existing databases for existence. if exists (select * from master..sysdatabases where name = ‘dbName’ ) drop database dbName GO create database dbName on primary (name = ‘dbName’, filename = ‘C:\data\dbName.mdf’), log on (name = ‘dbNameLOG’, filename = ‘C:\data\dbName.ldf’) … Continue reading

Posted in SQL, Tools and Tricks | Tagged | Leave a comment