Well, the old database is 2000 so there isn't a schema, but it is owned by dbo, which is how it is restored.

What does it mean for a group to...

Hey Gail,

What you are saying is exactly what is happening. When my stored proc ends, it deletes the temp tables even when I remark out the DROP statement.

What I...

I thought about doing that, but I was hoping maybe there was a switch in Management Studio that set it back to the way it worked in 2000 Query Analyzer.

So...

They were both 2000 originally, uninstalled 2k, installed 2k5 as default, and went back and installed 2k as named instance.

I'm not sure what might be different from them, but specifying...

These are all stored procedures in the same database. Granting permissions to each sp or to the whole schema are all well and good, but we were hoping to...

Awesome! I've seen that many times and wondered what it was. Thanks for filling in the blanks there.