Is there a SP4 for SQL Server 2000 for 32 bits Servers?

Hi.
Is there a SP4 for SQL Server 2000 for 32 bits Servers?
Thanks.Yes
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
Sql2k32sp4.exe
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Monillo" <jcgalarzar@.hotmail.com> wrote in message news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.gbl...
> Hi.
> Is there a SP4 for SQL Server 2000 for 32 bits Servers?
> Thanks.
>
>|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje news:uYt2dy2oFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Yes
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx
> Sql2k32sp4.exe
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Monillo" <jcgalarzar@.hotmail.com> wrote in message
> news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.gbl...
>> Hi.
>> Is there a SP4 for SQL Server 2000 for 32 bits Servers?
>> Thanks.
>>

Is there a SP4 for SQL Server 2000 for 32 bits Servers?

Hi.
Is there a SP4 for SQL Server 2000 for 32 bits Servers?
Thanks.
Yes
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
Sql2k32sp4.exe
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Monillo" <jcgalarzar@.hotmail.com> wrote in message news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.gbl...
> Hi.
> Is there a SP4 for SQL Server 2000 for 32 bits Servers?
> Thanks.
>
>
|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:uYt2dy2oFHA.3828@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yes
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx
> Sql2k32sp4.exe
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Monillo" <jcgalarzar@.hotmail.com> wrote in message
> news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.gbl...
sql

Is there a SP4 for SQL Server 2000 for 32 bits Servers?

Hi.
Is there a SP4 for SQL Server 2000 for 32 bits Servers?
Thanks.Yes
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
Sql2k32sp4.exe
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Monillo" <jcgalarzar@.hotmail.com> wrote in message news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.g
bl...
> Hi.
> Is there a SP4 for SQL Server 2000 for 32 bits Servers?
> Thanks.
>
>|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:uYt2dy2oFHA.3828@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yes
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx
> Sql2k32sp4.exe
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Monillo" <jcgalarzar@.hotmail.com> wrote in message
> news:OcuAzu2oFHA.1048@.tk2msftngp13.phx.gbl...

Is there a Query Analyzer

in the market place that will run a query on multiple DBs across
multiple servers? Without having to manually connect to each server?
If so, can anyone provide a link for it.

Thanks"it depends"

I might be able to write you a custom program for free to do it if you give me
more details.

There's ways to send a query to an sql server via script; but it's not pretty.

Tell us more about what you need to do; or email me off the NG if you want a
mini app

-j

On 20 Feb 2007 14:04:44 -0800, click37@.gmail.com wrote:

Quote:

Originally Posted by

>in the market place that will run a query on multiple DBs across
>multiple servers? Without having to manually connect to each server?
>If so, can anyone provide a link for it.
>
>Thanks

-- AntiSpam/harvest --
Remove X's to send email to me.|||Say I want to run this script:

Select * from company

I need it to run on DB1, DB2, DB3, DB4 and DB5

DB1 and DB2 are located on Server1
DB3 is on Server2
DB4 and DB5 is on Server3

The long and manual way I would have to do it, is copy the SQL smt.
Connect to Server1, paste and run it on DB1, then DB2. Connect to
Server 2, run it on DB3 and so on.

Is there a way to configure the script that will allow me to run the
query once, and it'll give me the results from all the DBs I want it
to hit ?

Thanks for helping.

On Feb 20, 8:57 pm, Josh Assing <Xjo...@.jAssing.comwrote:

Quote:

Originally Posted by

"it depends"
>
I might be able to write you a custom program for free to do it if you give me
more details.
>
There'sways to send aqueryto an sql server via script; but it's not pretty.
>
Tell us more about what you need to do; or email me off the NG if you want a
mini app
>
-j
>
On 20 Feb 2007 14:04:44 -0800, clic...@.gmail.com wrote:
>

Quote:

Originally Posted by

in the market place that will run aqueryon multiple DBs across
multiple servers? Without having to manually connect to each server?
If so, can anyone provide a link for it.

>

Quote:

Originally Posted by

Thanks

