Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as
Read More...
Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can
Read More...
For the first time I have got a chance to work with SQLCMD utility in SQL Server 2005 and I was keen to use the variables and in previous versions of SQL this was controlled by declaring them explicitly. Now in SQL Server this is not the case, using SQLCMD
Read More...