ExpressMan1
asked on
asp.net 3.5 vs studio 2010 ultimate and sql express. Does vs studio 2010 come with a functioning version of sql 2008
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.
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.
ASKER
Downloaded sql server configuration manager. Here is a screen shot. How can I tell which version vs studio is using? Sql-Server-Configuration-Manager.docx
ASKER
Ok. forget the last post. I have the correct open program now. "ms sql server management studio"
How or where do I run "SELECT @@VERSION" ?
How or where do I run "SELECT @@VERSION" ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked. Thanks. Looks like it's running 2 versions. Is there a way I can cancel one?
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
you can stop the service
you can run "SELECT @@VERSION" from SSMS
>>What version of sql should a small company be using to add a database on their website?
express is good.
>>What is the approximate cost?
0$ for express
>>ms sql server site is confusing and does not show prices.
because you need to go through reseller