Viewing 15 posts - 1 through 15 (of 37 total)
Thanks for response Sue! You are correct, the entire record was not a duplicate but a dup on the primary key.
I actually found an explanation to IGNORE_DUP_KEY...
September 20, 2016 at 8:15 am
Thanks for the quick response!
Going to check now and will respond back with results.
July 14, 2016 at 12:31 pm
Thanks for the info and book reference! I'll definitely check it out.
I don't need to be hand fed, but sometimes just pointed in the right direction when I'm totally...
May 26, 2016 at 1:05 pm
Nice! And it was right there in front of me the whole time.:-) Thanks so much for the assistance!
August 29, 2014 at 7:49 am
Thanks for the link but it's still working one package at a time to get the information. Granted, once it's done you've got it, but for now I was...
August 29, 2013 at 2:15 pm
Sorry for omitting that information. We're on SQL server 2008 and all packages are stored in MSDB.
August 29, 2013 at 1:10 pm
Disregard ... I learned I could add a package back into BIDS from the MSDB.
August 29, 2013 at 11:39 am
I could not agree with you more Erland. Unfortunately this database was recently handed off to me. The other administrator had an identity seed in the production table,...
August 12, 2013 at 8:17 am
ScottPletcher (6/21/2013)
Depending on exact circumstances, you might be able to change the current table to be a view that's defined as a...
June 24, 2013 at 9:54 am
Wow – what great info! Thanks Gail for the info on the log backups. I had read several articles on changing the recovery mode to simple when doing the...
June 21, 2013 at 8:21 am
Ahh … password!
I initially had a password on the package, however when I made changes to the package I changed the security setting to ServerStorage and saved it to MSDB....
May 2, 2013 at 10:03 am
Excellent! Thanks for your reply.
March 19, 2013 at 3:13 pm
I used SSAS to create an extensive calendar table, which includes fiscal year. Then just link by date and you can get any combination of calendar data.
August 7, 2012 at 7:41 am
I'm not a network person but as it was explained to me ... our SAN failed over to another SAN and it so there was a bottleneck going on causing...
July 11, 2012 at 10:58 am
Viewing 15 posts - 1 through 15 (of 37 total)