This is what I have tried so far. It didn't work on SQL2k
--ensure no proc exists already
if object_id('dbo.test') is not null
drop proc dbo.test
if object_id('test') is not null
drop proc test
--create proc - goal is to have it created w/dbo as owner
--but w/out explicitly saying 'dbo.'
--the account that used to run this cannot be a member of sysadmins
create proc test
--did we create it?