DownDate ? from SP4 to SP3

Sorry SUBJECT was backwards...
Can it be done' How can I UNDO my SQL2000 SP4 update and go back to SP3'
Does anybody know if that can be done'Unfortunately looks like there is no easy way to do that. See
3.8 Uninstall Database Components SP4
on
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm
Ben Nevarez, MCDBA, OCP
Database Administrator
"msnews.microsoft.com" wrote:
> Sorry SUBJECT was backwards...
> Can it be done' How can I UNDO my SQL2000 SP4 update and go back to SP3'
> Does anybody know if that can be done'
>
>

DownDate ? from SP3 to SP4

Can it be done' How can I UNDO my SQL2000 SP4 update and go back to SP3'
Does anybody know if that can be done'Check out:
HOW TO: Remove a SQL Server Service Pack
http://support.microsoft.com/kb/314823/en-us
HTH
Jerry
"msnews.microsoft.com" <breichenbach@.istate.com> wrote in message
news:OqkGe7EgGHA.4080@.TK2MSFTNGP03.phx.gbl...
> Can it be done' How can I UNDO my SQL2000 SP4 update and go back to
> SP3'
> Does anybody know if that can be done'
>|||Be aware that support for SP3a ends in July 2006
(http://support.microsoft.com/gp/lifesupsps).
Perhaps there is a hotfix avialable to address the issue you are having.
Check out http://support.microsoft.com/kb/894905/
Hope this helps.
Dan Guzman
SQL Server MVP
"msnews.microsoft.com" <breichenbach@.istate.com> wrote in message
news:OqkGe7EgGHA.4080@.TK2MSFTNGP03.phx.gbl...
> Can it be done' How can I UNDO my SQL2000 SP4 update and go back to
> SP3'
> Does anybody know if that can be done'
>

DownDate ? from SP3 to SP4

Can it be done' How can I UNDO my SQL2000 SP4 update and go back to SP3'
Does anybody know if that can be done'Check out:
HOW TO: Remove a SQL Server Service Pack
http://support.microsoft.com/kb/314823/en-us
HTH
Jerry
"msnews.microsoft.com" <breichenbach@.istate.com> wrote in message
news:OqkGe7EgGHA.4080@.TK2MSFTNGP03.phx.gbl...
> Can it be done' How can I UNDO my SQL2000 SP4 update and go back to
> SP3'
> Does anybody know if that can be done'
>|||Be aware that support for SP3a ends in July 2006
(http://support.microsoft.com/gp/lifesupsps).
Perhaps there is a hotfix avialable to address the issue you are having.
Check out http://support.microsoft.com/kb/894905/
Hope this helps.
Dan Guzman
SQL Server MVP
"msnews.microsoft.com" <breichenbach@.istate.com> wrote in message
news:OqkGe7EgGHA.4080@.TK2MSFTNGP03.phx.gbl...
> Can it be done' How can I UNDO my SQL2000 SP4 update and go back to
> SP3'
> Does anybody know if that can be done'
>

Does there have any undo or rollback function in SQL server?

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.As you have posted a question in the articles section it is being moved to SQL Server Forum.|||

Quote:

Originally Posted by debasisdas

As you have posted a question in the articles section it is being moved to SQL Server Forum.

sorry.. and thank you.|||

Quote:

Originally Posted by Gison

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.

im my case i have a backup routine which runs every night, can you not restore from a backup?|||

Quote:

Originally Posted by Gison

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.

yes. you can use transaction to handle this situation.
some commands are there

BEGIN TRANSACTION
<sql code>
COMMIT / ROLLBACK TRANSACTION

for more use the msdn help.|||You can always rollback the transaction before commiting it.

Does the Undo operation work ?

Hi ,

I was working in the SSIS designer and when I found that the DataFlow task I deleted was indeed something I needed, I tried to Undo the operation but Alas the option is not enabled :(

Is there a way we can undo the operations?

as such I guess there is no way u can undo any changes. best possible way, work in Foundation server and keep checking in whenever you feel you are completed.

Does the Undo operation work ?

Hi ,

I was working in the SSIS designer and when I found that the DataFlow task I deleted was indeed something I needed, I tried to Undo the operation but Alas the option is not enabled :(

Is there a way we can undo the operations?

as such I guess there is no way u can undo any changes. best possible way, work in Foundation server and keep checking in whenever you feel you are completed.