Error handling has always been IMHO the weakest point in SQL Server. I would use BulkInsert DTS Taks to handle the errors in an easier way!

You could increase the MAX_ERROR...

Bay the way 8.00.194 is the RTM version of SQL Server.

Don't you think you should update to SP3a?

SELECT Cast(Cast([decDate]+ 19000000 as char(8)) + ' ' +

Stuff(Stuff(Right('000000'+ Cast([decTime]as varchar(6)),6),3,0,':'),6,0,':') as datetime)

from FunnyDates

Ok, I got it wrong !?!? too. But I will have to join the rest of this posters because "VERSIONING" is something way past that functionality.

Can you get rid...

make sure you can reach the server from that machine! it sounds like the client lost configuration info

Because you are using Exchange Mail and NOT internet mail you are authenticating with NT Account only and that's why you don't require password.

I am glad I could help

Save @@ERROR in a @variable if is not 0 and then

select description from master.dbo.sysmessages where error = @variable

HTH

Make sure that the login you are using to execute xp_sqlagent_proxy_account have exec permissions on the procedure in the master!

Have a look at Q137983

1.The IIS account is not important for that, is the SQL Server Service Account the one that has to have the permissions

2. The procedure is like this

exec xp_stopmail -- Stop...

quiker will be to do something like

copy /b *.txt AllFiles.txt

and then do Bulk insert on AllFiles.txt

I am assuming all files are using same structure of course!

Edited by - noeld on...

I don't know how are you using the parameter

but this sholud helpyou going

 

Declare @str varchar(200)

SET @str = DB_NAME()--Assuming is going to be runned from...

1. You have to specify a password and make sure that the SQL Server account has access to that other Profile!

2. Sendmail does NOT provides HTML capabilities

HTH

just get rid of the time part on the input and sample dates.

Method1

casting as int

Cast(@inputDate1 as int)

Method2

remove time part

@newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime)

Method3

you...

Table data type can't be used as a parameter in stored procedures!

you will have to create a loop to cyle through the table to either send an message per rep...