If I create a stored procedure in the master database, and I want to execute it from any of my databases I just follow this link:
that give me this code example:
Just by following the example above, I can call my procedure from any database.
what about if I create a table data type in master, how can I use it in any of my databases?
use master IF NOT EXISTS (select * from sys.types where name = 'theReplicatedTables') CREATE TYPE theReplicatedTables AS TABLE ( OBJ_ID INT NOT NULL, PRIMARY KEY CLUSTERED (OBJ_ID) ); use APIA_Repl_Sub go declare @the_tables [dbo].[theReplicatedTables]