I am trying to upload my first database to discountasp.net hosting and can't get it to work.
From within vs 2010 I created a new web site, added new item (sql database) in App_Data folder, created and table, configured the sql datasource. Ctrl +F5 and I can view the table in my browser. Changed connection string as per discountasp.net and used their control panel to try to attach database which fails as my version of sql is not supported.
How do I tell which version of sql vs studio is using?
The programs menu on my computer shows sql 2005, 2008, and sql 2008r2 installed.
I also installed sql server express 2008r2..
What version of sql should a small company be using to add a database on their website?
What is the approximate cost? ms sql server site is confusing and does not show prices.