Well, my experience is absolutely the opposite of James Travis - and is exactly what I would have expected!

Here is what I did, using Sql Server 2000 Sp2 under Windows 2000 professional Sp3:

- Opened Query Analyzer

- Typed in the following:

use master

go

create procedure sp_mysp as

select 'I am the master'

go

use miscellaneous

go

exec miscellaneous..sp_mysp

go

create procedure sp_mysp as

select 'I am NOT the master'

go

exec miscellaneous..sp__mysp

and got exactly the same as James

I am the master

I am NOT the master

- I closed Sql Server 2000 (SP2) down, then restarted it

- Then

use miscellaneous

go

exec miscellaneous..sp_mysp

STILL gives

I am NOT the master

- And

sp__mysp

ALSO gives

I am NOT the master

- And

use Maintenance

go

exec sp_mysp

gives

I am the master

So how do we explain these 2 sets of opposing results?