Reverting from SP2 to SP1

Hi all,
If i have installed SP2 for reporting services and need to revert back to
Reporting Services with SP1. Is this possible without inplications?
Am i able to remove SP2 and reinstall SP1 and have the normal functioanlity
of SP1 or would i have problems. If anyone has tried this please let me know
of your findings
--
Thanks in advance,
Dave HuntFrom the SP2 Readme:
3.5 Removing SP2
To revert to the version that you were running before installing SP2, you
must uninstall Reporting Services and then reinstall it without applying
SP2 afterwards. There is no separate uninstall program for SP2. If you
applied a Quick Fix Engineering (QFE) fix to your RTM or SP1 Reporting
Services installation, you must reapply that QFE fix to the instance. To
uninstall Reporting Services, use Add or Remove Programs in Control Panel.
Note that the report server database, upgraded to the SP2 format, is not
removed when you uninstall the product. You must manually remove the SP2
version of the report server database and restore the version that was part
of the pre-SP2 installation.
| Thread-Topic: Reverting from SP2 to SP1
| thread-index: AcVsG1EcmzbXYT1VSfKmwPFQnrbMDg==| X-WBNR-Posting-Host: 217.44.106.122
| From: "=?Utf-8?B?RHVzdHBhbkRhdmU=?="
<DustpanDave@.discussions.microsoft.com>
| Subject: Reverting from SP2 to SP1
| Date: Wed, 8 Jun 2005 04:15:03 -0700
| Lines: 12
| Message-ID: <59DDE962-4D36-4889-8106-58DDE3C8BD17@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45534
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi all,
|
| If i have installed SP2 for reporting services and need to revert back to
| Reporting Services with SP1. Is this possible without inplications?
|
| Am i able to remove SP2 and reinstall SP1 and have the normal
functioanlity
| of SP1 or would i have problems. If anyone has tried this please let me
know
| of your findings
|
| --
| Thanks in advance,
| Dave Hunt
|

Reverting back to Windows Authentication

Hi,
Does anyone know if and how easy it is to revert back to just Windows
authentication on the sql server from Mixed Mode ?
Thanks,
Luke.Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>|||Be aware that it does require a SQL Service restart. If you don't have EM
look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e9hZmLzlDHA.2536@.tk2msftngp13.phx.gbl...
Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>

Revert to checkpoint

Hi,
Our application has an automatic software update feature.
We want to create a checkpoint (certain point in time) in the database
in order to revert to this checkpoint when somewhere in the software
update sequence error(s) occur...
Is this possible in MSSQL?
Transaction blocks are not possible because queries are executed from
different parts of our code...
Thanks in advance,
Greetz,
R. Oosterholt
Hi
Your code sounds to be a nightmare especially as this is a software upgrade.
I suggest that you backup the database at given points so that you can
restore to a known point, or instigate a mechanism that you can log the times
when you can recover to a known point in time.
John
"r.oosterholt@.gmail.com" wrote:

> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>
|||r.oosterholt@.gmail.com wrote:
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>
If you're doing regular transaction log backups, you can restore a
database to any point in time using the STOPAT clause on the RESTORE
command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegr oups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
>
Can you just take a full database backup, and restore the backup on failure?
Also on Enterprise Edition, you can take a Database Snapshot, and restore
from that.
David
|||Thanks all!
Snapshot is the best option for us.
Pity it is only available in 2005 EE...
Rick O.
On 17 nov, 17:25, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you later can restore to that
> point when you restore a transaction log backup. Assumes a sound backup strategy, of course.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> <r.oosterh...@.gmail.com> wrote in messagenews:1163779835.179635.247540@.b28g2000cwb.g ooglegroups.com...
>
>
>
>

Revert to checkpoint

