How to find which version of SQL 2005 (32bit vs. 64bit)

I have found a kb on getting the Version/Build/ServicePack of SQL2005,
but how do you determine if you are running 32bit or 64 bit edition?
Thank you,
MikeSeems xp_msver returns a platform property that for my machine say 'NT Intel X86'.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but how do you determine if
>you are running 32bit or 64 bit edition?
> Thank you,
> Mike|||"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
>how do you determine if you are running 32bit or 64 bit edition?
> Thank you,
> Mike
SELECT @.@.VERSION -- 32 bit box
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
SELECT @.@.VERSION -- 64 bit box
Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 1)
One is (Intel X86), the other (X64), also the Edition section shows
(64-bit) on the big box.
Rick Sawtell|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>> I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
>> how do you determine if you are running 32bit or 64 bit edition?
>> Thank you,
>> Mike
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>> I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
>> how do you determine if you are running 32bit or 64 bit edition?
>> Thank you,
>> Mike
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.|||It is Help Full,
jat,
http://www.earthsketch.com/seopage.html
M Craig wrote:
> Rick Sawtell wrote:
> > "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> > news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> >> I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
> >> how do you determine if you are running 32bit or 64 bit edition?
> >>
> >> Thank you,
> >>
> >> Mike
> >
> >
> > SELECT @.@.VERSION -- 32 bit box
> > Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> > Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> > NT 5.1 (Build 2600: Service Pack 2)
> >
> >
> > SELECT @.@.VERSION -- 64 bit box
> >
> > Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
> > Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> >
> >
> > One is (Intel X86), the other (X64), also the Edition section shows
> > (64-bit) on the big box.
> >
> >
> > Rick Sawtell
> >
> >
> >
> Thank you I'll try that.sql

how to find the edition of SQL Server 2000/2005 through registry?

Hey, I need to understand what version of SQL is running on some machine. How can I do it looking through the registry. I know you can do it for windows and exchange but I don't know how to do it for SQL 2000. I know in SQL 2005, it tells you the edition for SQL, but how do you do it in SQL 2000. Also, I'm pretty sure, you can look at the Product ID and tell if it's an enterprise edition or standard edition and so on, but I don't have the information. Windows and Exchange do it like that. Can someone provide me with such info? Thank you

you don't have to go through the registry for that - look up the SERVERPROPERTY() function in Books Online. You can find a lot of information about the server using that function.

If for some reason you still need the registry, everything SQL Server stores is in this base hive:

HKLM\Software\Microsoft\MSSqlserver\

|||

in query analyzer type: SELECT @.@.VERSION

or try HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

also see

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/50660f9ebffa92c8/c132c39beb51c4c2?lnk=st&q=how+to+find+sql+server+2000+version+in+registry&rnum=1&hl=en#c132c39beb51c4c2

Microsoft Knowledge Base Article – 321185

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#3

Hope this helps

dscastro

how to find out reporting services version?

i'm using sql 2000 with reporting services standard edition. is there a
way to find out or query the version for the reporting services?
thank you.From a previous thread,
For the server, go to the URL of the report server
(http://server/reportserver/). At the bottom of the page, you will see the
version information, 8.00.743 is RTM, 8.00.878 is SP1, 8.00.1038 is SP2.
For the client, see HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\Reporting Services\Version\
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1139259844.678884.194700@.o13g2000cwo.googlegroups.com...
> i'm using sql 2000 with reporting services standard edition. is there a
> way to find out or query the version for the reporting services?
> thank you.
>

How to find filegroups for a given Table and Table's indexes

Hi

I am using SQL Server 2005 Developer Edition.

I want a list of the following things from the database: -

Table Name , FileGroup Table resides on

Table Name, Index Name, FileGroup index resides on

To put it simply, consider the following example:-

Lets say I have a table XYZ in my database created on Filegroup F1. It has a PK PK1 nonclustered index on Filegroup F2.

List1

-

XYZ F1

List2

XYZ PK1 F2

Please do not tell me of sp_help <table> option

Regards

Imtiaz

For the table XYZ

select OBJECT_NAME(i.object_id) [Table_Name], ds.name [Filegroup_Name] from sys.indexes i join sys.filegroups ds on (ds.data_space_id=i.data_space_id) where object_name(i.object_id) = 'XYZ' and i.index_id=0

--This will work when the table does not have any clustered index on it.

For the non clustered index,

select OBJECT_NAME(i.object_id) [Table_Name], i.name [Index_Name], ds.name [Filegroup_name] from sys.indexes i join sys.filegroups ds on (ds.data_space_id=i.data_space_id) where object_name(i.object_id) = 'XYZ' and i.name='PK1'

For more such catalog view queries

http://msdn2.microsoft.com/en-us/library/ms345522.aspx