>
-- AntiSpam/harvest --
Remove X's to send email to me.

|||On 22.02.2007 16:04, click37@.gmail.com wrote:

Quote:

Originally Posted by

Say I want to run this script:
>
Select * from company
>
I need it to run on DB1, DB2, DB3, DB4 and DB5
>
DB1 and DB2 are located on Server1
DB3 is on Server2
DB4 and DB5 is on Server3
>
The long and manual way I would have to do it, is copy the SQL smt.
Connect to Server1, paste and run it on DB1, then DB2. Connect to
Server 2, run it on DB3 and so on.
>
Is there a way to configure the script that will allow me to run the
query once, and it'll give me the results from all the DBs I want it
to hit ?

Whatever you do, you will have to at least once authenticate to each
machine. With SQL 2005 Management Studio you can store credentials - or
you use Windows authentication. Then no additional login is required.

HTH

robert

Is there a free ms sql host?

I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.

SQL Express is free to download and use...but you would have to find your own host for it...

http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

Is there a 64Bit SQL 2000?

We have SQL 2000 but are getting new 64bit servers, can we upgrade to a 64bit version of SQL 2000 or do we need to go to 2005?

I assume the 32bit SQL 2000 will run on x64 hardware?

Craig

Yes there is both a developer and enterprise version for Itanium 64 bit. SQL does support non-64 bit versions in the WOW on 64 bit platforms.

We would still recommend SQL 2005 for its enhanced features.

AWAL

|||

The upgrade from SQL 2000 32-bit to SQL 2000 64-bit is not supported due to architecture mismatch. And yes, the 32-bit SQL 2000 (and 2005) will run in the WoW layer on x64 machines.

Thanks,
Sam Lester (MSFT)

|||

Any ideas where on MSDN I can download the SQL Server 2000 64bit version?

I checked here: http://msdn2.microsoft.com/en-us/library/aa496089.aspx , but there is no download link.

Thanks.

Nathan

Is there a 64Bit SQL 2000?

We have SQL 2000 but are getting new 64bit servers, can we upgrade to a 64bit version of SQL 2000 or do we need to go to 2005?

I assume the 32bit SQL 2000 will run on x64 hardware?

Craig

Yes there is both a developer and enterprise version for Itanium 64 bit. SQL does support non-64 bit versions in the WOW on 64 bit platforms.

We would still recommend SQL 2005 for its enhanced features.

AWAL

|||

The upgrade from SQL 2000 32-bit to SQL 2000 64-bit is not supported due to architecture mismatch. And yes, the 32-bit SQL 2000 (and 2005) will run in the WoW layer on x64 machines.

Thanks,
Sam Lester (MSFT)

|||

Any ideas where on MSDN I can download the SQL Server 2000 64bit version?

I checked here: http://msdn2.microsoft.com/en-us/library/aa496089.aspx , but there is no download link.

Thanks.

Nathan

sql

Is there a 64Bit SQL 2000?

We have SQL 2000 but are getting new 64bit servers, can we upgrade to a 64bit version of SQL 2000 or do we need to go to 2005?

I assume the 32bit SQL 2000 will run on x64 hardware?

Craig

Yes there is both a developer and enterprise version for Itanium 64 bit. SQL does support non-64 bit versions in the WOW on 64 bit platforms.

We would still recommend SQL 2005 for its enhanced features.

AWAL

|||

The upgrade from SQL 2000 32-bit to SQL 2000 64-bit is not supported due to architecture mismatch. And yes, the 32-bit SQL 2000 (and 2005) will run in the WoW layer on x64 machines.

Thanks,
Sam Lester (MSFT)

|||

Any ideas where on MSDN I can download the SQL Server 2000 64bit version?

I checked here: http://msdn2.microsoft.com/en-us/library/aa496089.aspx , but there is no download link.

Thanks.

Nathan

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant:)
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisRare you queries running on the client side or are they in stored
procedures on the server side?|||are you queries running on the client side or are they in stored
procedures on the server side?|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegroups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisR
are you queries running on the client side or are they in stored
procedures on the server side?
|||are you queries running on the client side or are they in stored
procedures on the server side?
|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegr oups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>
|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisRare you queries running on the client side or are they in stored
procedures on the server side?|||are you queries running on the client side or are they in stored
procedures on the server side?|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegroups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

is sql server on workstation a security risk

We have 5 sql server 2000 server boxes. We also have several people who have
sql server 2000 on their workstations. I work on keeping the servers secure
but I have no idea what people do on their workstations. I'm wondering if
there is a security risk to having an unsecure sql server workstation. If
someone can get on one of the workstations (say sa doesn't have a password)
does that it make it any easier to possibly get to one of the servers?
Thanks,
--
Dan D.Dan,
SQL Server on a workstation still is rights constrained. So it is all about
the rights the person has either through his own login or through other
logins to which he knows the passwords.
If a person is running a desktop SQL Server with the same service account as
your production SQL Server, then you have a security problem. (But the real
problem may be the he has that information.)
If a person is running his desktop SQL Server as himself _and_ he has no
extraordinary rights to the production SQL Server, then there should be no
added exposure.
Getting into the workstation as 'sa' does not map to 'sa' on another machine
through a linked server unless the passwords are identical. (I believe that
is the exposure.) But I trust that your production SQL Server does not have
a blank or easily guessed password.
However, if a person has rights to data he could insert it into his desktop
database, which might be a security breach. Of course, he could insert it
into an Access MDB, and Excel spreadsheet, and so forth.
It is important to control rights carefully _and_ to have clear policies on
what is allowed and not allowed with the company data and for whom it is
allowed.
RLF
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:97601E73-7DF0-4B12-9CA8-2ED2158A0456@.microsoft.com...
> We have 5 sql server 2000 server boxes. We also have several people who
> have
> sql server 2000 on their workstations. I work on keeping the servers
> secure
> but I have no idea what people do on their workstations. I'm wondering if
> there is a security risk to having an unsecure sql server workstation. If
> someone can get on one of the workstations (say sa doesn't have a
> password)
> does that it make it any easier to possibly get to one of the servers?
> Thanks,
> --
> Dan D.|||That's what I thought. I just wanted to be sure that I wasn't missing
something. Thanks Russell.
--
Dan D.
"Russell Fields" wrote:

> Dan,
> SQL Server on a workstation still is rights constrained. So it is all abo
ut
> the rights the person has either through his own login or through other
> logins to which he knows the passwords.
> If a person is running a desktop SQL Server with the same service account
as
> your production SQL Server, then you have a security problem. (But the re
al
> problem may be the he has that information.)
> If a person is running his desktop SQL Server as himself _and_ he has no
> extraordinary rights to the production SQL Server, then there should be no
> added exposure.
> Getting into the workstation as 'sa' does not map to 'sa' on another machi
ne
> through a linked server unless the passwords are identical. (I believe tha
t
> is the exposure.) But I trust that your production SQL Server does not ha
ve
> a blank or easily guessed password.
> However, if a person has rights to data he could insert it into his deskto
p
> database, which might be a security breach. Of course, he could insert it
> into an Access MDB, and Excel spreadsheet, and so forth.
> It is important to control rights carefully _and_ to have clear policies o
n
> what is allowed and not allowed with the company data and for whom it is
> allowed.
> RLF
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:97601E73-7DF0-4B12-9CA8-2ED2158A0456@.microsoft.com...
>
>

Is possible to import registered SQL Servers to another Enterprise Manager

Hi,
Is it possible to export registered SQL Server information
and import it to the Enterprise Manager on the other
server?
ThanksHi Alan,
Go to Enterprise Manager>Tools Menu>Options
Clear checkbox for Read/Store user...
Register required servers. Now these registrations can be shared.
From other computer in your network, goto:
Enterprise Manager>Tools Menu>Options
Choose "Read from remote" and enter the name of computer that you registered
servers in step above.
The settings must appear in your Enterprise Manager.
Amin
"Alan" <SQL@.discussions.microsoft.com> wrote in message
news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> Hi,
> Is it possible to export registered SQL Server information
> and import it to the Enterprise Manager on the other
> server?
> Thanks|||Hi Amin,
Thanks. But I need to copy remote registries and store it
locally. I tried exporting from the registry
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X\SQL Server
Group], but only groups show up, not individual sql
server. So there're some other information stored
somewhere needed but I couldn't identify them.
Thanks
Alan
>--Original Message--
>Hi Alan,
>Go to Enterprise Manager>Tools Menu>Options
>Clear checkbox for Read/Store user...
>Register required servers. Now these registrations can be
shared.
>From other computer in your network, goto:
>Enterprise Manager>Tools Menu>Options
>Choose "Read from remote" and enter the name of computer
that you registered
>servers in step above.
>The settings must appear in your Enterprise Manager.
>Amin
>
>"Alan" <SQL@.discussions.microsoft.com> wrote in message
>news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
>> Hi,
>> Is it possible to export registered SQL Server
information
>> and import it to the Enterprise Manager on the other
>> server?
>> Thanks
>
>
>.
>|||Alan,
I exported:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Deleted servers and imported that file. Everything was ok when I opened
EM(individual servers appeared again).
Is it what you need to do?
By the way, have a look to this address:
HKEY_USERS\S-1-5-21-1482476501-842925246-854245398-500\Software\Microsoft\Mi
crosoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
Amin
<anonymous@.discussions.microsoft.com> wrote in message
news:0f0f01c49f37$92cf66e0$7d02280a@.phx.gbl...
> Hi Amin,
> Thanks. But I need to copy remote registries and store it
> locally. I tried exporting from the registry
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group], but only groups show up, not individual sql
> server. So there're some other information stored
> somewhere needed but I couldn't identify them.
> Thanks
> Alan
> >--Original Message--
> >Hi Alan,
> >Go to Enterprise Manager>Tools Menu>Options
> >Clear checkbox for Read/Store user...
> >Register required servers. Now these registrations can be
> shared.
> >From other computer in your network, goto:
> >Enterprise Manager>Tools Menu>Options
> >Choose "Read from remote" and enter the name of computer
> that you registered
> >servers in step above.
> >The settings must appear in your Enterprise Manager.
> >Amin
> >
> >
> >
> >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> >> Hi,
> >>
> >> Is it possible to export registered SQL Server
> information
> >> and import it to the Enterprise Manager on the other
> >> server?
> >>
> >> Thanks
> >
> >
> >
> >
> >.
> >|||Hi Alan
I've got the same problem (empty tree structure after export & import)
If you look in the regesutry you'll see that the individual servers are
listed as keys but the key values are binary values (displayed in hex). I
wonder if these values (server login details) are encrypted and therefore
cant be read when imported to another machine?
Steve
"anonymous@.discussions.microsoft.com" wrote:
> Hi Amin,
> Thanks. But I need to copy remote registries and store it
> locally. I tried exporting from the registry
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group], but only groups show up, not individual sql
> server. So there're some other information stored
> somewhere needed but I couldn't identify them.
> Thanks
> Alan
> >--Original Message--
> >Hi Alan,
> >Go to Enterprise Manager>Tools Menu>Options
> >Clear checkbox for Read/Store user...
> >Register required servers. Now these registrations can be
> shared.
> >From other computer in your network, goto:
> >Enterprise Manager>Tools Menu>Options
> >Choose "Read from remote" and enter the name of computer
> that you registered
> >servers in step above.
> >The settings must appear in your Enterprise Manager.
> >Amin
> >
> >
> >
> >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> >> Hi,
> >>
> >> Is it possible to export registered SQL Server
> information
> >> and import it to the Enterprise Manager on the other
> >> server?
> >>
> >> Thanks
> >
> >
> >
> >
> >.
> >
>|||I've sussed thats there's 2 seperate sets of entries for server regs in Ent
Manager:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
and
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Any entries in the second location are shown if you untick the "user
independent option" i.e this tick box tells EM whether to look in
HKEY_CURRENT_USER (private) or HKEY_LOCAL_MACHINE (shared).
Question is how do you copy all the entries from the private structure into
the publick one?
Steve
"Amin Sobati" wrote:
> Alan,
> I exported:
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X
> Deleted servers and imported that file. Everything was ok when I opened
> EM(individual servers appeared again).
> Is it what you need to do?
> By the way, have a look to this address:
> HKEY_USERS\S-1-5-21-1482476501-842925246-854245398-500\Software\Microsoft\Mi
> crosoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
> Amin
> <anonymous@.discussions.microsoft.com> wrote in message
> news:0f0f01c49f37$92cf66e0$7d02280a@.phx.gbl...
> > Hi Amin,
> >
> > Thanks. But I need to copy remote registries and store it
> > locally. I tried exporting from the registry
> > [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > Group], but only groups show up, not individual sql
> > server. So there're some other information stored
> > somewhere needed but I couldn't identify them.
> >
> > Thanks
> > Alan
> >
> > >--Original Message--
> > >Hi Alan,
> > >Go to Enterprise Manager>Tools Menu>Options
> > >Clear checkbox for Read/Store user...
> > >Register required servers. Now these registrations can be
> > shared.
> > >From other computer in your network, goto:
> > >Enterprise Manager>Tools Menu>Options
> > >Choose "Read from remote" and enter the name of computer
> > that you registered
> > >servers in step above.
> > >The settings must appear in your Enterprise Manager.
> > >Amin
> > >
> > >
> > >
> > >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> > >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> > >> Hi,
> > >>
> > >> Is it possible to export registered SQL Server
> > information
> > >> and import it to the Enterprise Manager on the other
> > >> server?
> > >>
> > >> Thanks
> > >
> > >
> > >
> > >
> > >.
> > >
>
>
>

Is possible to import registered SQL Servers to another Enterprise Manager

Hi,
Is it possible to export registered SQL Server information
and import it to the Enterprise Manager on the other
server?
Thanks
Hi Alan,
Go to Enterprise Manager>Tools Menu>Options
Clear checkbox for Read/Store user...
Register required servers. Now these registrations can be shared.
From other computer in your network, goto:
Enterprise Manager>Tools Menu>Options
Choose "Read from remote" and enter the name of computer that you registered
servers in step above.
The settings must appear in your Enterprise Manager.
Amin
"Alan" <SQL@.discussions.microsoft.com> wrote in message
news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> Hi,
> Is it possible to export registered SQL Server information
> and import it to the Enterprise Manager on the other
> server?
> Thanks
|||Hi Amin,
Thanks. But I need to copy remote registries and store it
locally. I tried exporting from the registry
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X\SQL Server
Group], but only groups show up, not individual sql
server. So there're some other information stored
somewhere needed but I couldn't identify them.
Thanks
Alan

>--Original Message--
>Hi Alan,
>Go to Enterprise Manager>Tools Menu>Options
>Clear checkbox for Read/Store user...
>Register required servers. Now these registrations can be
shared.
>From other computer in your network, goto:
>Enterprise Manager>Tools Menu>Options
>Choose "Read from remote" and enter the name of computer
that you registered[vbcol=seagreen]
>servers in step above.
>The settings must appear in your Enterprise Manager.
>Amin
>
>"Alan" <SQL@.discussions.microsoft.com> wrote in message
>news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
information
>
>
>.
>
|||Alan,
I exported:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Deleted servers and imported that file. Everything was ok when I opened
EM(individual servers appeared again).
Is it what you need to do?
By the way, have a look to this address:
HKEY_USERS\S-1-5-21-1482476501-842925246-854245398-500\Software\Microsoft\Mi
crosoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
Amin
<anonymous@.discussions.microsoft.com> wrote in message
news:0f0f01c49f37$92cf66e0$7d02280a@.phx.gbl...[vbcol=seagreen]
> Hi Amin,
> Thanks. But I need to copy remote registries and store it
> locally. I tried exporting from the registry
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group], but only groups show up, not individual sql
> server. So there're some other information stored
> somewhere needed but I couldn't identify them.
> Thanks
> Alan
> shared.
> that you registered
> information