If you want to release space on disk then you need to shrink the database. See DBCC SHRINKDATABASE. Beware, though - if your database is likely to grow...

That'll revoke the deny, but won't necessarily restore the permission. You'll need to do an explicit GRANT if the user doesn't have the permission through any other avenue.

John

Nobody has so far commented on the four distinct values in your column. In one of Gail's articles that you're about to read, it says this:

It usually works out...

Didn't we go through this yesterday?

John

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