Viewing 15 posts - 1,936 through 1,950 (of 9,707 total)
Someone mentioned a setting in a post without mentioning if it was a server, database, or object level setting. I wanted to plug in that phrase and see what popped...
March 22, 2016 at 7:59 am
Koen Verbeeck (3/22/2016)
In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the commotion...
I didn't realize you worked in Brussels. Glad...
March 22, 2016 at 6:06 am
BL0B_EATER (3/22/2016)
March 22, 2016 at 4:06 am
JeremyE (3/21/2016)
Distributed transactions for AlwayOn will be supported in SQL 2016 but not SQL 2012.https://msdn.microsoft.com/en-us/library/ms366279(v=sql.110).aspx
Really?
Thank you for that information, Jeremy.
March 22, 2016 at 4:04 am
Check the linked server itself and make sure that RPC and RPC Out are both set to TRUE.
March 21, 2016 at 12:36 pm
alicesql (3/21/2016)
So, in SQL Agent, I chose File System for the SSIS job step Package Source, and point it to the same package location that is used in VS.
This...
March 21, 2016 at 12:31 pm
alicesql (3/21/2016)
March 21, 2016 at 12:27 pm
Alan.B (3/21/2016)
yb751 (3/21/2016)
SQLRNNR (3/21/2016)
Brandie Tarvin (3/21/2016)
Lynn Pettis (3/21/2016)
March 21, 2016 at 12:13 pm
Lynn Pettis (3/21/2016)
March 21, 2016 at 8:18 am
below86 (3/21/2016)
And if you don't have the rights to create the SP on the server?
I presume the company in question would have an SDLC process to move something from Dev...
March 21, 2016 at 8:13 am
Luis Cazares (3/21/2016)
Eirikur Eiriksson (3/21/2016)
Brandie Tarvin (3/21/2016)
For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.😎
Now, that's a great idea....
March 21, 2016 at 8:10 am
March 21, 2016 at 7:49 am
manoj.kumar-1078069 (3/17/2016)
2) Loop over the record set and store each query in a variable
Depending on how big the query is, this may not work. Variables in SSIS have a...
March 21, 2016 at 7:37 am
below86 (3/16/2016)
Brandie Tarvin (3/15/2016)
aavi1011 (3/14/2016)
App team provided select statements and want output of select statement as report in xls or csv format to thier email ID
Is this a one off...
March 21, 2016 at 7:32 am
Steve Jones - SSC Editor (3/15/2016)
JustMarie (3/15/2016)
Steve Jones - SSC Editor (3/15/2016)
One bit of advice. Work with your body shop to make sure that the repairs come under...
March 15, 2016 at 11:58 am
Viewing 15 posts - 1,936 through 1,950 (of 9,707 total)