SQL Server 'Standard' - supports a maximum of 2 Gb or RAM for SQL Server only.

SQL Server 'Enterprise' - supports more than of 2 Gb or RAM (up to 64...

You can do this, but a erstore will probably not work. dual full backups and transactino log backups will confure the recovery process immensely !!! However if you supply a...

Please do not cross post ... this is 1 of 3 !

Please do not cross post ... this is 1 of 3 !

Please do not cross post ... this is 1 of 3 !

You might want to search the forums ... I seem to remember a 'cool' solution that used a VIEW with a 'UNION ALL' in it that does just what you...

I agree 100% as well Steve. I'd like to add that it's a case of de-evolution pure and simple. Remember the 'old days' (v4.21, v4.21a, v6.0, v6.5) when one did not...

The only difference between linked servers within a network and and linked servers,  network SQL Server and a DMZ SQL Server,  is a firewall. You'll have to talk to your...

If you choose this method you may have issues with SP4 application. There are also some registry tweaks that are needed and done when you use EM. Prior to SP4...

Take away the encryption and it's called XML !

Lowell, I know for sure that the database backup is 'versioned' for the master database (I haven't tried msdb or model) ...

It appears that you are runnjing SQL 2000 RTM (the initial release) and you want to go to SQL 200o SP3a plus hotfix 818. First off, you cannot patch (upgrade...

Here's acouple of things to try before investing 15 minutes in an EM install on another machine based on your statement that the SQL Server's IP address just changed ...

You...

Whether you use a Windows API, ODBC or SQL DMO the information in my previous post still stands.

I'd opt for separation. We are primarily a SQL Server shop but we also have Oracle (7, 8 & 9) and UDB2 v7.x and a bunch more 'stuff'. We follow...