Save yourself some grief dealing with Outlook profiles and MAPI. Get xp_smtp_sendmail from http://www.sqldev.net

Once the DLL is registered in SQL Server there is no further setup required. It just...

ExecuteWithResults expects a resultset to be returned so you can't execute this as a batch because the 'GO' signifies multiple batches.

You should be able to execute it using ExecuteImmediate and...

How about using Reporting Services?

Using Web Service calls you can render any given report in the format you require and then you can email out the result.

I think the reference to installing software is for mail servers, etc...

Done it many times without any problems.

Jeff, thanks for illustrating what I said

"Of course with these samples you could remove the WHILE loop and copy the CHAR/SUBSTRING for as...

I'd have to agree with that. Nothing better than a user saying how easy xyz job is now they have application abc.

Ahhh ... renamed all but the DECLARE ... DOH!!!

Also, dredged this up which works as well.

DECLARE @MyCode varchar(6)
DECLARE @Min int
DECLARE @Max int;

SET @MyCode = ''
SET @Min = 65
SET...

If you goal is to generate a random six character string, then this seems to work. The main problem in generating random numbers in SQL Server is providing an appropriate...

Joe has pretty much got everything covered. Although, I'd probably add one more,

How much load is the app/db processing going to put on the server?

We had an application setup recently that...

No, there is no report bursting capability in Reporting Services. We came up against the same issue and had to re-work how the report is produced.

You can approach it a...

Take a look at my script over here

http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=40

If all you want is success or failure messages from DTS, then take a look at the DTSSMTP Mail Task over at http://www.sqldev.net

This uses basic SMTP mail settings and...

Well if you're going to have that many values, using them is the IN clause of a WHERE is the wrong way to approach it. You'll have a large performance...

Pass your list of values to a table function that splits the values into separate records.

EG:

SELECT * FROM tablename tbl
INNER JOIN [table_function_name](@search_clause, ',') as Itm
ON tbl.columnname = Itm.Items

This is...