Tuesday, February 14, 2012

Does Visual Studio 2005 come with SQL Server 2005 Standard?

All, does VS2005 come with SQL Server 2005 Standard? If not, what version
of SQL does it come with? How can I identify that version installed?
Thanks for your help.VS includes SQL Server Express edition. SQL Server Developer Edition is
included with VS MSDN subscriptions as a separate install.
One method to identify the installed version is with the query:SELECT
@.@.VERSION.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:CA3B7A75-B0C5-4BC5-958B-6DA893C6D562@.microsoft.com...
> All, does VS2005 come with SQL Server 2005 Standard? If not, what
> version
> of SQL does it come with? How can I identify that version installed?
> Thanks for your help.|||So, your telling me, if I have SQL Server 2005 Standard, there is no visual
Studio pro included, but if i have SQL 2005 Developer Edition, then VS Studio
Pro is?
"Dan Guzman" wrote:
> VS includes SQL Server Express edition. SQL Server Developer Edition is
> included with VS MSDN subscriptions as a separate install.
> One method to identify the installed version is with the query:SELECT
> @.@.VERSION.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:CA3B7A75-B0C5-4BC5-958B-6DA893C6D562@.microsoft.com...
> > All, does VS2005 come with SQL Server 2005 Standard? If not, what
> > version
> > of SQL does it come with? How can I identify that version installed?
> >
> > Thanks for your help.
>|||> So, your telling me, if I have SQL Server 2005 Standard, there is no
> visual
> Studio pro included, but if i have SQL 2005 Developer Edition, then VS
> Studio
> Pro is?
I understood that you original question was what SQL Server version(s) you
get with Visual Studio. However, you are now asking what version of Visual
Studio you get with SQL Server.
VS 2005 pro is not included with any SQL Server edition. A basic VS IDE is
included with SQL Server Standard, Enterprise and Developer that includes
support for only BI projects (SSIS, AS, etc.). If you already have VS
installed, support for those project types are added to your existing VS
installation so that you can use a single IDE for all project types.
Hope this helps.
Dan Guzman
SQL Server MVP
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:7904116A-6079-4EF7-A0AC-A48DEF8CB67D@.microsoft.com...
> So, your telling me, if I have SQL Server 2005 Standard, there is no
> visual
> Studio pro included, but if i have SQL 2005 Developer Edition, then VS
> Studio
> Pro is?
> "Dan Guzman" wrote:
>> VS includes SQL Server Express edition. SQL Server Developer Edition is
>> included with VS MSDN subscriptions as a separate install.
>> One method to identify the installed version is with the query:SELECT
>> @.@.VERSION.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Rob" <Rob@.discussions.microsoft.com> wrote in message
>> news:CA3B7A75-B0C5-4BC5-958B-6DA893C6D562@.microsoft.com...
>> > All, does VS2005 come with SQL Server 2005 Standard? If not, what
>> > version
>> > of SQL does it come with? How can I identify that version installed?
>> >
>> > Thanks for your help.

No comments:

Post a Comment