Hi,
Our application has an automatic software update feature.
We want to create a checkpoint (certain point in time) in the database
in order to revert to this checkpoint when somewhere in the software
update sequence error(s) occur...
Is this possible in MSSQL?
Transaction blocks are not possible because queries are executed from
different parts of our code...
Thanks in advance,
Greetz,
R. OosterholtHi
Your code sounds to be a nightmare especially as this is a software upgrade.
I suggest that you backup the database at given points so that you can
restore to a known point, or instigate a mechanism that you can log the times
when you can recover to a known point in time.
John
"r.oosterholt@.gmail.com" wrote:
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||r.oosterholt@.gmail.com wrote:
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>
If you're doing regular transaction log backups, you can restore a
database to any point in time using the STOPAT clause on the RESTORE
command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
>
Can you just take a full database backup, and restore the backup on failure?
Also on Enterprise Edition, you can take a Database Snapshot, and restore
from that.
David|||One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you later can restore to that
point when you restore a transaction log backup. Assumes a sound backup strategy, of course.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||Thanks all!
Snapshot is the best option for us.
Pity it is only available in 2005 EE...
Rick O.
On 17 nov, 17:25, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you later can restore to that
> point when you restore a transaction log backup. Assumes a sound backup strategy, of course.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> <r.oosterh...@.gmail.com> wrote in messagenews:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
>
> > Hi,
> > Our application has an automatic software update feature.
> > We want to create a checkpoint (certain point in time) in the database
> > in order to revert to this checkpoint when somewhere in the software
> > update sequence error(s) occur...
> > Is this possible in MSSQL?
> > Transaction blocks are not possible because queries are executed from
> > different parts of our code...
> > Thanks in advance,
> > Greetz,
> > R. Oosterholt- Tekst uit oorspronkelijk bericht niet weergeven -- Tekst uit oorspronkelijk bericht weergeven -

Revert to checkpoint

Hi,
Our application has an automatic software update feature.
We want to create a checkpoint (certain point in time) in the database
in order to revert to this checkpoint when somewhere in the software
update sequence error(s) occur...
Is this possible in MSSQL?
Transaction blocks are not possible because queries are executed from
different parts of our code...
Thanks in advance,
Greetz,
R. OosterholtHi
Your code sounds to be a nightmare especially as this is a software upgrade.
I suggest that you backup the database at given points so that you can
restore to a known point, or instigate a mechanism that you can log the time
s
when you can recover to a known point in time.
John
"r.oosterholt@.gmail.com" wrote:

> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you l
ater can restore to that
point when you restore a transaction log backup. Assumes a sound backup stra
tegy, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||r.oosterholt@.gmail.com wrote:
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>
If you're doing regular transaction log backups, you can restore a
database to any point in time using the STOPAT clause on the RESTORE
command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
>
Can you just take a full database backup, and restore the backup on failure?
Also on Enterprise Edition, you can take a Database Snapshot, and restore
from that.
David|||Thanks all!
Snapshot is the best option for us.
Pity it is only available in 2005 EE...
Rick O.
On 17 nov, 17:25, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you
later can restore to that
> point when you restore a transaction log backup. Assumes a sound backup st
rategy, of course.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
> <r.oosterh...@.gmail.com> wrote in messagenews:1163779835.179635.247540@.b28
g2000cwb.googlegroups.com...
>
>
>
>
>
>
>

Revert Question

how do we change the value of specific column?(not updating).

for example the value of ID 01 - 03 is 1 and ID 04 and 05 is 0. how do we revert it?

in one statement only

Table1

ID Value

01 1

02 1

03 1

04 0

05 0

One of many solutions that's possible

Code Snippet

declare @.t table ( cid int, cnum int)
insert @.t select 1, 1
insert @.t select 2, 1
insert @.t select 3, 1
insert @.t select 4, 0
insert @.t select 5, 0

select * from @.t

select cid,
case cnum
when 1 then 0
when 0 then 1
end
from @.t

Revert dropped Table. Have nay way? How?

Hi all,
Revert dropped Table. Have nay way? How?
Thanks, thanks..."retf" <re.tf@.terra.com.br> wrote in message
news:eeVL$OCfGHA.2032@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> Revert dropped Table. Have nay way? How?
>
>
Restore a backup of the database and grab the table from there.
David|||Hello,
I agree with David that restoration from backup shall be the best option
here.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Revert dropped Table. Have nay way? How?

Hi all,
Revert dropped Table. Have nay way? How?
Thanks, thanks..."retf" <re.tf@.terra.com.br> wrote in message
news:eeVL$OCfGHA.2032@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> Revert dropped Table. Have nay way? How?
>
>
Restore a backup of the database and grab the table from there.
David|||Hello,
I agree with David that restoration from backup shall be the best option
here.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.