Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 9,715 total)

  • RE: insert if not exists, if it does insert into another table

    Maina-456685 (10/27/2010)

    Condition 1: If an entry is duplicated in TempCustomer, insert into ContactAudit table.

    ....

    Condition 3: If an entry is not duplicated in TempCustomer, but already exists in Contact,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 27, 2010 at 4:26 am

    #1242749

  • RE: SSIS Script Component Issue

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 11:25 am

    #1242460

  • RE: "Sysadmin required" - A question

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 10:17 am

    #1242410

  • RE: "Sysadmin required" - A question

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 9:59 am

    #1242394

  • RE: "Sysadmin required" - A question

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 9:56 am

    #1242393

  • RE: "Sysadmin required" - A question

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 8:19 am

    #1242312

  • RE: SQL Server 2008 (non-R2 version) question

    Have you used the multi-server admin tools yet? That's my primary interest in R2.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 8:10 am

    #1242298

  • RE: tempdb woes - space not freeing up during SP

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 7:49 am

    #1242263

  • RE: Today's Random Word!

    Rocky Horror Picture Show

    Showing at a theatre near you... Though I do believe Comcast advertised it for a local channel last weekend...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 7:45 am

    #1242258

  • RE: SQL Server 2008 (non-R2 version) question

    Thank you for the information on costs. I hadn't seen that either.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 7:43 am

    #1242252

  • RE: BCP in

    jez.lisle (10/26/2010)

    EDIT: You may also have to put the -S + @@ServerName before the -T. You need the server to log into before the credentials, I believe. But test it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 7:40 am

    #1242251

  • RE: "Sysadmin required" - A question

    Thanks, Michael. I know what the fixed server roles do. What I'm trying to figure out is what they might not cover that would be necessary for a DBA who...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 5:38 am

    #1242164

  • RE: SQL Server 2005 setup failing

    Glad I could help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 5:35 am

    #1242162

  • RE: BCP in

    Do you realize your specified field terminator is not the same as what's in the file?

    You're specifying a comma. The field terminator appears to be a semicolon.

    EDIT: You may also...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 5:30 am

    #1242158

  • RE: Team Foundation Server

    Sorry I wasn't able to help you further.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 26, 2010 at 5:25 am

    #1242153

Viewing 15 posts - 7,066 through 7,080 (of 9,715 total)