Reply to Re: T-SQL Debugger Error

Your name:

Reply:


Posted by Greg D. Moore \(Strider\) on 04/25/07 11:57

"Rahul" <verma.career@gmail.com> wrote in message
news:1177496846.397898.39610@r30g2000prh.googlegroups.com...
> Hi,
>
> When I debug our sp by using T-SQL Debugger, I got following error.
>
> Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission
> denied on object 'sp_sdidebug', database 'master', owner 'dbo'.
>
>
> and when I grant the permission of sp_sdidebug, I got following error.
>
> Server: Msg 4610, Level 16, State 1, Line 1
> You can only grant or revoke permissions on objects in the current
> database.
>
>
> I am using following statement to grant the permission.
>
> GRANT EXECUTE
> ON sp_sdidebug
> TO myuser
>
> Here, I want to clear, myuser is I, which one i log QA.
> and myuser has public and dbowner permission
>
> --
> Rahul
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация