December 18, 2007 at 1:04 pm
I've got a few users that can't see any jobs when using Management Studio to administer SQL2000 jobs. I can open Enterprise Manager and view them fine, but not with Management Studio. Is there a bug that I'm unaware of?
Here's the error it gives:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
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)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0818&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
Any help would be appreciated!
Thanks,
December 18, 2007 at 2:00 pm
Couple of questions - what version of management studio are they using (i.e. express, developer, standard, enterprise)? What build of management studio are they running (i.e. SP1, SP2a)?
Tommy
Follow @sqlscribeDecember 18, 2007 at 2:01 pm
I'm not sure how to tell if it's standard vs. enterprise. It's build number is 9.00.3042. So, I think that's SP2.
December 18, 2007 at 2:15 pm
Shouldn't really matter as long as it isn't express edition - it isn't correct?
Tommy
Follow @sqlscribeDecember 18, 2007 at 2:16 pm
correct, it is NOT express edition.
December 20, 2007 at 9:31 am
Has anybody else seen this issue?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply