Tag Archives: SQL 2012

Collation functions and properties – SQL Server

Posted on March 25, 2013 by

A collation encodes the rules governing the proper use of characters for a language. In simple words, collation in SQL Server provide sorting rules, case, and accent sensitivity properties for the data. In this blog post, I am going to … Continue reading →

Posted in SQL Server | Tagged , , , , , | Leave a comment

Get the session property – SQL Server

Posted on March 24, 2013 by

SessionProperty(”): This function returns the SET option settings of the current session. This function returns sql_variant type value. The return value could be 1 or 0 if the function argument is valid or Null if the option is invalid. Set … Continue reading →

Posted in SQL Server | Tagged , , , , , | Leave a comment

Lock_Timeout – SQL Server

Posted on March 23, 2013 by

@@Lock_Timeout function returns the current session lock timeout setting value in milliseconds. It returns an integer value. It returns -1 value if the timeout value is not setup for the current session and -1 is the default value for this … Continue reading →

Posted in SQL Server | Tagged , , , , , , , | Leave a comment

Get a property value of the SQL connection using ConnectionProperty function – SQL Server

Posted on March 22, 2013 by

CONNECTIONPROPERTY (‘Property name’) : This function returns the specific connection property of the current connection made to server. There are predefined property names available in SQL server. So, we should use the same name to get the value of the … Continue reading →

Posted in SQL Server | Tagged , , , , , , | Leave a comment

Execute SQL Server Agent Job Task – SSIS 2012

Posted on January 31, 2012 by

Executing SQL Agent jobs is very simple with Execute SQL Server Agent Job Task in SSIS 2012. SSIS 2012 got a new task that helps us to execute jobs store in the SQL Server Agent. Implementation Step 1: Create a … Continue reading →

Posted in SQL Server, SSIS | Tagged , , , | 1 Comment