>my server got 10 database , and a lot of SP
>in some sp, I need to put its database name in tables.
>How can I get the database in the SP programingically ?
>
>Thanks
SELECT DB_NAME()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.