Great article.  Thanks.  I have something simple in place to monitor the SQL Servers disk space, but this is much better.

I am still looking for some advise on the MOM...

Once the trust is set up, just install SQL Server and set up your profile like normal.  I've done this on 3 servers and it works fine.  If your Exchange...

Try another recipient name.  The error states

"The message alias could not be found on the network."  Maybe the network guys changed the name you've been using.

Dbo ownership can also be a challenge when you purchase 3rd party applications.  We are currently working with a vendor whose scripts don't designate dbo so objects are owned by...

Back to the statement that there is "a known bug in the Microsoft drivers"...  Why not use the Oracle 9i driver?  We use it in linked servers and DTS and have no issues.  Don't...

I've never seen linked tables lose their connections, but why don't you try a few things.  Create a user  or system DSN instead of a file DSN.  Change authentication from NT...

When you say 'losing access to the database' do you mean they are getting connection errors?  If so, what are they?  When you 'refresh the tables' in Access do you...

Are you upgrading an RTM version of SQL 7?  If so, there is a bug you should be aware of.  Other than this, we've had no problems at all.

http://support.microsoft.com/default.aspx?scid=kb;en-us;300676

The version of iSeries driver makes a difference, too.  I tried setting up a linked server using version 7 or 8 ODBC driver, and had the login issue with scheduled jobs. ...

You should be able to connect to it as long as you also have permission to the database.  How are you trying to connect?  Query Analyzer, ODBC, Enterprise Manager?  What...

First you will need to check public permissions and take away whatever rights you don't want your users to have.  They will need sp_start_job to run the job, but you...

Another option is to create a linked server and use distributed queries to get the data.  This is the method we use, however, if you need to transform the data...

We also have a linked server to an AS/400 using the Client Access driver and a 3rd party driver called HiT.  We're only pulling data into a SQL database and...

I don't think that it's an Enterprise Mgr setting necessarily, but an NT one.  Mine defaults to "My Documents" because that is how my pc was set up.  Go into...

At the bottom of the Advanced Tab you will see a drop down box with "Run as user" to the left of it.  Just select a user account to run the...