I have SQL database hosted by my ISP. Every now and again we log on and create new tables using user XXX1. After getting a backup of the database, I have restored it on my local machine. When running the application on local, I get an error because there is a new user in database called XXX1.
I would like to change the user from XXX1 to dbo on my local machine for all tables, stored procedures and views. How do I do this easily?
Thanks in advance!
Dave
Hi,
http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/f1625d70fb765701
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment