I also find checking the view "sysmail_allitems" usefull if i am having problems it can aoften highlight something obvious.

Hi

I had a similar problem and used the following code to get around it.

DECLARE @cmd VARCHAR(255)

DECLARE @Wait INT

DECLARE @result INT, @OLEResult INT

DECLARE @ShellID INT

SET @Wait = 0

...

Half of our applications are still running on 2000, we still have a lot to do to move everything to 2005 so will probably skip 2008 unless there is a...

This is so true about the won't upgrade until SP1 culture, I gave MS benefit of the doubt with Vista and got bitten. SP1 does now seems like the product...

We still have just under 100 databases to upgrade to 2005 yet, these are a mixture of 3rd party applications and in house. We will (if the wind is in...

I have been struggling to see why we need XML, but recently i was tasked with generating an RSS feed from a SQL table to run our companies news ticker...

An excellent article, I have been looking for a method to get an rss feed out of a sql table and this looks like it may be able to help.

40Gb on Laptop

40GB on PC

320GB external drive that i share with both PC and Laptop

20GB Sony MP3