In SQL 2005, how do I convince a stored procedure or function installed in the master db to use the local db context when executing?
Under SQL 2000 (and earlier) you can set the system bit via "EXEC sp_MS_upd_sysobj_category 1", install the proc and set it back to 0. This isn't available in 2005 because of the changes to the meta-data
In SQL 2005 the non-user (system) procs have the is_ms_shipped bit set which is the only difference I can see between system and user procs in master.
Can I set this bit or is there another (more correct?) way to achieve the same results?
I expect there is something obvious that I am missing.
Under SQL 2000 (and earlier) you can set the system bit via "EXEC sp_MS_upd_sysobj_category 1", install the proc and set it back to 0. This isn't available in 2005 because of the changes to the meta-data
In SQL 2005 the non-user (system) procs have the is_ms_shipped bit set which is the only difference I can see between system and user procs in master.
Can I set this bit or is there another (more correct?) way to achieve the same results?
I expect there is something obvious that I am missing.