How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsout
h.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which service pack of SQLCE is installed on the desktop

The title about says it all. For merge replication, I need to make sure the
service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE
version is in?
IIRC check the folder C:\Program Files\Microsoft SQL Server CE
2.0\Redist\Server, the latest one should be there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||actually this is good up to sp2. After sp 2 you need to check the versions
of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
For sp 4 they are
sscesa20.dll 2.00.7331.0
sscerp20.dll 2.00.7331.0
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||Thanks Hilary; that's helpful.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLeiiSD7FHA.1032@.TK2MSFTNGP11.phx.gbl...
> actually this is good up to sp2. After sp 2 you need to check the versions
> of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
> For sp 4 they are
> sscesa20.dll 2.00.7331.0
> sscerp20.dll 2.00.7331.0
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
>

How to tell which edition of SQL Server 2005 is installed?

Since there are several different editions of SQL Server 2005, how can I find out which edition is installed? Is there a command or a menu item that can display this information? Help->About only gives the version number, not the edition name. I needed to find out whether the SQL Server 2005 on a machine is the Enterprise edtion or not.

Thanks,
Dandan

If you have Database Services installed, you can run T-SQL query "PRINT @.@.version" to find out.|||

This works great. Thanks very much :)

Dandan

how to tell SP level?

How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria

How to tell what version of SQL 2005 is intalled (Enterprise or standard)

I need to make sure that the proper version of SQL Server 2005 was installed on the production server.

What do I do to find out?

Thanks in advance!

Connect to the instance using SQLCMD and run:

1> select @.@.version;
2> go

You should get output that looks like:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The 9.00.1399.06 is the version for SQL Server 2005 RTM.

Or from SQLCMD you can run:

1> select CONVERT(char(20), SERVERPROPERTY('productversion'));
2> go

Which will output:

9.00.1399.06

Also, if you connect to the server using SQL Server Management Studio, the version is displayed in Object Explorer on the root server node. Here it's displayed as 9.00.1399.

Cheers,
Dan

|||

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Name: Edition

Type: REG_SZ

Data: Enterprise Edition

This result supports you install SQL Server 2005 on a clean machine. Most often, you should check the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\Setup if you install multiple instances.

|||

In my previous posting,

"This result supports you install SQL Server 2005 on a clean machine."

should be

"This result supposes you install SQL Server 2005 ENT on a clean machine."

In addition, you can also get the version information from the registry key by checking the value of "Version".

sql

How to tell what service patches are applied

I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:

> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>

How to tell what service patches are applied

I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> Your SQL Server is SP3
> Markus
>sql

How to tell what service patches are applied

I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:

> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>

how to tell SP level?

How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria

How to tell if SQL SP4 is installed

I have a SQL Server running and I need to know if SP4 is installed on it.
How can I tell?
Thanks,
Chrishttp://support.microsoft.com/kb/q321185/
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>|||Enterprise manage, right click on the server in question under the server
group, select properties and you should see product with SP version
"Chris Hedlund" wrote:
> I have a SQL Server running and I need to know if SP4 is installed on it.
> How can I tell?
> Thanks,
> Chris
>
>|||It's one thing to find the version number, but another to match it up with
the actual service pack/patch level. You can paste the below into your
Query Analyzer and run it - it should tab out correctly. If not, use this
as a reference: http://vyaskn.tripod.com/sqlsps.htm
SET NOCOUNT ON
print 'C.1 Current SQL Server Version'
print 'DM1769: CAT I'
print 'The IAO will ensure that the SQL Server version has all patches and
hotfixes applied.'
print ''
print 'SQL Server Version Table:'
print char(9) + char(9) + char(9) + 'No SP SP1 SP2 SP3 / SP3a SP4
SP5 SP5a'
print 'SQL Server 6.0' + char(9) + char(9) + '6.00.121 6.00.124' + char(9)
+ '6.00.139' + char(9) + '6.00.151'
print 'SQL Server 6.5' + char(9) + char(9) + '6.50.201' + char(9) +
'6.50.213' + char(9) + '6.50.240' + char(9) + '6.50.258' + char(9) +
'6.50.281' + char(9) + '6.50.415' + char(9) + '6.50.416'
print 'SQL Server 7.0' + char(9) + char(9) + '7.00.623' + char(9) +
'7.00.699' + char(9) + '7.00.842' + char(9) + '7.00.961' + char(9) +
'7.00.1063'
print 'SQL Server 2000' + char(9) + char(9) + '8.00.194' + char(9) +
'8.00.384' + char(9) + '8.00.534' + char(9) + '8.00.760' + char(9) +
'8.00.2039'
print 'SQL Server 2005' + char(9) + char(9) + '9.00.1399.06 '
print
'========================================================================================================================'
declare @.result varchar(255)
exec xp_msver 'ProductVersion'
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>

How to tell if SQL SP4 is installed

I have a SQL Server running and I need to know if SP4 is installed on it.
How can I tell?
Thanks,
Chrishttp://support.microsoft.com/kb/q321185/
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>|||Enterprise manage, right click on the server in question under the server
group, select properties and you should see product with SP version
"Chris Hedlund" wrote:

