>Hi
>
>I want to pass a database name into my stored procedure and then use that database for everything that the stored procedure does.
>
>Whats the syntax for that ?
>
>Thanks
You must use so called Dynamic SQL.
BTW why you need this?
If you call Database SP it will be executed for that DB, no matter to which DB you are connected.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.