You can't limit duplication here because the way to do this is to use a trigger or code it directly in the application.  So just keep a local copy of...

Track changes of the data or data type/constraints...?

Do you even have access to that table.  Can they grant you access to a view of the table?  Then you can save...

Check the export data wizard.  It can do just that.  You can run the wizard then save the package on the server for further use.

Also if they manually want to...

I got 2... and they are 4 yers old each iirc .

Pls keep us posted of your progress... This is really an...

Also anyone feel free to come up with a better test than mine.. not my area of expertise.

My goal was not to test the system on DML operations but testing the statement itself. That's why I am using as little statements as possible.

However I'm glad to...

I see no point in doing that. Why do you want to do is exactly?

What do you need to keep track of exactly?

Also why can't you use triggers for this?

I found refferences of native mode for BCP... but nothing for the server itself.  I'm with you on this one.  I think he's talking about compatibility of the database, or...

Good idea... just in case the order system changes over the life of the application and that new information must be reported later on!

Can you fire up profiler, run the maintenance plan, then copy the executed sql to SSMS, then rerun, that'll give you a better idea of what is failing and maybe...

Depending on what you need, you can do a select * from the table.  Then using the recordset.save method, save as an xml file.

I can't really propose the best method...

The more versatile solution to the second variation of the problem goes like this. (can be simplified but I don't have time for it now). Also I expect...

Is the directory valid (where you want to add a directory).  Does the server have access to that folder (read/write min... full control better)?

Are you looking to find employees not listed in temp?

>> Select * FROM dbo.Employees E where NOT exists (Select * from #temp t where E.empid = t.empid)

Because my first impression of...