How can you tell if SP1 was applied?

Especially in a multi-server environment where I have RS installed with
separate servers for the DB and IIS Report Manager.
I'm guessing there's some kind of @.@.version or version number hidden
somewhere, but where?
I am inheriting a deployment from a previous dba and I don't know if
SP1 was ever installed.
TIA!Go to http://yourserver/Reportserver
It should show version this at the bottom of the page displayed:
Microsoft SQL Server Reporting Services Version 8.00.878.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave" <macleary2000@.yahoo.com> wrote in message
news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> Especially in a multi-server environment where I have RS installed with
> separate servers for the DB and IIS Report Manager.
> I'm guessing there's some kind of @.@.version or version number hidden
> somewhere, but where?
> I am inheriting a deployment from a previous dba and I don't know if
> SP1 was ever installed.
> TIA!
>|||Found it. Thank you.
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> It should show version this at the bottom of the page displayed:
> Microsoft SQL Server Reporting Services Version 8.00.878.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave" <macleary2000@.yahoo.com> wrote in message
> news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> > Especially in a multi-server environment where I have RS installed with
> > separate servers for the DB and IIS Report Manager.
> >
> > I'm guessing there's some kind of @.@.version or version number hidden
> > somewhere, but where?
> >
> > I am inheriting a deployment from a previous dba and I don't know if
> > SP1 was ever installed.
> >
> > TIA!
> >
>
>

How can I use the last recordset in a SP that return 3 recordsets ?

Hello,

I have a SP1 that is calling another SP2,
SP2 is using select and returning records

So in SP1 I get 3 different record sets
(as I can see it on Query Analyzer - one after the other)

When I'm trying using the ASP page I get this error:
"Item cannot be found in the collection corresponding to the requested name or ordinal."

How can I access the last recordset ?If you really mean ASP.NET, the DataReader has a NextResult method that can get you from result set 1 to 2, and then to three.|||Thanks, but actually I need to do it on ASP,

what is the eqvivalent for ASP ?

H - E - L - P|||ADO has a NextRecordset method:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp

This is really an ASP.NET forum, so other places may be better for info on ADO classic...

How can I use SMo in VS 2002 SP1 c# applications?

I have got error: cannot add reference to Microsoft.sqlserver.smo.dll .....

I understand VS2005 is bettrer than VS2002 but I have what I have.

Thank you.

You need VS2005 as SMO depends on .NET Framework 2.0.|||

what if i install Framework 2.0 on Visual Studio 2003?