I don't know Barry. I think IIS is free with Windows Server, but when you connect to IIS do you need a CAL because you are connecting to the...

Thanks for the responses guys. I don't think I was clear enough on the question, although some of the answers apply. I know I am all set on...

Here is a quote from the latest Microsoft Product Use Rights (pp. 40-41) document available here(be sure to us IE as it crashed FireFox):

III) Running Instances of the Additional Software....

My understanding of licensing is that if you or your company has a licensed version of SQL Server you can install the client tools on any PC. Of course...

Yes, to use xp_sendmail you need Outlook installed on the SQL Server. When I was using

SQL 7, 2000 I used xp_smtp_sendmail. I would post a link, but I...

The script component (or custom Error Details component if you are using that) has an output that you send to an OLE DB Source just like any other component.

Since you are using 2000 you should check out the first post in this thread as it has some code that accesses the tables that you will need to look...

In reality you can do whatever you want with the error output. I just knew that I wanted more than the error code and that I wanted a generic...

I'm not sure what you mean. If you only want the status for jobs that run since the last email...

If properly indexed you should be able to sum the details efficiently so there is no reason to store the data in my opinion.

Truncation means that the data will not fit in the space allocated. So if you have it set to string 40 and there is a 50 character string it...

You need to use dynamic SQL to do this. You also need to do some research into SQL Injection as this type of code opens you up to this.

Please don't cross post.

Post answers to http://www.sqlservercentral.com/Forums/Topic586744-148-1.aspx

I think this blog post might provide a better way to handle your situation:

http://pragmaticworks.com/community/blogs/brianknight/archive/2008/10/15/detecting-if-a-file-is-in-use-in-a-ssis-script-task.aspx

I'm not positive but I believe you can use the @@NESTLEVEL function as well.

The first thing I'd do is re-evaluate my recursive triggers. There should be a way...