I created a Sql 7 test database for one of our developers. I made him dbo-equivalent for the database. When he creates a stored procedures (say "sp_doit") it lists him, not dbo, as the owner. His Sql code has lines like... " EXEC sp_doit" and the command
fails because it can't find the stored procedure.
1. I thought that "EXEC sp_doit" is equivalent to "EXEC dbo.sp_doit." He is dbo equivalent. Why doesn't it work?
2. For the moment, I execute "sp_changeobjectowner <username>.sp_doit', 'dbo'" and his code works. But I don’t want to do this routinely. Suggestion appreciated.