Windows authentication. I am able to run other packages except this one package.

Are you using a UNC path?

Yes Phil.

Agent service account has been granted Local Launch and Local activation permissions and I am able to run from the agent now.

Still...

The package writes log files to a shared directory and agent service account has write permissions on the share.

"Log messages about completion of process. Error: Exception has been thrown...

Hi Perry,

Unfortunately its not scripting out all users. script end like this. (missing script)

EXEC sp_addrolememb

--Finished!

--Please ensure you check the script output before executing

--against your target database.

Thanks Phil!

Thanks Hugo. Is there a simple way to deny permissions on few columns on all tables on a database for all users except sysadmins.

Thanks Hugo. You helped me in this initially. I will keep these similar requirements in a single thread in future.

Thanks a lot Jack!

Few changes to requirement.

Additionally I need to update couple of columns after update for audit(user/date). Also on insert the audit columns for create user/date has to be updated. Can you...

Thanks Lynn!

Thanks Phil!

Thanks Lowell!

Thanks Phil. Can I accomplish this with just one update trigger?

Can you give me a logic for the update trigger. The script below is not working as intended.

--Column name(use...

Hi Hugo, I have made some changes to the trigger so that users won't be able to make updates on the audit columns.

Can you please take a look into this...

Thanks a lot Alan! Will the update also fails if an empty string is passed?