[dba-SQLServer] REVOKE

I would think an "access denied" issue would usually generate an error 
rather than hang the connection but I have never had to use a REVOKE ALL in 
a DTS before.   which database revoking taking place?  Is it revoking all 
permissions in the MASTER db?  maybe it is hanging the application that is 
executing DTS.


>From: Mark.Whittinghill at protective.com
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] REVOKE
>Date: Tue, 4 Oct 2005 15:00:12 -0500
>
>I have a DTS that has a REVOKE ALL step on a table.  If that table is open
>by a user when that step runs, should I expect an error, or expect it to
>just hang?  I am asking because this package hung on this step recently,
>and I am trying to isolate if that is the cause.
>
>Mark Whittinghill
>Sr. Programmer Analyst
>Protective - Asset Protection Division
>636.536.5720
>Mark.Whittinghill at protective.com
>
>
>-----------------------------------------
>Confidentiality Notice: This e-mail communication and any attachments
>may contain confidential and privileged information for the use of the
>designated recipients named above. If you are not the intended
>recipient, you are hereby notified that you have received this
>communication in error and that any review, disclosure, dissemination,
>distribution or copying of it or its contents is prohibited. If you
>have received this communication in error, please notify me immediately
>by replying to this message and deleting it from your computer. Thank
>you.
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>