Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Is DBN Globally Accessible to SP

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2002-09-30 : 18:07:11
I need to create a job in a SP, I'd like to use the DB name in the Job Name without passing it as a parameter.

Is the database name available somewhere to a SP?

SamC

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-09-30 : 19:07:52
select db_name()

HTH
Jasper Smith
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2002-09-30 : 22:06:37
Thanks Jasper,

Sam

Go to Top of Page
   

- Advertisement -