Category Archives: SQL

SQL server commands and scripts.

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

Objects Query

/* Select ALL table names and column names from a given table. */ select o.name as [TableName], c.name as [ColumnName] from sys.objects o inner join sys.columns c ON o.object_id = c.object_id where 0=0 and type = ‘U’ — and c.name … Continue reading

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

Data and log file iteration

——————————————————————– — This will generate a list of databases to iterate through and pull — data and log file locations, plus size, etc. — There are 2 parts. 1 generates the list and 2 creates the output. ——————————————————————– /* PART … Continue reading

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

Check Space

—————————————————- — WORK IN PROGRESS — xp_fixeddrives joined with sys.masterfiles view — Looking at space, judging db size, growth and — free space on the server. — use sp_helpfile for SQL 2000 —————————————————- set nocount on declare @fixeddrives table — … Continue reading

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