December 24, 2004 at 2:31 pm
I moved via backup and restore a database from one SQL server
to another. The backup proceeded fine, the restore is fine, dbcc checkdb matches up with the old database for # of rows and such. I used sp_changes_user_login to fix one of the logins, and set the dbowner to the proper account.
WHenever I go to Enterprise manager to view this database tho, I get the error that there are errors runnign scripts on this page, and then most of the info comes up blank. The tabs across the top on the task page come up "undefined", etc.
It almost seems like a permissions problem, but queries against the database work fine, queries from the application work fine, so I'm missing something.
Other datbases in Enterprise manager work fine. It's just this one that I've restored. Any ideas? thanks in advance.
December 26, 2004 at 8:28 am
Hey.
If you mean that when you use right click, view>>taskpad you get this error,
than it's a known problem. Instead do this:
Right click view>>detail
and then
Right click view>>taskpad
yoav.
December 26, 2004 at 4:39 pm
Hmph. That worked, I dont' believe I've ever seen this before.
Maybe I do view details first normally... It's been a while.
Thanks for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply