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
|

Returning First Day of Week

Running SQL 2005 SP2.
I am wondering if there is a simple script or function that, for a given date,
I will get returned the previous Sunday at midnight?
For example, if my given date is today (Wednesday, February 6, 2008), my
return value would be 2/3/2008 00:00:00.000.
Message posted via http://www.droptable.com
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:7f58a15d04fbc@.uwe...
> Running SQL 2005 SP2.
> I am wondering if there is a simple script or function that, for a given
> date,
> I will get returned the previous Sunday at midnight?
> For example, if my given date is today (Wednesday, February 6, 2008), my
> return value would be 2/3/2008 00:00:00.000.
> --
> Message posted via http://www.droptable.com
>
DECLARE @.dt DATETIME;
SET @.dt = CURRENT_TIMESTAMP;
SELECT DATEADD(DAY,7*FLOOR(DATEDIFF(DAY,'20000102',@.dt)/7.0),'20000102');
David Portas

Returning First Day of Week

Running SQL 2005 SP2.
I am wondering if there is a simple script or function that, for a given date,
I will get returned the previous Sunday at midnight?
For example, if my given date is today (Wednesday, February 6, 2008), my
return value would be 2/3/2008 00:00:00.000.
--
Message posted via http://www.sqlmonster.com"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:7f58a15d04fbc@.uwe...
> Running SQL 2005 SP2.
> I am wondering if there is a simple script or function that, for a given
> date,
> I will get returned the previous Sunday at midnight?
> For example, if my given date is today (Wednesday, February 6, 2008), my
> return value would be 2/3/2008 00:00:00.000.
> --
> Message posted via http://www.sqlmonster.com
>
DECLARE @.dt DATETIME;
SET @.dt = CURRENT_TIMESTAMP;
SELECT DATEADD(DAY,7*FLOOR(DATEDIFF(DAY,'20000102',@.dt)/7.0),'20000102');
--
David Portas|||When I am working with dates I always stick in an auxillary calendar
table, this is very useful in quickly finding days of weeks etc.
http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html