Monthly Archives: June 2009

Moving Master and Resource databases

Posted on 29. June 2009 by Bennett

You may encounter the error message “SQL SERVER is in SINGLE USER MODE and only one administrator can connect” when moving the Master and Resource databases when following the procedure in BOL.  It happens right after you bring up SQL … Continue reading →

Posted in Uncategorized | Comments Off on Moving Master and Resource databases

Quick and Dirty CSV import to SQL Server

Posted on 11. June 2009 by Bennett

You can use LogParser (a free, unsupported utility from Microsoft) to quickly import a CSV file into a SQL Server table using syntax like this: logparser “SELECT * INTO MyTable FROM d:\MyFile.csv” -i:csv -o:SQL -server:MyServer -database:MyDatabase -createTable:ON There are many … Continue reading →

Posted in SQL Server, Windows OS | Comments Off on Quick and Dirty CSV import to SQL Server