Viewing 15 posts - 7,066 through 7,080 (of 9,720 total)
WayneS (10/26/2010)
October 27, 2010 at 5:42 am
I prefer Convert() over Cast() because I can do string tricks with my GETDATE() and still take it back to a valid datetime value. I'm not sure if you can...
October 27, 2010 at 5:34 am
I just noticed another problem. At no time in this scenario, Maina-456685, are you actually checking dbo.Contract for duplicates. You only ever check your staging table, dbo.TempCustomer for duplicates.
So what...
October 27, 2010 at 5:24 am
Ah. I did not catch that fact. Chris, you are correct. So even if the ContractAuditID problem is corrected, the code will still fail.
October 27, 2010 at 5:21 am
A few minor nitpicks that might not matter in your current environment but could cause problems for you later. (FYI: Grain of salt moment. These just happen to be two...
October 27, 2010 at 4:37 am
Maina-456685 (10/27/2010)
....
Condition 3: If an entry is not duplicated in TempCustomer, but already exists in Contact,...
October 27, 2010 at 4:26 am
Dread,
Glad your problem is resolved and thank you for posting your solution.
If you ever do remember the forum name or the forum thread, please make sure to link it...
October 26, 2010 at 11:25 am
Michael Valentine Jones (10/26/2010)
Make sure you follow that code the way I posted it
Yeah, my edit must have crossed your posting.
October 26, 2010 at 10:17 am
Michael,
EDIT again: I take back everything I just said. I forgot to re-login. Crap. What was MS thinking when they did this?
I just tested impersonate. You're working off an invalid...
October 26, 2010 at 9:59 am
I'll double-check the impersonate, but when I logged in as the SecurityAdmin account, I was unable to grant actual SysAdmin to my own account.
October 26, 2010 at 9:56 am
Edit: Changing my answer.
It's a semi-good point. A user with every other permission cannot grant herself sysadmin access even when she has SecurityAdmin perms. Which is good from a security...
October 26, 2010 at 8:19 am
Have you used the multi-server admin tools yet? That's my primary interest in R2.
October 26, 2010 at 8:10 am
Well, I'm glad you found what could be the error.
I'm a little confused as to why you need to take liberties with the code for SSIS. Usually, you just need...
October 26, 2010 at 7:49 am
Rocky Horror Picture Show
Showing at a theatre near you... Though I do believe Comcast advertised it for a local channel last weekend...
October 26, 2010 at 7:45 am
Thank you for the information on costs. I hadn't seen that either.
October 26, 2010 at 7:43 am
Viewing 15 posts - 7,066 through 7,080 (of 9,720 total)