Many thanks for all your help guys, I've managed to get it working.

Very much appreciated!!

Cheers

Dave

thanks for the reply Andras.

I need to delete data that is 3 days old from the database. I'm just using a select to show the data to start with before...

well, it doesnt give an error as such, it just stick a few spaces in the SQL.

e.g. = "getdate()-3" changes to "Getdate() - 3"

this is the query...

SELECT ...

Thanks Steve,

yeah its a SQL Server Agent Job, I'd ideally like to have the values saved into a table and just have the scheduled task check the table date...

wait...

Cheers Mike,

I'll give it a go..

Dave

Thanks for the reply Steve, Sorry, I didnt know there was a DTS area.. Thanks for moving it for me.

yep. after looking into the SQL server specs, its running on...

this is the one i use..

Sub thisname()

Dim strDate As String

Dim strSite As String

Dim strOrder As String

...

What Client OS are you using?

is the local FW enabled? its more then likley that the PC can't see the server.

is the SQL servers FW enabled?

cheers

Dave

Doh.. sorry, I really should look to see if there are other pages.. ffs... going home... 🙁

not sure why you have two objects for mail..

bin the Imsg one.

here is my working sample of the same code

set msg = CreateObject("CDO.Message")

msg.From = "sql.server@businessName.com"

msg.To = "joebloggs@businessName.com"

...

Hi there,

have alook at my post.. All the code is there to do this.

http://www.sqlservercentral.com/Forums/Topic434295-5-1.aspx

Regards

Dave

yeah, I guess all the constraints can be done within the application.

but to help or even stop end line users from making a mash of the database structure, i would...

thats a great idea.. i'll give that a try in the morning..

cheers

Dave

Hi MarkusB,

Thanks for the suggestion, it seens to be overwriting it...

fingers crossed.

Cheers

Dave

your an absolute star Ramesh..

many thanks.

Dave