General discussion

Locked

SQL Server

By Eminent87 ·
Hi,

Is there a way to uninstall a patch that was installed previously? We are running a software called Kemma Bridge Track 4.0 and after installing the SQL SP4, user cannot log into the database anymore. Does anybody have any suggestions??

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server

by Joseph Moore In reply to SQL Server

This comes from the SQL Server SP4 readme:

"1.2 Removing SP4
SP4 cannot be removed easily because of system table changes that the service pack requires for maintenance. To revert to a build before SP4 was installed, you must remove and reinstall SQL Server 7.0 or MSDE 1.0 and, if required, apply the service pack (SP1, SP2, or SP3) that you were running before you installed SP4. Before you reinstall SQL Server 7.0 or MSDE 1.0, detach your databases on SP4 and reattach them after you reinstall SQL Server 7.0 or MSDE 1.0 and either SP1, SP2, or SP3. For information about using sp_attach_db and sp_detach_db, see SQL Server Books Online for SQL Server 7.0. As with any new installation, you must re-create the necessary logins. You must alsore-create scheduled tasks dependent on information in the msdb database, in addition to any changes you have made in the model database. If you use replication, you must completely reconfigure replication."

Here is the URL to this readme:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/support/servicepacks/SQL/7.0/sp4ReadMe.asp
(please remove any spaces)

hope this helps

Collapse -

SQL Server

by Eminent87 In reply to SQL Server

Poster rated this answer

Collapse -

SQL Server

by Eminent87 In reply to SQL Server

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums