Jim

If you have xp_cmdshell enabled, you can use it to run the command line for your zip utility. Otherwise, you could consider using SSIS to do the same. ...

Why are you getting a value for @fctity and then not using it? More importantly, why are you using a cursor at all? Get rid of everything up...

Remove the column qualifiers from the SELECT list, or replace them with "Inserted".

John

Please will you post DDL for the two tables, including any primary key or unique constraints. Please also give an example of an INSERT statement.

Are you sure that after...

I'll let you find that out for yourself. Just type "File System Task" into your favourite search engine.

John

If you have a Central Management Server, you can run the same GRANT statement on all servers at the same time. Don't know whether it would work for the...

Or you can use the File System Task built into SSIS.

John

Grant SELECT permission on the objects it needs to read from, then. Depending on exactly what data you're trying to read, the VIEW DEFINITION permission might be appropriate.

John

What error message did you get when it failed the second time (after you had added the SQL Server Agent account to the target servers)? What does the package...

What is the data type of the coldate column?

Have you compared the execution plans for the two queries?

John

Has the user in question tried dropping any objects since you denied ALTER on the schema?

John

So you've tried DENY DELETE instead of DENY DROP?

john

OK, then you need to provide more information. Was this a one-off failure, or does it happen regularly? Does it always happen at the same time of day?...

Looks like Database Mail isn't correctly configured. There's plenty of information out there on how to set it up - here[/url]'s an example.

John

Is this a one-off, or are you going to have to do it regularly? If you're only doing it once, I don't think I'd bother with SSIS. Here's...