That is exactly what I mean. We have two 1GB cards on these servers and one is not being used. Seems like a waste

Check this site for SQLRecon. It is a free sql server scanner.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

I would recommend Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform, ISBN 0-9766353-0-5 and The Microsoft Data Warehouse Toolkit, ISBN 0-471-26715-5

I would say the first one is more...

Whoops! Here is the Microsoft link.

http://msdn2.microsoft.com/en-us/library/ms141689.aspx

Take a look at the examples on this site http://www.sqlis.com/default.aspx

and this article http://www.sqlis.com/58.aspx It is more than you need but I think you will find it helpful.

Finally, here is...

You can put the email addresse(s) in a variable and then use the variable in a expression in the task. Open the send mail task for Edit and look at...

I don't want to start a flame war but IMHO you are describing a platonic ideal. Sometimes NULLS can not be avoided.

I assume this is the article you mentioned.

Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005

This site might help.

SQL Server 2005 -- Tools for row...

This guy has a lof of good articles, http://www.databasejournal.com/features/mssql/article.php/3598931

or this article, Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP.

http://msdn2.microsoft.com/en-us/library/aa964121.aspx

I would love to have you elaborate on this, "I'm still not completely sold on the whole Analysis Services model for BI work".

I hear a lot is going to change in SP2. I hope it's easier to install than SP1. I installed three of them. Two installed fine but the last one...

Is Journalling turned on for the object you want to delete from on the AS/400?

MSSQLSERVER is the name of the service.

To connect to anothet machine use something like this

Dim

mc As Wmi.ManagedComputer

mc =

New Wmi.ManagedComputer("computer...

I think this is what you are looking for.

Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer.Services

Look here.

I'll have to test that. I sure can't see any other reason. Thanks.