November 6, 2012 at 8:32 pm
Comments posted to this topic are about the item Enable Database Mail in 2012
November 6, 2012 at 11:43 pm
Easy one, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 7, 2012 at 12:52 am
Not so easy for me - have seen 2012 yet let alone used it.
Combination of elimination and guesswork got me there though
Thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
November 7, 2012 at 1:12 am
It would be new to me that sp_configure is an extended stored procedure.
I think it is just a normal system stored procedure.
But still a good question:)
Best Regards,
Chris Büttner
November 7, 2012 at 2:08 am
I could be wrong but I don't think this is new to 2012 - I think the OP was just specifying a single known version for accuracy. Pretty sure it works on 2008 although as a developer I don't tend to do a lot of config professionally...
November 7, 2012 at 2:30 am
This was removed by the editor as SPAM
November 7, 2012 at 2:35 am
good question:)
November 7, 2012 at 2:57 am
The extra point is good! 😀
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
November 7, 2012 at 5:04 am
Easy one for me.Thank you.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
November 7, 2012 at 5:44 am
Nice easy one today.
alex.d.garland (11/7/2012)
I could be wrong but I don't think this is new to 2012 - I think the OP was just specifying a single known version for accuracy. Pretty sure it works on 2008 although as a developer I don't tend to do a lot of config professionally...
Yes, it can be done with sp_configure on 2008 (and 2008 R2). But those two versions also offered two other methods of doing it (the database mail configuration wizard, and the policy based management surface area configuration tool (both inherited from 2005). Maybe in 2012 it isn't possible any more to do it three different ways, just the one way. Certainly a quick search in BoL doesn't throw up any method other than sp_configure to do in in 2012. If so it makes sense to specify 2012 to avoid any argument about whether it should be a "tick multiple boxes" question instead of a check one button question.
Tom
November 7, 2012 at 7:31 am
Was a little nervous answering this one. Seemed too easy to be the right answer.
November 7, 2012 at 8:31 am
i remembered using sp_configure to enable this in 2008 R2 and was happy to see that it was the same in 2012.
November 7, 2012 at 8:43 am
Thanks to everyone's positive comments!
My explanation is however not correct "The extended stored procedure "sp_configure""...
Chris Büttner correctly identified that sp_configure is a stored procedure used to enable extended stored procedures. Good Catch.
Today in the lab, I will see if there is another way to enable the Database Mail extended stored procedures in SQL 2012.
Best Regards,
Mike
November 7, 2012 at 9:05 am
Thanks for the good question Mike.
November 7, 2012 at 9:41 am
Thanks for a really easy one!
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply