Monday, August 18, 2014

SQL Server Bulk Session kill script

Ask for SQL server instance, login and hostname for which the sessions need to be killed and replace the value of @login and @host in below script and execute it on the servers where the session need to be killed. declare @login varchar (200) declare @host varchar (200) declare @id int declare @host_desc varchar(200) declare @login_desc varchar (200) declare @str nvarchar(200) /* Replace login and hostname value*/ SET @login = '<login-need-to-be-killed>' SET @host = '<login-from-which-host>' DECLARE...
Monday, August 18, 2014

In Order to run a trace against SQL Server you must be a member of sysadmin. (Enable trace access without granting sysadmin role)

Use below query to enable trace access without granting sysadmin role. Use Master; GRANT VIEW SERVER STATE TO [Domain\ADGroup or User]; GRANT SHOWPLAN TO [Domain\ADGroup or User]; GRANT ALTER TRACE TO [Domain\ADGroup or User]; Checkout Deal of the Day on Amazon....
Monday, August 18, 2014

SQL Query to get IP address of local & client machine

SELECT    CONNECTIONPROPERTY('net_transport') AS net_transport,    CONNECTIONPROPERTY('protocol_type') AS protocol_type,    CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,    CONNECTIONPROPERTY('local_net_address') AS local_net_address,    CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,    CONNECTIONPROPERTY('client_net_address') AS client_net_addres...
Pages (10)1234567 Next
 
© Copyright 2010-2012 Learn MySQL All Rights Reserved.
Template powered by Blogger.com.