Viewing 15 posts - 5,041 through 5,055 (of 5,102 total)
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...
November 18, 2003 at 7:21 am
Bay the way 8.00.194 is the RTM version of SQL Server.
Don't you think you should update to SP3a?
November 18, 2003 at 7:08 am
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
November 17, 2003 at 8:09 am
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...
November 17, 2003 at 6:50 am
make sure you can reach the server from that machine! it sounds like the client lost configuration info
November 14, 2003 at 10:58 am
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
November 14, 2003 at 10:53 am
Save @@ERROR in a @variable if is not 0 and then
select description from master.dbo.sysmessages where error = @variable
HTH
November 14, 2003 at 10:42 am
Make sure that the login you are using to execute xp_sqlagent_proxy_account have exec permissions on the procedure in the master!
November 14, 2003 at 10:21 am
Have a look at Q137983
November 14, 2003 at 10:05 am
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...
November 14, 2003 at 9:08 am
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...
November 14, 2003 at 8:07 am
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...
November 13, 2003 at 8:03 am
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
November 13, 2003 at 7:31 am
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...
November 13, 2003 at 7:25 am
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...
November 13, 2003 at 7:15 am
Viewing 15 posts - 5,041 through 5,055 (of 5,102 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy