Are you using SQL's native Backup utility? If so why don't you specify how many days old the backups can be? This way SQL will automatically delete the backup...

Check out SQL Profiler. In Management Studio it's under Tools -> Sql Profiler. You can trace all database activity. It'll tell you all sorts of good stuff!

You can trace...

Thanks for the reply I just realized I was looking at the wrong temp table (which had no data at that point in the query)... doh! I thought maybe it...

Thanks G² and Mark!

That was definitely the issue!!!!

If you use the sp_DisplayOAErrorInfo which calls sp_hexidecmal and sp_OAGetErrorInfo (Extended System SP) it'll convert that HResult into a readable error.

I'm pretty sure you'll have to create sp_DisplayOAErrorInfo...

You need to capture the OA error output of the various methods being used. You may have an OA error but the email procedure won't display that info without the...

Jeff,

Good article. I'll have to try that next opportunity I get!

If the data is going to be different lengths then the code I provided would not work although it can be modified to do so.

As far as the function Lynn...

Here is one way to do it:

declare @Acc varchar(100),@AccString varchar(100)

set @AccString = 'Res1,Res2,Res3,Res4' --or select @AccString = Column from YourTable

--Create Temp Table

IF Object_ID ('#Array') is null

BEGIN

Create Table...

You can do this a few ways but it depends on the data that's being input.

Do you know what kind of data is going to be input? Will it be...

Okay I figured it out. While the above command successfully runs but doesn't change the data the problem was I need to put the replace command in front of the...

That was a good suggestion. I totally forgot about email size.

The attachment when I export it from the Web is only 220KB so It's small. However when viewed in the...

aram,

Are you referring to using the XML Datatype with the sp_MakeWebTask proc?

I only specified -C (Chacter) with that proc so maybe that will work.

Bob,

Thanks for the reply.

I am using SQL 2000.

I am not sure about using ROOT with the FOR XML command. I didn't know that was an option... hopefully it's applicable...

Fixed.

AIf you include both carets it wipes out them and everything between them.

I used "Closed Tag" to represent a ">"