Thanks for sharing the results of your test, Gail...

I remember reading the same article (although I can't find it anymore)... it used a homegrown sp to "renumber" the ID's of the triggers so that they would fire in...

Daniella... What did it?  Scope_Identity?

Serqiy, surely you are not one of those that believes that every table should have a natural key, are you?

Ummm..... that's a bit wierd if you try following the signature path of this one...

PW is correct AND....

You will probably have to use the machine name and path instead of drive name and path.  AND, your server must startup as something that has privs...

Here, Here!  Learn to work with NULLs on this type of thing.  There is a great value to NULLs in a column like this especially if you allow future enddating.

Why on earth are you updating 70% of a million row table that is being accessed by users on a regular basis?   That's borderline insanity on the part of whoever...

p.s.  Deadlocks are so important, that the DBA(s) should monitor them daily and report on them weekly.  They should also assist in trying to figure out where the heck they...

Deadlocks are one of the most important but most people seem to have no clue about it and it doesn't turn on automatically...

Lookup "deadlocks, troubleshooting" for more on deadlocks and...

Remove the commas....

declare @dbname varchar(8000)

declare @countyname varchar (200)

declare...

Not sure why you think the statement terminates...

Care to share the details?

Vandy,

As Carl pointed out, you cannot use SET or IF.  A view must consist of only 1 SELECT statement or the UNION of several SELECTs (don't believe that will be...

In your last query posting, you are grouping by WRNotes and you cannot.

Now... that's why I was asking... you're doing it the hard way

If you have a SAN storage unit (or similar), check with...