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
> >
> >
>

Database Name Environment Variable

Is there any environment variable that tells me what database I'm in on SQL
2000?
TIA,
CJ
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
>
|||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...
> SQL
>
|||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...
> SQL
>

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...
> SQL
>|||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...
> SQL
>sql

Database move

i've got to move 37 SQL Server databases over to new server. My manager tells me that i have to conduct some "check totals" to make sure that the databases contained exactly the same data from what it was when it got moved.

Is there some stored_procedure to do this ? to make sure that all the stored procedures, views, tables got move across ????? Are you kidding me. You detach the databases, then attach them on the new server. There's nowhere for the little data bytes to run and hide. Buy your manager a SQL Server book. :)|||How about sanity testing procedures ?
Write Count scripts to total database records. Is there literature on these kind of topics in SQL Server ?