You can stop and disable...

it has been my experience that "is_subscribed" does NOT work 😉

gavin.duncan (6/4/2008)

---

Noooooo the saga continues!

OK........ive made the changes and have ended up with the following:

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'

...

No problem ... it was MY typo 😀

hehe :

IF NOT EXITS

should be:

IF NOT EXISTS

dmontgomery (6/4/2008)

---

Here is the code for my SPROC., it skips over every "IF" statement regardless of the value of the parameter:

ALTER PROCEDURE [dbo].[filtersortlikeDGV]

@SrtBy NVARCHAR(20),

@ItmType NVARCHAR(20) = 'All Items',

@CatName NVARCHAR(20) =...

gavin.duncan (6/4/2008)

---

Hi. Once again thanks for your swift response 🙂

OK..........i removed the 'GO's and the code i am left with is:

IF NOT EXITS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE...

gavin.duncan (6/4/2008)

---

Hello there. Thanks very much for taking the time to reply.

OK..........ive taken your code and modified it as such:

IF NOT EXITS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE =...

IF EXITS (SELECT *

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'

AND TABLE_NAME = '..... your table name ....'

AND TABLE_SCHEMA ='dbo' )

BEGIN

---- Your code here

END

if you don't have indexed views nor Triggers the only thing left for me to guess is that your foreign keys are defined with CASCADE actions can you post the...

IF your distribution retention period is BIG enough to cover for the outage you should be fine!

You could look at setting up an alert for "14238" but because we can't make it "logged" in 2005 it probably wouldn't work.

I would still give it a go......

sometimes is good to warn people about "sending emails from triggers may not be what you want" 😉

definitely a CLR function will be the best bet ...IF ... you have CLR enabled 😉

you should check the indexes for fragmentation and also probably update the stats after the batch finishes.