Viewing 15 posts - 3,676 through 3,690 (of 11,676 total)
The following operations cannot be performed on the model database:
...
Setting the primary filegroup to READ_ONLY.
Damn you MSDN!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 11:58 pm
SQLRNNR (2/17/2014)
Greg Edwards-268690 (2/17/2014)
Ed Wagner (2/17/2014)
EL Jerry (2/17/2014)
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al who founded it, keep up the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 1:08 pm
Internet access is not required.
.NET is required, but you can find this on the installation media of Windows Server.
In the most recent versions of Windows Server, this is just a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 1:05 pm
SQL Server uses .NET behind the scenes, such as for example in SSMS and for CLR.
The Native Client is used to connect client applications to the database (quite useful if...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 1:04 pm
Cody K (2/17/2014)
Michael Earl-395764 (11/18/2008)
Is it me, or are the posted questions getting worse these days?
It's not just you.
People can't research to avoid their problems in the first place. They...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 6:32 am
Maybe you can monitor the log? Or kick off a monotoring script in parallel with your data flow.
You insert a row into a log table before and after the data...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 4:53 am
Maybe you can add a Send Email Task before and after the data flow task?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 17, 2014 at 4:26 am
Phil Parkin (2/13/2014)
Koen Verbeeck (2/11/2014)
The easiest method imo is to use a script task, where...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 16, 2014 at 11:56 pm
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2014 at 11:12 am
Happy Hallmark Valentine's Day!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2014 at 11:10 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2014 at 11:08 am
Keith Hays (2/12/2014)
Great article, but probably needs to have a disclaimer since it doesn't necessarily apply to 2012.
The intro states:
This introductory article describes various methods on how you can deploy...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 12, 2014 at 6:03 am
According to the official blogs, you indeed need to escape the qualifier inside the column (2 times double quotes).
Flat File Source Changes in Denali
What happens if you don't add the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 12, 2014 at 3:46 am
Easy one, thanks Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 12, 2014 at 1:02 am
Maybe you want to make a system that fails gracefully when a file is not present.
The easiest method imo is to use a script task, where you can check the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 11, 2014 at 12:43 pm
Viewing 15 posts - 3,676 through 3,690 (of 11,676 total)