General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only