Showing posts with label tia. Show all posts
Showing posts with label tia. Show all posts

Thursday, March 29, 2012

Database Name Environment Variable

Is there any environment variable that tells me what database I'm in on SQL
2000?
TIA,
CJSELECT DB_NAME()
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:O%23n%234WSsEHA.2252@.TK2MSFTNGP11.phx.gbl...
> Is there any environment variable that tells me what database I'm in on
SQL
> 2000?
> TIA,
> CJ
>|||Much appreciated.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23y%23S6fSsEHA.2632@.TK2MSFTNGP10.phx.gbl...
> SELECT DB_NAME()
>
> "CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
> news:O%23n%234WSsEHA.2252@.TK2MSFTNGP11.phx.gbl...
> > Is there any environment variable that tells me what database I'm in on
> SQL
> > 2000?
> >
> > TIA,
> > CJ
> >
> >
>|||Apologies for the multi post, realized after the fact it may be more of a
.programming question rather than a .server question.
Again, sorry.
-CJ
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23y%23S6fSsEHA.2632@.TK2MSFTNGP10.phx.gbl...
> SELECT DB_NAME()
>
> "CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
> news:O%23n%234WSsEHA.2252@.TK2MSFTNGP11.phx.gbl...
> > Is there any environment variable that tells me what database I'm in on
> SQL
> > 2000?
> >
> > TIA,
> > CJ
> >
> >
>