By definition, if the trigger fails, the WHOLE transaction fails.  I'm sure there are ways to go around this but I'm more interested as the WHY do you want to...

I don't have any metrics to give you.  The short answer is if you don't suffer from performance problems on that machine, then you're alright.  Specially if it's only a...

SELECT * FROM LnkdSrv.DbName.dbo.SysObjects WHERE XType = 'U' ORDER BY Name

The only way you could do this is run a continual trace to see all executed statements.  Then after the predetermined period of x (30) days, you try to find...

How would that make it easier?

Here's one question :

What do the employees have to do with the attendance in the same resultset?

I'd do 2 reports and show the 2 reports on a master report...

Run that with a few date formats and see how consistant the results are.  They are never gonna be the same from one time to the next.

Anyone can post a sample script for the osql solution?  I'd like to learn something else today .

Exactly... been burned by that one before!

Click on Steve's name to see his profile, then find and hit the PM link.  That way he gets a notification that there's something to do.

That's what happens when you read too fast.  I thaught you wanted to DELETE the property, and not disable it for a while.

If you only need to temporarely disable, then...

Just throwing this out...

It might even be faster to create a brand new clean DB (with the modifications), then reload all the data.  Might be about as fast, but the...

can WILL cause down time.

small install app could handle that without any problem.  I'm guessing osql as well but I never used that so I can't tell for sure.

Fastest way is through EM.  Because all constraints and indexes must be destroyed / rebuilt in that process.