Wednesday, February 15, 2012

Enterprise manager

hi,
I used backup and restore moved a database from one server to another.
Everything works fine. But I got problem view the taskpad of the database. I
could view it from another server but not this server.
right after restore I could view it but after close EM and reopen , I got
this error when trying to view the taskpad of the database:
Internet Explorer script error:
An error has occurred in the script on this page:
Line: 307
Char: 2
Error: unspecified error
Code: 0
URL:
res://c:\Program%20Files\Microsoft%20SQL%20server\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.html
Could you please help!!
Thanks
Kathy ChenHi Kathy.
Hopefully someone will give you a more precise answer to the actual problem
you're experiencing, but my 20c worth on this is that you probably shouldn't
become too dependant on the MMC SnapIn TaskPads. If you search the archive
of this newsgroup you'll find a trail of destruction from others trying to
use the TaskPad views - they simply don't work very reliably. There's lots
more on this in microsoft.public.management.mmc as well.
Another thing that often fails with Task Views is in the "Table Info" tab -
this view often won't let you scroll to the next page - often the next page
nav tools are missing. It's a really nice feature, but it just doesn't work
reliably, imho. My work around to that problem was simply to use profiler to
grab what the EM was sending to the server, saved it as a script & you get
the same information.. (c:
Regards,
Greg Linwood
SQL Server MVP
"Kathy" <kathy_chen@.hotmail.com> wrote in message
news:e8SWyCEyDHA.536@.tk2msftngp13.phx.gbl...
> hi,
> I used backup and restore moved a database from one server to another.
> Everything works fine. But I got problem view the taskpad of the database.
I
> could view it from another server but not this server.
> right after restore I could view it but after close EM and reopen , I got
> this error when trying to view the taskpad of the database:
>
> Internet Explorer script error:
> An error has occurred in the script on this page:
> Line: 307
> Char: 2
> Error: unspecified error
> Code: 0
> URL:
>
res://c:\Program%20Files\Microsoft%20SQL%20server\80\Tools\Binn\Resources\10
> 33\sqlmmc.rll/Tabs.html
> Could you please help!!
> Thanks
> Kathy Chen
>
>|||Hi Kathy,
There's a very simple workaround for the scripting error you'r
encountering in Enterprise Manager.
Just right-click on the DB, click view, then click list to display th
DB objects. Go back, right-click on the DB, click view, then clic
Taskpad. It will reset the web interface and it'll work again.
Yes, another stupid bug in MSSQL SQL Server.
Best Regards,
Chuck Lee
chucksql@.hotmail.co
-
chuckle
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message205074.htm

No comments:

Post a Comment