Just FYI I have submitted an article to Brian with scripts that capture this information into a historical DB, them move the data from each server to a central site, if...

I agree with the above, I would even question how they can pull a backup of the MDFs/LDFs since SQL has them open.  We have ADSM and it just complains that...

Well hopefully an article I wrote will appear in the SQLCentral mag next month (Brian I figure your busy, but I haven't heard back.  Although I am having major e-mail...

Using your description the user would need multiple ODBC setups. 

Common Data

1 for each Prod DB.

OR

If you are using VB, have the app open a direct connection to each. Avoid ODBC...

Well I'll probably get flamed, and I do not believe MS Supports it.  But I do all of my backups into NTFS compressed directories.

I've done it for years, never had...

Unfortunately it has to be Visio Pro, but it is a great tool.

Maggie, I think they misunderstood.  You meant IBM UDB, or Universal DB correct.

I would not consider it a proprietary, but definitely not nearly as easy as SQL to manage and...

No problem Gary just giving you a hard time.

If you add a NULL row, or a row with the NAME field NULL to the ORIGINAL table.  It...

Yes first Bill look at the third query, it is attempting to find Names in upload that do NOT exist in Original.

Bad names for the tables, but I just threw...

Got it, and I am going to RTFM to make sure I understand, because I don't.  But I solved it.

In the Original table there is a NULL row.

I will read...

Good so now we know EM only polls the servers on Opened groups !!

ThomasH gets credit for that idea.

Thanks All

We had problems with Dynamic Disks to the SAN (Shark), when the server was rebooted the disks came up offline.  We could restart them, but I like things automatic.

Changed them to Basic and...

Well it may not be the solution you want, as it is a global EM setting. 

Under Tools, Options you can set EM to Poll the servers to verify the...

I don't know about 6.5

But unless you've really locked down SQL, and eliminated Builtin Admins.  Get someone that is a Local Admin to connect to SQL Server, and change the...

I like the single instance, with multiples you will have to tweak things. Memory mainly,with a single instance, SQL will manage all available memory, hopefully to proper utilization.

Each instance will...