Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Wednesday, March 28, 2012
How do I know the version of Crystal Reports that I am using ??
How do I know the version of Crystal Reports that I am using. I am using Crystal Reports that has come bundled with Visual Studio 2003. How do I know its Version ?Open it? Help -> About.
Monday, March 26, 2012
How do I know if I have Enterprise or Standard on my machine?
I go to help>About and it just says SQL Server 2005
Microsoft SQL Server Management Studio Version 9.00.1399.00
You can use osql at the command prompt like this:
osql -S yourServerName -E -q "select CAST(SERVERPROPERTY('edition') AS VARCHAR)
|||The problem I'm having is that I'm unable to establish and instance of a server so I don't know or have a server name.
This is one of the reasons why I want to know the edition I have. As I understand it, Enterprise edition does not support XP Pro OS, which is what I'm running. If I have enterprise then I figure I might as well give up on trying to get this solved. If I have standard, then I won't give up so easily.
|||If you can get to the SQL Server Configuration Manager, select SQL Server 2005 Services in the left pane, then right click on the SQL Server process and select properties, go to Advanced tab and look at the entry "Stock Keeping Unit Name".|||I can get to the SQL Configuration Manager, however when I right click on SQL Server 2005 Services "SQL Server process" is not shown.
Also, seems like I don't have SQL Server Browser Service installed. The file sqlbrowser.exe is not in my 90\Shared folder.
Any ideas?
Thanks
|||An easy way is to go to the registry and look for this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition
Note: You'll have this key for each component installed, so you'll find them here as well:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup\Edition
Thanks,
Sam Lester (MSFT)
Ok got it..
I have standard edition...So that rules out OS incompatibility theory I was under the assumption that I working under.
So back to my main problem.
I'm unable to establish a local server instance on my machine.
I have established remote server instances, but not local..
Any ideas?
Thanks
How do I know I have notification services (DST)
Hello,
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
Tony
You can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
Tony
You can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
How do I know I have notification services (DST)
Hello,
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
TonyYou can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.comsql
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
TonyYou can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.comsql
How do I know I have notification services (DST)
Hello,
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
TonyYou can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
How can I verify this? We have SQL 2000 (version 8) with sp4.
I am referring to the daylight saving time.
Thanks ahead.
TonyYou can take a look at the section "How to determine whether SQL Server 2000
Notification Services is installed" in the following KB article:
http://support.microsoft.com/?id=931815
It outlines 3 methods to verify if you have NS installed.
Note that even if you determine that you have NS installed you may not need
to do anything. You are affected only if you have an instance of NS
deployed. Just installing NS will not be a problem with DST (the binary
files are not affected). To verify if you have an instance you can check if
you see the NS* services running and if there are any NS* databases.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
How do I integrate with SourceSafe or TFS-VC?
Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control?
I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible?
You do not integrate the database itself with source control.What gets integrated is your development environment. (i.e. Management Studio and BID Studio).
Basic steps are
1) Install Management Studio and BID Studio
2) Install VSS (and create source control database and users)
3a) In Management Studio create new SQL Server Scripts project / solution
3b) In BID Studio create new Integration Services Project
4) In solution explorer (for either prject), right click and select Add To Source Control.
For the most part that should do it...
Monday, March 19, 2012
How do I get SQL Server version (numbers only) programatically
Hi
I want to get SQL Server version. I know this way: Select @.@.version
But this gives me a very long string, i.e.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
Windows
NT 5.0 (Build 2195: Service Pack 4)
i want this value in a c++ application, and depending upon that i have
to fire query.
I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
maybe.
How do I get these numbers only?
Regards,
Ravi ShankarFor the more recent versions of SQL Server, you can use SELECT
SERVERPROPERTY('ProductVersion'). Otherwise, you'll need to parse the
@.@.VERSION string. Transact-SQL example:
DECLARE @.Version nvarchar(125)
IF SERVERPROPERTY('ProductVersion') IS NOT NULL
BEGIN
SELECT SERVERPROPERTY('ProductVersion')
END
ELSE
BEGIN
SET @.Version =
SUBSTRING(@.@.VERSION, CHARINDEX('- ',
@.@.VERSION) + 2, 13)
SET @.Version = LEFT(@.Version, CHARINDEX(' ',
@.Version))
SELECT @.Version
END
Hope this helps.
Dan Guzman
SQL Server MVP
<ravidhari@.gmail.com> wrote in message
news:1156937494.514331.282750@.m73g2000cwd.googlegroups.com...
> Hi
> I want to get SQL Server version. I know this way: Select @.@.version
>
> But this gives me a very long string, i.e.
>
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
> 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
> i want this value in a c++ application, and depending upon that i have
> to fire query.
> I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
> maybe.
> How do I get these numbers only?
>
> Regards,
> Ravi Shankar
>|||SELECT SERVERPROPERTY('ProductVersion')
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Ravi,
You can try using "exec master..xp_msver".
It will return a recordset containing lots of info about your SQL Server
installation. One of the records will contain information about the
"ProductVersion".
Cheers!
SQLCatz
I want to get SQL Server version. I know this way: Select @.@.version
But this gives me a very long string, i.e.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
Windows
NT 5.0 (Build 2195: Service Pack 4)
i want this value in a c++ application, and depending upon that i have
to fire query.
I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
maybe.
How do I get these numbers only?
Regards,
Ravi ShankarFor the more recent versions of SQL Server, you can use SELECT
SERVERPROPERTY('ProductVersion'). Otherwise, you'll need to parse the
@.@.VERSION string. Transact-SQL example:
DECLARE @.Version nvarchar(125)
IF SERVERPROPERTY('ProductVersion') IS NOT NULL
BEGIN
SELECT SERVERPROPERTY('ProductVersion')
END
ELSE
BEGIN
SET @.Version =
SUBSTRING(@.@.VERSION, CHARINDEX('- ',
@.@.VERSION) + 2, 13)
SET @.Version = LEFT(@.Version, CHARINDEX(' ',
@.Version))
SELECT @.Version
END
Hope this helps.
Dan Guzman
SQL Server MVP
<ravidhari@.gmail.com> wrote in message
news:1156937494.514331.282750@.m73g2000cwd.googlegroups.com...
> Hi
> I want to get SQL Server version. I know this way: Select @.@.version
>
> But this gives me a very long string, i.e.
>
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
> 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
> i want this value in a c++ application, and depending upon that i have
> to fire query.
> I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
> maybe.
> How do I get these numbers only?
>
> Regards,
> Ravi Shankar
>|||SELECT SERVERPROPERTY('ProductVersion')
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Ravi,
You can try using "exec master..xp_msver".
It will return a recordset containing lots of info about your SQL Server
installation. One of the records will contain information about the
"ProductVersion".
Cheers!
SQLCatz
How do I get SQL Server version (numbers only) programatically
Hi
I want to get SQL Server version. I know this way: Select @.@.version
But this gives me a very long string, i.e.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
Windows
NT 5.0 (Build 2195: Service Pack 4)
i want this value in a c++ application, and depending upon that i have
to fire query.
I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
maybe.
How do I get these numbers only?
Regards,
Ravi ShankarFor the more recent versions of SQL Server, you can use SELECT
SERVERPROPERTY('ProductVersion'). Otherwise, you'll need to parse the
@.@.VERSION string. Transact-SQL example:
DECLARE @.Version nvarchar(125)
IF SERVERPROPERTY('ProductVersion') IS NOT NULL
BEGIN
SELECT SERVERPROPERTY('ProductVersion')
END
ELSE
BEGIN
SET @.Version = SUBSTRING(@.@.VERSION, CHARINDEX('- ',
@.@.VERSION) + 2, 13)
SET @.Version = LEFT(@.Version, CHARINDEX(' ',
@.Version))
SELECT @.Version
END
--
Hope this helps.
Dan Guzman
SQL Server MVP
<ravidhari@.gmail.com> wrote in message
news:1156937494.514331.282750@.m73g2000cwd.googlegroups.com...
> Hi
> I want to get SQL Server version. I know this way: Select @.@.version
>
> But this gives me a very long string, i.e.
>
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
> 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
> i want this value in a c++ application, and depending upon that i have
> to fire query.
> I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
> maybe.
> How do I get these numbers only?
>
> Regards,
> Ravi Shankar
>|||SELECT SERVERPROPERTY('ProductVersion')
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Ravi,
You can try using "exec master..xp_msver".
It will return a recordset containing lots of info about your SQL Server
installation. One of the records will contain information about the
"ProductVersion".
Cheers!
SQLCatz
I want to get SQL Server version. I know this way: Select @.@.version
But this gives me a very long string, i.e.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
Windows
NT 5.0 (Build 2195: Service Pack 4)
i want this value in a c++ application, and depending upon that i have
to fire query.
I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
maybe.
How do I get these numbers only?
Regards,
Ravi ShankarFor the more recent versions of SQL Server, you can use SELECT
SERVERPROPERTY('ProductVersion'). Otherwise, you'll need to parse the
@.@.VERSION string. Transact-SQL example:
DECLARE @.Version nvarchar(125)
IF SERVERPROPERTY('ProductVersion') IS NOT NULL
BEGIN
SELECT SERVERPROPERTY('ProductVersion')
END
ELSE
BEGIN
SET @.Version = SUBSTRING(@.@.VERSION, CHARINDEX('- ',
@.@.VERSION) + 2, 13)
SET @.Version = LEFT(@.Version, CHARINDEX(' ',
@.Version))
SELECT @.Version
END
--
Hope this helps.
Dan Guzman
SQL Server MVP
<ravidhari@.gmail.com> wrote in message
news:1156937494.514331.282750@.m73g2000cwd.googlegroups.com...
> Hi
> I want to get SQL Server version. I know this way: Select @.@.version
>
> But this gives me a very long string, i.e.
>
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006
> 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
> i want this value in a c++ application, and depending upon that i have
> to fire query.
> I just want the the major version number 6.0 ,7.0 , 8.0 or whatever
> maybe.
> How do I get these numbers only?
>
> Regards,
> Ravi Shankar
>|||SELECT SERVERPROPERTY('ProductVersion')
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Ravi,
You can try using "exec master..xp_msver".
It will return a recordset containing lots of info about your SQL Server
installation. One of the records will contain information about the
"ProductVersion".
Cheers!
SQLCatz
Friday, March 9, 2012
How do I find what version of SQL Server is installed?
Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
Venki
Sorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
Venki
Sorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
How do I find what version of SQL Server is installed?
Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>> Hello:
>> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
>> editions.
>> Can you tell me how I can determine which flavor is installed?
>> I thought I had Standard Edition but when I tried to install Standard
>> Edition of the Reporting services, it said that it was a wrong type.
>> Thanks.
>> Venki
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>> Hello:
>> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
>> editions.
>> Can you tell me how I can determine which flavor is installed?
>> I thought I had Standard Edition but when I tried to install Standard
>> Edition of the Reporting services, it said that it was a wrong type.
>> Thanks.
>> Venki
How do I find what version of SQL Server is installed?
Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>
How do I find out what version of SQL Server 2000 I'm running?
How do I find out what version of SQL Server 2000 I'm running?
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad
How do I find out the SQL server version?
Hello,
I am a newbie on SQL server, how do I find out the SQL server version on my sql box?
I am a newbie on SQL server, how do I find out the SQL server version on my sql box?
Thanks,
Sohail
The quickest is the location below 70 is TDS(tabular data stream) 70 for 7.0, 80 for 2000, 90 for 2005 and 100 for 2008 which is being developed by Microsoft for February 2008 release. Post again if you still need help.
C:\Program Files\Microsoft SQL Server
|||open a Query window in SQL management studio OR Enterprise manager and execute:
select @.@.version
Friday, February 24, 2012
how do I do this?
I want to change the order by criteria depending on a certain input paramater
So suppose
This is a simplified condensed version of what I need
declare @.sortID int
set @.sortID=1
So if the @.sortID=1 I wanna have this
select * from tblusersorder by name
else
select * from tblusers whereorder by age
so depending on the sort id the bolded text should change.
Only one way I know of ...
declare @.sortID int
set @.sortID=1
If (@.sortID = 1)
BEGIN
select * from tblusersorder by name
END
ELSE
BEGIN
select * from tblusers whereorder by age
END
I do not believe order by can be a parameter
|||hello,
and other way to do, dynamic sql execution, some case is not good way to do but versstile
===============================
1declare @.idint2declare @.sqlnvarchar(max)34set @.id = 156set @.sql ='select top 10 productid, [name] from production.product '7+'order by ' +case @.id8when 1then'[name]'9when 2then'productid'10end1112execsp_executesql @.sql
===============================
|||busyweb is right. You could use dynamic SQL. I just never think of dynamic SQL because of the speed, security, maintainability problems. (smile)Sunday, February 19, 2012
How do I determine my Reporting Services version - again?
The version numer is 9.00.3186.00. I need to know what that means.
Specifically, is it SP2, which is required for a CRM update?
On searching through the newsgroup bulletins, I see that I am not the only
one who has wanted that kind of information, though unfortunately the
questions stemmed from the 8.0 release. I also did a search through the MSDN
library for ReportingService, and found this article: How to: Detect Version
Information (Reporting Services)
Unfortunately, 9.00.3186.00 doesn't appear in that article's chart. The
closest if 9.0.3042.00, which is service pack 2.
Can anyone help here?Type the following in Management Studio:
select SERVERPROPERTY('PRODUCTLEVEL')
--
Thank you,
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:360A50A8-629B-4D6C-A534-85BC8EBA48C2@.microsoft.com...
> The version numer is 9.00.3186.00. I need to know what that means.
> Specifically, is it SP2, which is required for a CRM update?
> On searching through the newsgroup bulletins, I see that I am not the only
> one who has wanted that kind of information, though unfortunately the
> questions stemmed from the 8.0 release. I also did a search through the
> MSDN
> library for ReportingService, and found this article: How to: Detect
> Version
> Information (Reporting Services)
> Unfortunately, 9.00.3186.00 doesn't appear in that article's chart. The
> closest if 9.0.3042.00, which is service pack 2.
> Can anyone help here?
Specifically, is it SP2, which is required for a CRM update?
On searching through the newsgroup bulletins, I see that I am not the only
one who has wanted that kind of information, though unfortunately the
questions stemmed from the 8.0 release. I also did a search through the MSDN
library for ReportingService, and found this article: How to: Detect Version
Information (Reporting Services)
Unfortunately, 9.00.3186.00 doesn't appear in that article's chart. The
closest if 9.0.3042.00, which is service pack 2.
Can anyone help here?Type the following in Management Studio:
select SERVERPROPERTY('PRODUCTLEVEL')
--
Thank you,
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:360A50A8-629B-4D6C-A534-85BC8EBA48C2@.microsoft.com...
> The version numer is 9.00.3186.00. I need to know what that means.
> Specifically, is it SP2, which is required for a CRM update?
> On searching through the newsgroup bulletins, I see that I am not the only
> one who has wanted that kind of information, though unfortunately the
> questions stemmed from the 8.0 release. I also did a search through the
> MSDN
> library for ReportingService, and found this article: How to: Detect
> Version
> Information (Reporting Services)
> Unfortunately, 9.00.3186.00 doesn't appear in that article's chart. The
> closest if 9.0.3042.00, which is service pack 2.
> Can anyone help here?
Subscribe to:
Posts (Atom)