Question

Temporary stored procedures are stored in which database

Answer 1

$\textnd{HELLO DEAR}$


Temporary stored procedures on Microsoft SQL Server are prefixed with a pound sign #

One pound sign means that its temporary within the session two pound signs ## means its a global temporary procedure, which can be called by any connection to the SQL server during its lifetime.