This is probably a stupid question, and while I have worked with SQL Server since version 7, I've never had an issue with this previously, as I've always had access to a dbo user, so it wasn't a problem. I created two database (and thus two users) because I wanted to have my DNN install isolated from my other data, but now, I need to either move my tables from one database to the other (and consolidate) or access my DNN database from my non-DNN database. Obviously, with the way the users are setup, each DB user can't see the other database. So, is there anyway around this issue? I guess I could do a dump and import if I had to, but I'd prefer not to have to do that if possible. Thanks for any advice/suggestions.
No, I'm afraid there is no other way around it. Because each db user is a dbo to its own database you cannot simply connect to one database unto another. I'm afraid the most simplest way to do this is to use the database publishing wizard and script out the tables and data you want to move over. http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx