Consolidation

RE: replication with triggers

• by gljjr

• SearchSQLServer

• Reply

Ouch... Well here is the method I use to alter triggers in bulk... -- Add the triggers to a working table IF NOT object_id('tempdb..#DisabledTriggers') IS NULL DROP TABLE #DisabledTriggers SELECT so.name TriggerName, sot.name TableName, sc.text TriggerSql INTO #DisabledTriggers FROM syscomments sc JOIN sysobjects so on sc.id = so.id JOIN sysobjects sot on so.parent_obj = sot.id […]

2003-06-19

RE: IDENTITY_INSERT

• by rknopf

• SearchSQLServer

• Reply

set identity_insert aaa on insert into mytab(id, name) values (1,'fred') insert into mytab(id, name) values (2,'sam') insert into mytab(id,name) select custid, name from customer set identity_insert aaa off 1) You need to specify the column names when inserting into an identity column 2) Don't forget to turn the identity_insert back off. Robert F Knopf

2003-06-19

1 reads

RE: New Feature

• by Brian Knight

• SearchSQLServer

• Reply

As long as people learn, I sure don't care. You can live with your score being high artificially Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight

2003-06-15

RE: Why should prevent creation of new DTS packages...

• by Brian Kelley

• SearchSQLServer

• Reply

My personal preference is to break all of his fingers, but I know that probably won't be considered acceptable. There's an FAQ with some more details if you want to get really specific with permissions: http://qa.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=252 K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-06-13