Determining Current database 1

[Persmd]

Is there a stored procedure or system function that returns the name of the database that an object is in?

In other words, if I implicitly call a stored procedure that only exists in [mytest]..[mysp], can [mysp] determine that it belongs to the database [mytest]?

Thanks,
Michael

 

[NoCoolHandle]

select db_Name()

 

[Persmd]

Thanks NoCoolHandle. That's exacxtly what I wanted, just too tired to remember, or find it.

Michael

I feel a lot more like I do now...
than I did when I first got here!

Michael