Viewing 15 posts - 8,536 through 8,550 (of 9,715 total)
Actually, it occurs to me to wonder if you have a link in some other table from UserID to UserName?
If UserName is not in any of the three tables...
December 19, 2008 at 5:27 am
I don't mean to offend anyone but...
Why does everyone insist on putting this check in the WHERE clause? It's messy and a Where clause usually complains when you try and...
December 19, 2008 at 5:21 am
Just an FYI. If using a variable is not an option because you're trying to do a set based conversion, then you can always use a CASE statement with a...
December 19, 2008 at 5:11 am
There is another option, though a very old option and not very pretty. Only use this if you can't convince the designers to use 2 separate columns in the main...
December 19, 2008 at 5:06 am
DOH!
I went back and checked our accounts after reading the Microsoft fix bulletin. Sure enough, different ReplyTo addresses than what's in the account name.
Fixed that and it still didn't work....
December 17, 2008 at 4:22 am
Nope. The SQL Agent Service restart didn't help me.
Darnit. This is annoying.
December 15, 2008 at 6:10 am
Well, we'll see if the restart works. I won't know until Monday.
Truthfully, though, I doubt this will solve my problem. We've failed over our cluster a number times since this...
December 13, 2008 at 7:30 am
Looking into this a little more, I finally opened up my job log and found the following error:
Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error: (501) Syntax...
December 12, 2008 at 11:46 am
I did, but my other office (different state from me) says they can't find the files.
December 12, 2008 at 10:35 am
Are you using IP & Port # for your FTP or just IP address?
December 12, 2008 at 10:29 am
Okay, I haven't tested this yet, but something about it just doesn't seem right. I've take the Upload code based on the website listed above and I have a Server...
December 12, 2008 at 6:54 am
Jack,
Do you know what the ReplyTo problem was? Or at least a good search term for me to find the problem?
December 10, 2008 at 5:12 am
Paresh,
Have you actually looked at the Books Online explaination of that proc?
Sorry, but you can't accomplish what you're trying to accomplish using SQL Server straight out of the box. If...
December 10, 2008 at 4:22 am
Jack,
We don't usually use the ReplyTo functionality of the DatabaseMail. Most of our stuff is general DBA Team alerts on failed jobs (non-repliable emails).
Rcavill, Yes, the procs were enabled...
December 10, 2008 at 4:12 am
My boss just found something on the Max Chunk Size in TechNet.
Reading or writing in small chunks causes a less optimized round trip to the server because a full...
December 9, 2008 at 4:45 am
Viewing 15 posts - 8,536 through 8,550 (of 9,715 total)