Hello Group,

I have code in stored procedures that create tables, populate tables, and run select statements on these tables. When I developed these on my server I was the sa and every table was [dbo].tablename when I transfered the stored procedures to their test server I logged on as MasterTester and all the tables were now [MasterTester].tablename. Now none of the select statement work because they cannot find [dbo].tablename.

How do I write procedures that create tables where anyone can sign on and use them to create tables that select statements will still work.

Thanks
Jim