Sorry, still not got to the bottom of this !

Problem is I have so much asp code to try and catch this it is proving very difficult.

I still have the...

Thanks, do you know if there is a way of determining the number of opened connections ? Is this set-up in IIS ?

I could test this with a dummy script...

Hi,

Thanks for the reply.

Sorry I don't think so as I do not store record sets into a session !

Thanks.

Mike

SORRY MESSAGE AGAIN ! Many thanks for the replies, basically the tables holds 122K inventory items exported from a VAX system. The only reason why I make a backup is...

Many thanks for the replies, basically the tables hold 122K inventory items exported from a VAX system. The only reason why I make a backup is so I can compare...

Hi,

It works !!!

I think the key to this one is you stopped the mail service before specificing a new profile as it also works now without sending a password.

Thanks once...

Thanks for that.

Our IIS server is logged in as Administrator and both Exchange profiles can be access by this user.

Do you mean I should start the xp_startmail with an NT...

Are these backups to DAT tapes on the same server or mapped networked drives ?

Cheers

Mike

Thanks for that, in reading up on the command structures, it appears to create .dat files rather than the actual .mdf and .ldf files. Is this correct ?

I presume if...

My Scripts looks like this :

DECLARE @sql nvarchar(200), @temp nvarchar(200)

DECLARE @email_campaign_id as int, @status int, @start_datetime datetime, @email_max_quantity int, @email_quantity int, @email_subject nvarchar(50), @email_message nvarchar(4000)

DECLARE record_cursor CURSOR FOR

SELECT ...

Ok...

I now have the number of the records I want to return in a variable called @email_max_qty (value = 40)

So I need to replace the following:

DECLARE record_cursor CURSOR FOR

SELECT TOP...

Superb...

Thank you all for you help...

Mike

Thank you all for your replies.

Greatly appreciated.

Using the DTS packages is it possible to delete (or drop) the contents of a table before importing the data or is this best...

Thank you all for your replies.

Greatly appreciated.

Using the DTS packages is it possible to delete (or drop) the contents of a table before importing the data or is this best...

Jeremy,

Works like a dream....

Thanks very much for that, greatly appreciated.

Mike