Grant Insert Permission Freezing

I have one table that I cannot grant permissions on.
I have tried through Enterprise Manager and by executing at statement
like:
GRANT SELECT on dbo.YYY to ThisRoleName
I am db owner. I kicked everyone out of the database so I am the only
person in there. I can grant permissions to any other table in the
database. But when I try to grant permissions to table YYY the
request eventually times out.
Any ideas would be most appreciated!Run SQL Server Profiler to see what is going on while you grant permission
<juustagirl@.yahoo.com> wrote in message
news:1186787274.633524.104620@.q3g2000prf.googlegroups.com...
>I have one table that I cannot grant permissions on.
> I have tried through Enterprise Manager and by executing at statement
> like:
> GRANT SELECT on dbo.YYY to ThisRoleName
> I am db owner. I kicked everyone out of the database so I am the only
> person in there. I can grant permissions to any other table in the
> database. But when I try to grant permissions to table YYY the
> request eventually times out.
> Any ideas would be most appreciated!
>|||Execute sp_who to list current activity. Perhaps there is a rogue process
blocking your request.
Hope this helps.
Dan Guzman
SQL Server MVP
<juustagirl@.yahoo.com> wrote in message
news:1186787274.633524.104620@.q3g2000prf.googlegroups.com...
>I have one table that I cannot grant permissions on.
> I have tried through Enterprise Manager and by executing at statement
> like:
> GRANT SELECT on dbo.YYY to ThisRoleName
> I am db owner. I kicked everyone out of the database so I am the only
> person in there. I can grant permissions to any other table in the
> database. But when I try to grant permissions to table YYY the
> request eventually times out.
> Any ideas would be most appreciated!
>