Viewing 15 posts - 3,556 through 3,570 (of 7,636 total)
Yeah, they tend to say that because Microsoft says it. But Microsoft never explains why they say it, except as part of the general "Surface Area" security policy. ...
February 23, 2009 at 1:30 pm
What security implications would that be? So far as I know, it's just disabled by default as a Surface Area issue: That is, don't enable things that you...
February 23, 2009 at 1:19 pm
As Bruce pointed out, you cannot use Dynamic SQL inside a SQL UDF. If you can bypass the need for an actual function, then Dynamic SQL will do the...
February 23, 2009 at 12:54 pm
Looks OK to me. (Or has it been fixed already?)
February 23, 2009 at 12:03 pm
OK, I just confirmed that when I am at work, the SQL Agent works just fine. Unfortunately, I still need a way to get it to work from home......
February 23, 2009 at 12:01 pm
Jeff Moden (2/22/2009)
For article submissions, a better preview would be good.
That would be a big help. So would the equivalent of the "Quote" button on Posts for the Articles,...
February 22, 2009 at 8:09 pm
Got me. I tried changing the Job owners to "sa", didn't help.
Here's the SQLAgent log from a few minutes ago:
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator...
February 22, 2009 at 7:31 pm
It's set to use the "Local System Account" now (from the Services manager), is that not sufficient?
February 22, 2009 at 4:57 pm
Heh. Agreed.
February 22, 2009 at 4:51 pm
Yeah, I typically get that error when someone has posted and then deleted their own post.
February 22, 2009 at 4:50 pm
The point is: you can do this, you just cannot do it inside a UDF. You can do everything else that you mention in your UDF, but you cannot...
February 22, 2009 at 2:12 pm
Your other choice is to copy your ##temp_text table over to SQL2005 first.
February 22, 2009 at 1:39 pm
If you do have the Linked server above defined, then I believe that the correct syntax shoud be:
exec SQL2005.msdb.dbo.sp_send_dbmail
@profile_name = 'Sample', ...
February 22, 2009 at 1:38 pm
Did you make a Linked Server on SQL2005 called SQL2000 to point back to the SQL2000 server?
February 22, 2009 at 1:35 pm
Viewing 15 posts - 3,556 through 3,570 (of 7,636 total)