Subscribe to
Posts
Comments

Archive for August, 2009

Master.mdf is Compressed But Does not Reside in a Read-only Database or Filegroup. The File Must be Decompressed.

Posted in System Admin on August 6th, 2009 No Comments »

I have not used the developer edition of SQL server on my laptop machine for a long while. When I try to turned on SQL server today I found it couldn’t start. When I check the event log there was an error message related to SQL server service like this.

“The file “C:\Program Files\Microsoft SQL […]

SQLCmd Example to Output in CSV Format

Posted in SQL Server on August 5th, 2009 No Comments »

SQLCmd is a very handy tool used to execute SQL script automatically and output results to a file. Here is an example:
sqlcmd -S “ServerName” -U “UID” -P “PWD” -d “DBName” -i “c:\input.txt” -o “c:\output.txt” -s “,” -h -1

The parameter names in command line are case sensitive. So -D is different from -d. As shown […]