Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
I had previously written two articles about an intriguing observation of triggers online. SQL SERVER – Interesting Observation of Logon Trigger On All Servers SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution If you are wondering what made me write yet another article on logon…
Read MoreSQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
I recently had requirement to create list of all the SQL Server on local network. I remembered that I had written similar script a year ago SQL SERVER – Script to Find SQL Server on Network. When I looked at it, I realize that I had written it for SQL…
Read MoreSQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query
People are judged from their questions and not their answers. I received wonderful question the other day. How sqlcmd can be used along with currently running query script posted on your blog? Please read following two posts before continuing this article as they cover background of this article. SQL SERVER…
Read More
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
A day before I wrote article SQL SERVER – sqlcmd vs osql – Basic Comparison. Today while I was displaying how sqlcmd can be used instead of osql to one of my companies team leader, I found another neat feature of SSMS Query Editor. sqlcmd can be used from Query Editor but it has to be enabled first.
SQL SERVER – sqlcmd vs osql – Basic Comparison
Today we will go over very simple but to the point comparison of two SQL Server utilities or SQL Server tools. This comes often to users which one to use sqlcmd or osql, when in need of running SQL Server queries from command prompt. Answer to this is very simple…
Read MoreSQL SERVER – 2005 – Introduction and Explanation to sqlcmd
I decided to write this article to respond to request of one of usergroup, which requested that they would like to learn sqlcmd 101. SQL Server 2005 has introduced new utility sqlcmd to run ad hoc Transact-SQL statements and scripts from command prompt. T-SQL commands are entered in command prompt…
Read More