Stored procedures, tables and views created in the master database prefixed with sp_ can be accessed from any user database.
use master create table sp_user_data (col1 tinyint) insert into sp_user_data values(1) insert into sp_user_data values(2) insert into sp_user_data values(3) insert into sp_user_data values(4) use UserDatabase select * from sp_user_data
Published under: SQL Server Tips · · · ·