Pros/Cons of using Win 2003 over Win 2000 for SQL Server Enterprise ?

We've recently got a new Server in.
The server has 16Gb of RAM, 8 cpus etc
We now have a choice of sticking with Windows 2000 Advanced Server or
going with Windows 2003 Enterprise edition.
Besides being able to use more RAM and having to use Service pack 3a
in Win 2003
Any pros/cons of both ?
Any recommendations ?
We use Full text, replication, analysis services etc
What issues / Enhancements has MS introduced for sp3A ?
I know that once Service pack 3A is installed all full text indexes
are automatically rebuilt..
In a replication scenario Is it necessary or just a recommendation
that all participants in the replication scenario are using the same
service pack ?
Anything else to look out for ?Win2003 has several enhancements that canmake it very worth while. The cpu
scheduling and parallism is improved along with many improvements in the
file and I/O areas. Win2003 is just a better choice overall for an
enterprise server in my opinion.
--
Andrew J. Kelly
SQL Server MVP
"Steve" <stevekeilygroups@.yahoo.com.au> wrote in message
news:70809952.0311191644.338d1eb3@.posting.google.com...
> We've recently got a new Server in.
> The server has 16Gb of RAM, 8 cpus etc
> We now have a choice of sticking with Windows 2000 Advanced Server or
> going with Windows 2003 Enterprise edition.
> Besides being able to use more RAM and having to use Service pack 3a
> in Win 2003
> Any pros/cons of both ?
> Any recommendations ?
> We use Full text, replication, analysis services etc
> What issues / Enhancements has MS introduced for sp3A ?
> I know that once Service pack 3A is installed all full text indexes
> are automatically rebuilt..
> In a replication scenario Is it necessary or just a recommendation
> that all participants in the replication scenario are using the same
> service pack ?
>
> Anything else to look out for ?

Promlem with loging in Managment Studio

hi

I'm going to use Enterprise edition

when I want to log in Managment Studio I face a window asking me for Server Name in addition to Server Type and authentication mode.

what should I write in Server Name section.I know the format is:

ComputerName\Instance Name

but what should I write in Instance Name?

thanks

Hello -

If you've installed SQL Server on the system with all the defaults, you don't have to type anything in the instance name. It's just the name of the server. If you installed SQL Server Express, it installs as a named instance by default. Usually it is named SQLExpress, so the name would be:

(your Server name)\SQLEXPRESS

To find out if the server is default or named, open a command prompt in Windows and type this:

NET START

Look for the service that starts with "SQL Server" in the name and to the right you'll see if it is a named instance or not. It will have the name of the instance in parenthesis, and if it is MSSQLSERVER it's default, and you don't have to type anything other than the server name. If it has something else there, it is named and that is the name you type.

More here: http://www.mssqltips.com/tip.asp?tip=1048

Note: If this answers your question, make sure you mark it "answered" so that others can find it!

Buck Woody
http://www.buckwoody.com

|||

You have to know what the instance name is; we can't tell you that. The best advice I can give you is to launch the SQL Server Configuration Manager (In your Start Menu->SQL Server 2005->Configuration Tools folder), browse to the Services tab, and locate any service that has a Service Type of "SQL Server", and then work from there.

If the service name is "SQL Server (MSSQLSERVER)" then you do not have an instance name (just use the computer name)

If the service name is "SQL Server (SQLEXPRESS)" then use ComputerName\SqlExpress

Check out my SQL Server 2005 video tutorials: http://www.learnsqlserver.com/

|||Where is it? I searched it and it does not come up in my search but when I go to microsoft .com they say it is already on the compuer

Promlem with loging in Managment Studio

hi

I'm going to use Enterprise edition

when I want to log in Managment Studio I face a window asking me for Server Name in addition to Server Type and authentication mode.

what should I write in Server Name section.I know the format is:

ComputerName\Instance Name

but what should I write in Instance Name?

thanks

Hello -

If you've installed SQL Server on the system with all the defaults, you don't have to type anything in the instance name. It's just the name of the server. If you installed SQL Server Express, it installs as a named instance by default. Usually it is named SQLExpress, so the name would be:

(your Server name)\SQLEXPRESS

To find out if the server is default or named, open a command prompt in Windows and type this:

NET START

Look for the service that starts with "SQL Server" in the name and to the right you'll see if it is a named instance or not. It will have the name of the instance in parenthesis, and if it is MSSQLSERVER it's default, and you don't have to type anything other than the server name. If it has something else there, it is named and that is the name you type.

More here: http://www.mssqltips.com/tip.asp?tip=1048

Note: If this answers your question, make sure you mark it "answered" so that others can find it!

Buck Woody
http://www.buckwoody.com

|||

You have to know what the instance name is; we can't tell you that. The best advice I can give you is to launch the SQL Server Configuration Manager (In your Start Menu->SQL Server 2005->Configuration Tools folder), browse to the Services tab, and locate any service that has a Service Type of "SQL Server", and then work from there.

If the service name is "SQL Server (MSSQLSERVER)" then you do not have an instance name (just use the computer name)

If the service name is "SQL Server (SQLEXPRESS)" then use ComputerName\SqlExpress

Check out my SQL Server 2005 video tutorials: http://www.learnsqlserver.com/