October 15, 2013 at 10:39 am
Background:
We are Implementing SP3 for SQL Server 2008 and are required to provide a backout plan. To backout SP3 we uninstall SQL Server and re-install SQL Server 2008 base and SP1.
After the database is restored vendor application Stored Procedures no longer run correctly when executed as the 'dbo'. Specifically the sp runs DBCC loginfo and errors with "User 'dbo' does not have permission to run DBCC LOGINFO. [SQLSTATE 42000] (Error 50000)." The 'dbo' for the database is the 'sa' account on the instance.
If I login as 'sa' and run the command it has no issues. If the sp is executed in the very same query window if fails as above.
Any help would be greatly appreciated.
October 15, 2013 at 11:47 am
to avoid this problem in the first place your backout plan should be to uninstall SP3, thus taking you back to SP1. there is no need to do a reinstall.
---------------------------------------------------------------------
October 15, 2013 at 11:51 am
George,
Can you point me to something on how to do that. I'd much prefer to just uninstall SS2008 SP3, but haven't found it yet.
Thanks for your help.
Jim
October 15, 2013 at 12:00 pm
Its pretty simple and is available from SQL2008 on - just go to add\remove programs, make sure the 'show updates' check box is ticked, select SP3 and choose remove, (i think thats the word used) then uninstall it. Takes you through screens that look like the install process. Accept defaults all the way through.
what you should also be doing is taking backups of all databases (including the resource database) before you start the upgrade.
Googling 'uninstall service pack SQL' will bring up lots of links confirming this
good Luck.
---------------------------------------------------------------------
October 15, 2013 at 12:07 pm
George
Thank you very much. I Guess I've just 've just been searching for it the wrong way.
Sorry to bother everyone.
October 15, 2013 at 12:08 pm
no bother.
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply