Oracle EM for SQL Server 2000?

Hi,
Can anyone suggest a tool that manages SQL server instances - other than SQL
Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
Manager.
I need something that will give me a view of, and manage, 50+ SQL Server
instances.
Cheers,
James G.http://www.aspfaq.com/show.asp?id=2442
--
David Portas
SQL Server MVP
--|||Try
DBArtisan
u can get a tial version from the DBartisan website
search in google for the toolls
i do not remember the web site.
from
Doller|||I believe you can also use OEM, just pay and install agent into sql server
PC.
Tell us how it looks if you try it.
"James Goodwill" <james.goodwill@.uk.fujitsu.com> wrote in message
news:8POZe.671$TL4.582@.newsfe4-win.ntli.net...
> Hi,
> Can anyone suggest a tool that manages SQL server instances - other than
> SQL
> Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
> Manager.
> I need something that will give me a view of, and manage, 50+ SQL Server
> instances.
> Cheers,
> James G.
>

Oracle database in enterprise manager SQL 2000

Can I access an Oracle database in enterprise manager SQL 2000? How do I proceed?

YOu will have to create a linked server in SQL Server 2000 using the appropiate provider. THen you can scroll through the metadata of oracle server. Querying the tables is not possible from the GUI. After creating a linked server you will have to use queries in the syntax of

SELECT * FROM LinkedServername.Database.Schema.ObjectName

(four part naming) to access the oracle Database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Oracle 9i Client on SQL Server 2000 Ent.

I installed Oracle 9i client on a SQL Server 2000
Enterprise Edition server with Windows 2000 Advanced
Server operating system. Next, I opened the linked server
and lastly I tried to open the Microsoft OLE DB Provider
for SQL Server which caused the server to hang and had to
be rebooted.
Please help me with what could cause this problem?
Thank You,
MikeHonestly I don't know the answer, so I can just throw some
ideas:
I assume it was working fine before you installed the
Oracle 9i client. Just a crazy though, try to reboot your
server couple times and see if that fixes the problem.
If it still doesn't work then remove the Oracle 9i client
and see what happens.
hth.
>--Original Message--
>I installed Oracle 9i client on a SQL Server 2000
>Enterprise Edition server with Windows 2000 Advanced
>Server operating system. Next, I opened the linked
server
>and lastly I tried to open the Microsoft OLE DB Provider
>for SQL Server which caused the server to hang and had to
>be rebooted.
>Please help me with what could cause this problem?
>Thank You,
>Mike
>.
>