How to export data from the HelpMaster database
Applies to SQL Server 2008 and higher
Data can be exported from SQL Server via the use of the sqlcmd utility that installs with SQL Server.
sqlcmd -S "Database server name\instancename" -d "HelpMaster Database name goes here" -q "Select * From dbo.rptCompleteDetails_Job_ClientSite1 Where JobNumber > 0" -o "c:\JobExport.csv" -s ,
Click on Start, run "cmd" with Administrator permission and then paste the command into the "DOS" Window.
For further information about sqlcmd tool, refer to http://msdn.microsoft.com/en-us/library/ms162773.aspx