There is one main thing that i did not mention in my original post. I don't want to hard-code this auditing. That is why I am using the Informational_Schema view...

How can I implement your first option?

Thank you very much. I worked.

The recovery mode is full recovery. Should it be changed Bulk Logged?

I have done a lot of upgrade and I will tell you this common fact. Migrate you tables first and this is fairly easy by using SQL DTS or Access...

In both cases, the DB will not be available to users request. As far as results go, it is unclear what you mean by result. From what i know, when...

I guess my next question is, can you setup a profiler template and execute it from a Stored Proc on demand (as needed only) rather than scheduling it to run for...

I will experiment with that, but is there any other way to do this without Profiler say by writing a procedure? or Function? Thanks

I am running the code in QA currently but if it works i will place it in an SP.

Yes I have MSDTC running and after reading the article in the link I am issusing a dbcc command not a DML statement against the Linked Server. Look at sample...

We are about to start an Enterprise System implementation and i will be using this variable all over the palce so i wanted to make sure that in the future...

You are a life saver. Thank you very much.

I have also used a custom t-sql stored procedure which uses the xp_cmdshell procedure to ftp files on to a remote site before and it works find. i scheduled it...

First, check to see (in the original Application .MDB) if the Form DataSource is bound to a Table directly or a Query. If it is bound to a Query, then...

If you really want to lunch Access from T-SQL using the xp_cmdshell. The you have to lunch the Access Runtime app, pass the access full name and the macro name...