January 11, 2012 at 6:49 am
hi guys...
SQL Server 2008 R2 Standard Edition 64 Bit
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The SELECT permission was denied on the object 'sysdtspackages', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
please help....thnx
January 11, 2012 at 11:43 am
Is this being ran from a job? Sounds like the SQLAgent login doesn't have system db rights.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 16, 2012 at 6:00 am
hi saggi
follow this step mentioned in the website i hope it help u
http://rajeshssingh.blogspot.in/2010/02/exception-occurred-while-executing.html
if it works mean just reply me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply