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!
> >
>
>
Showing posts with label separate. Show all posts
Showing posts with label separate. Show all posts
Monday, March 19, 2012
How can you tell if SP1 was applied?
How can you get the current database name via T-SQL?
I have stored some commonly used sprocs and user-defined functions I have created in a separate db.
Some of these functions work with the current db sysobjects table, for instance, and need to "know" the database that I am calling the sproc/function from.
Is there anyway to return the current database name via T-SQL to assign to a local variable which I can then include in the procedure/function execute statement?
Bill
Use the system function: db_name().
SELECT db_name()
|||
Code Snippet
select db_name()
|||Thanks so much. I knew is was probably simple, just couldn;t find it in the T-SQL help.
Subscribe to:
Posts (Atom)