Disable Specific Triggers Based On SYS.SQL_MODULES DEFINITION

April 7, 2015 | Posted in SQL Server, Uncategorized
declare @temp table
(table_name varchar(100), trigger_name varchar(100))
insert into @temp
select object_name(parent_id), name
from sys.triggers
where name in
(
select object_name(object_id) from sys.sql_modules where definition like ‘%SEARCH%STRING%’
)
and is_disabled = 0
declare @sql varchar(255)
declare db_cursor cursor for
select ‘ALTER TABLE ‘ + table_name + ‘ DISABLE TRIGGER [' + trigger_name + ']‘ from @temp x
open db_cursor
fetch next from db_cursor into @sql
while @@FETCH_STATUS = 0
begin
exec (@sql);
fetch next from db_cursor into @sql
end
close db_cursor
deallocate db_cursor
How to get the ip address of SQL Server using SSMS

October 2, 2014 | Posted in Uncategorized
select connectionproperty(‘local_net_address’)