Snippet Name: conn
Tags: helpful,scriptgeneration
Created Date: Oct 1 2021 8:05AM
Last Modified Date: Oct 1 2021 8:05AM
no description at this time.
Dependencies: none-standalone code
I use this snippet of hundred times a day all it does is pays a header of information in my SQL server management studio session that has a deep detail about the server IP address connection information in the comment and puts set transaction isolation level read uncommitted as the first command.
Sample Output:
--#################################################################################################
-- |CurrentDateInYMD| |CurrentTime| MachineName:|MachineName|; ComputerBiosName:|ComputerName|; |IpAndPort|
-- Cname: |cname| |CurrentWinUserName| |CurrentSQLUserName| Authorization Scheme: |AuthScheme| |ServerName|
-- Context: |MachineName||InstanceName|,|Port|; Database:|DatabaseName|; Version: |SqlVersion| |Edition|
--#################################################################################################
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
GO
{C}