> I have a SQL Server running and I need to know if SP4 is installed on it.
> How can I tell?
> Thanks,
> Chris
>
>|||It's one thing to find the version number, but another to match it up with
the actual service pack/patch level. You can paste the below into your
Query Analyzer and run it - it should tab out correctly. If not, use this
as a reference: http://vyaskn.tripod.com/sqlsps.htm
SET NOCOUNT ON
print 'C.1 Current SQL Server Version'
print 'DM1769: CAT I'
print 'The IAO will ensure that the SQL Server version has all patches and
hotfixes applied.'
print ''
print 'SQL Server Version Table:'
print char(9) + char(9) + char(9) + 'No SP SP1 SP2 SP3 / SP3a SP4
SP5 SP5a'
print 'SQL Server 6.0' + char(9) + char(9) + '6.00.121 6.00.124' + char(9)
+ '6.00.139' + char(9) + '6.00.151'
print 'SQL Server 6.5' + char(9) + char(9) + '6.50.201' + char(9) +
'6.50.213' + char(9) + '6.50.240' + char(9) + '6.50.258' + char(9) +
'6.50.281' + char(9) + '6.50.415' + char(9) + '6.50.416'
print 'SQL Server 7.0' + char(9) + char(9) + '7.00.623' + char(9) +
'7.00.699' + char(9) + '7.00.842' + char(9) + '7.00.961' + char(9) +
'7.00.1063'
print 'SQL Server 2000' + char(9) + char(9) + '8.00.194' + char(9) +
'8.00.384' + char(9) + '8.00.534' + char(9) + '8.00.760' + char(9) +
'8.00.2039'
print 'SQL Server 2005' + char(9) + char(9) + '9.00.1399.06 '
print
'=======================================
====================================
========================================
====='
declare @.result varchar(255)
exec xp_msver 'ProductVersion'
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>

How to tell if SP1 is installed?

Hi,
I was just wondering if somebody could tell me how to check and see if SP1
for SQL Reporting Services is installed on a particular machine?
Thanks>From the SP1 ReadMe:
"To identify which version of Reporting Services you have installed,
type the URL of the report server (for example,
http://<exampleWebServer>/reportserver). Version information is located
at the bottom of the page. The final product release is build
8.00.0743.00."
My SP1 installation is 8.00.878.00.
HTH
Erik|||Enter http://YourReportServerName/ReportServer in your browser. If the
version displayed is 8.00.878.00, then you have SP1.
Bob
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks|||Hi,
You can check the version number from http://machine/reportserver url.
Microsoft SQL Server Reporting Services Version 8.00.743.00 is version 1
without SP
Version 8.00.0878 is the onewith SP1
Microsoft SQL Server Reporting Services Version 9.00.852.00 is the latest
version coming with SQL Server 2005 Beta 2
Eralper
http://www.kodyaz.com
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks

how to tell expiration date of eval version

First question: I have sql server 2005 enterprise eval edition installed. is there a query, command or tool can tell me the exact expiration date? I understand it is 180 day but I still want some way to query the exact date.

Second question: does sql server log any warning message before eval expires?

Simply look at the creation date of the SQL folders. There is a message in the event log telling about the expiration date of SQL Server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to take backup of SQL Server 2000 and 2005

Hi,
Good morning to All,

I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.

For this, I've googled also. but I couldn't get clear information.

I want like the following:
I could able to backup entire the Database either into my pen-drive, or some other media.
And,latter I could able to put the Data back into my system.

Can anyone please tell how to take backup of my Data, and Restore also.

Thanks in advance,
Ashok kumar.

You can do the backup/restore using SQL Management Studio. If you are using 2005 Express Edition, you will need the Express Edition of the management studio. Do a quick search on download.microsoft.com for Microsoft SQL Server Management Studio Express (SSMSE).

Once you have it loaded, login and right-click on the database. Under 'tasks' is the option to create the backups and perform the restores.

How to sync data between MSDE

Is there any article/help/doc on how to sync data between MSDE2000? I have installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
Thanks
Look in the BOL about SQL Server replication.
Depending on your synchronization needs, there are a variety of options. If
you don't have the Developer's Edtion of SQL Server then I recommend that
you get it so that you can use EM to develope any replication DTS packages
you may need.
Jim
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:39504051-7ECA-4EC2-BF34-562271854B62@.microsoft.com...
> Is there any article/help/doc on how to sync data between MSDE2000? I have
installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
> Thanks
|||Thanks, Jim.
I try to EM config the replication, use one machine as distributor and publisher, but it kept tell me can not connect to server because 'distributor_admin' is not defined as a remote login at the server. Do you know how to define this user? I tried creati
ng db and windows user, wouldn't work. These two machines are in a workgroup.
In my application, one MSDE(1) is collecting data, the other MSDE(2) get the data published from the (1) and read the data only. I plan to use (1) as publisher & distributor, (2) as subscriber. these two machines are not always online. Which way to sync i
s better, push or pull?
Henry

how to supress instance name while logging to sql server 2005?

Hi,
I am using SQL server 2005 express edition on win XP installed on my machine
.
when I use the SQL server Management studio, I have to enter
machinename\SQLExpress .How can I connect using just machinenname and omit
the SQLExpress instancename?what settings do i need to do?
Thanks for your help.
regards,
tech@.77SQLExpress is the default instance name that is given to that edition when
you indtsll it. You could have changed it during the installation. You can
now only uninstall SQL Express and reintall it as the default instance.
But I would suggest you not to do that and leave it as it is, so that when
you are going for developer edition or any other edition at a later stage,
you might want it to run under default instance.
Hope this helps.

how to start work in SQL Server 2005 enterprise edition

Hi all,

I am new to SQL server. I just installed SQL Server 2005 enterprise edition .

I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.

Can anyone please give me the location.

Thanks

Start by taking a look at the documentation that ships with SQL Server 2005 Enterprise Edition. There are samples and walk-throughs included in the documentation that are designed to get you started. Is that what you're looking for?

Jeff.

how to start work in SQL Server 2005 enterprise edition

Hi all,

I am new to SQL server. I just installed SQL Server 2005 enterprise edition .

I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.

Can anyone please give me the location.

Thanks

If you have installed BOL(books online; help document that comes with SQL Server) use that. Almost all your questions will be answered in BOL. If you have not then install it.