Post install processor addition

I am getting ready to install SQL Server 2000 Enterprise
in a new server but wanted to add an additional processor.
Time crunch is making me want to install the software
prior to getting the processor in. My question is whether
SQL will recognize the additional processor after it is
installed or do I have to wait until I have the part
installed? We were intending to allow SQL to use any
available processor for processing. Thanks in advance for
any help.As long as your host computer already has a multi-processing kernal
installed, you should be fine.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rick" <rvia@.vw.vccs.edu> wrote in message
news:0de801c4ac99$ea52b880$a301280a@.phx.gbl...
> I am getting ready to install SQL Server 2000 Enterprise
> in a new server but wanted to add an additional processor.
> Time crunch is making me want to install the software
> prior to getting the processor in. My question is whether
> SQL will recognize the additional processor after it is
> installed or do I have to wait until I have the part
> installed? We were intending to allow SQL to use any
> available processor for processing. Thanks in advance for
> any help.

Possible to Export EM SQL Registrations?

I have a development laptop that I frequently need to reimage (ghost). I have about 25 SQL Servers registered in Enterprise Manager. Some use Windows Auth, some SQL Auth. Can I export the registration information so I don’t have to re-enter it every
time I rebuild my laptop?
I have been able to export/import the server aliases using this key (this works fine): [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \Client\ConnectTo]
I have also exported/imported: [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
But All I get are the groups, no servers.
TIA
Hi TIA,
I have noticed you posted another issue with topic "Export/Import SQL EM
Registrations?", I will add a reply to that thread. If you have any further
question, please post there and I will be glad to follow up
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks, yea I got an error while posting... could not tell if the post wet through.
Thanks!
""Mingqing Cheng [MSFT]"" wrote:

> Hi TIA,
> I have noticed you posted another issue with topic "Export/Import SQL EM
> Registrations?", I will add a reply to that thread. If you have any further
> question, please post there and I will be glad to follow up
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Possible to download Enterprise Manager?

Does anyone know if it is possible to download Enterprise Manager?

ThanksNo. However, you can get the developers edition quite cheaply.

Amazon has it for $42.

possibility in enterprise manager

Hi,

I'm using enterprise manager to remotely connect to a MS SQL Server for one of my client's websites. The problem I'm having is that the connection times out when I try to expand the "Databases" folder. The reason that it's timing out is because the company that hosts the DB has hundreds of other clients who all share the same IP, but each with their own seperate login/password/database, but even though I don't have access to all the rest of the DBs on the server, it still wants to list them all for me. What I'm wondering is is there a way to set EM to ignore all of the databases on the server that cannot be accessed with my credentials? So basically when I expand the Databases folder all that appears is the one that I can access?

Thanks,
DanteSeems like I've seen this question on the forum before and the answer was "nope". Sorry.

Ports And Protocols

Hi Folks ,

Got one for you ....

By default what ports and protocols do the following sql tools use...?

Enterprise Manager
SQL Query Analyser
SQL Profiler

And if anybody knows :

Performance Monitor
Mapping drives
Event Viewer
User/Server Manager

Any help would be greatly appreciated ....Do you mean TCP/IP ports and protocols?

Microsoft SQL uses port 1433 for the default instance, and 1434 for named instances. It uses the TDS protocol.

The other tools use a mish-mash of ports and protocols, but I'd start with port 135.

-PatP