Well that's pretty much it. I discovered this when I added tables to a database from within VS2K5. The tables are visible in VS but not in the server management studio.
To clarify further...I added a db to a website in VS. I then used the server management studio to delete tables from the db. They appear to be gone in server management studio, but are still visible within VS, even after a refresh and shut down/restart of VS.
I don't get it. What am I missing here? This is killing me.
Any thoughts?
The only other thing I can think to add is that I originally created the db in question from within VS2K5. I did nothing I am aware of to make it act differently than any other db. So why it shows up in the server management studio but changes I make aren't consistently maintained between there and VS2K5, I do not understand.
TIA - Regards,
Joe
>>Any thoughts?
It sounds like you have two separate databases. Try searching your hard drive for all *.mdf files (you'll need to use search's advanced options and enable searching for System folders.
|||OK now I am even more confused...
I do more than one copy. But WHY? I initially created this database from within VS2K5. I ended up scrapping the project I used to create it, but kept the database. I then created a new project in VS2K5. I added an existing item, not created new, and added the database to the new project. So how am I getting a second, third etc. copy, and why? Should the added database not actually be the original database? Or is there a setting somewhere I turned on and didn't know that causes a new instance to be created?
Because of my ignorance on the issue, I have no idea how to resolve this.
Thanks
Joe
|||Hi,
Are you using the Server Explorer to check your database in VS2005? If so, please right click on the server, and click refresh to refresh the treeview.
If not, please let me know where you find the change does not take effect in VS2005.
Thanks!
|||I think I have this sorted out, although I am not yet clear on why it happened.
Long story short I decided to think very carefully about every step in the process of adding an exisiting database, and the subsequent changing of it. I noticed something I had missed before. At some point the drop down list for the source in the add db dialog was changed from SQL Server to SQL database. It appears clear this was causing the issue as when I changed it back and added the existing db I do not get a new copy created within my app folder.
I am sure there is a perfectly good reason for this that easily understood by someone with more knowledge than I, but at least it appears I found the problem. I will post back once I have had an opportunity to test this a bit and make sure I'm right. Thanks for the replies, I appreciate the help.
Regards,
Joe
No comments:
Post a Comment