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.

Execresultset?

Demo please!

Why can't you hardcode the dbname in the script?

USE DbName

GO

IF EXISTS... DROP VIEW

GO

CREATE VIEW...

GO

Any other option will involve creating a file on the fly with the correct db name, directly...

Hmm, looks like the dynamic sql doesn't work in this context.

In which context do you need to run this script?