Viewing 15 posts - 7,306 through 7,320 (of 11,676 total)
aarionsql (4/17/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:59 pm
Right-click on SQL Server Agent and select properties.
Go to the Alert System tab. Check if the Enable Mail Profile checkbox is selected and that the correct mail profile is chosen.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:55 pm
irridessa (4/17/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:53 pm
It's up to you.
You can upgrade your SQL Server 2008 instance to 2008R2, or you can install a new 2008R2 named instance.
Is this locally on your computer or in a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:51 pm
SQLRNNR (4/17/2012)
We need more of these types, Koen.
There is another one scheduled for the end of the month.
I'll try to think of more SSIS 2012 questions 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:10 pm
Since this is a repost from an editorial written in 2007 - 5 years ago - what is your current viewpoint?
A lot of things surely have changed: a shift to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 11:06 pm
imani_technology (4/17/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 1:33 pm
Dexter Jones (4/17/2012)
That's implied, but not stated, in the TechNet article.I suggested via Connect they update the article to avoid confusion going forward.
It says
The table below lists the supported upgrade...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 9:42 am
This should get you started:
Querying SQL Server Agent Job Information[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 7:18 am
DugyC (4/17/2012)
At first thought it wasn't fair to ask a SQL 2012 question as its so new...
Hold on to yourself, because it's a SSIS 2012 question tomorrow 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 3:01 am
ran.ovadia (4/17/2012)
Thanks, I just changed the regional settings...Now it works.
Great, glad that you got it working.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 2:15 am
edvard 19773 (4/17/2012)
Its repeated in a better place (Forum), where i got a proper answer.
But, I really want to be able to run through a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 1:45 am
opc.three (4/13/2012)
If you can play, I would try installing the Dev instance and see...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 1:37 am
UPDATE r
SET employeegroupid = tmp.employeegroupid
FROM
dbo.rollingdutyrostershift r
INNER JOIN
(
SELECT DISTINCT employeeid, employeegroupid
FROM...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 1:33 am
Make sure you export the data as unicode.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 1:29 am
Viewing 15 posts - 7,306 through 7,320 (of 11,676 total)