Forum Replies Created

Viewing 15 posts - 7,111 through 7,125 (of 9,720 total)

  • RE: Today's Random Word!

    Forget about all that. He has an office.

    Oooohhhh.

    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 25, 2010 at 7:32 am

    #1241567

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/25/2010)

    george sibbald (10/24/2010)

    I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans....

    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 25, 2010 at 5:53 am

    #1241516

  • RE: SSIS Insert Violation of PRIMARY KEY constraint during insert on SSIS

    You're very welcome. We're glad you figured it out.

    Thanks for posting your solution. That will help other people in the future.

    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 25, 2010 at 5:34 am

    #1241497

  • RE: Today's Random Word!

    biscuit

    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 25, 2010 at 5:33 am

    #1241495

  • RE: "Sysadmin required" - A question

    George,

    Apply patches is a good one. I forgot about that. If you think of anything more, please let me know.

    I've got SQL Configuration and Surface Area Configuration down, but...

    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 25, 2010 at 5:16 am

    #1241492

  • RE: Are the posted questions getting worse?

    GilaMonster

    I love this reply from one of the regulars over at SQLTeam

    Have a look at your post and then think about if we can understand what you want...

    Hey, If I...

    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 22, 2010 at 11:01 am

    #1241072

  • RE: Default Language

    This is what the 2005 BOL states:

    Use the default language option to specify the default language for all newly created logins.

    It might be working. Test a new login.

    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 22, 2010 at 10:43 am

    #1241059

  • RE: More efficient way

    Bill,

    You can't get good help without posting sample data, DDLs and code. The way to overset the privacy restrictions is to basically scrub your data and code. Make it generic...

    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 22, 2010 at 8:14 am

    #1240943

  • RE: Today's Random Word!

    Do you do spicy chili or non-spicy?

    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 22, 2010 at 6:12 am

    #1240846

  • RE: Bundle/Group data elements linked in M-M table

    kajf (10/22/2010)

    I thank you both very very much for all help and think this is it!

    However, if you find any error's or suggestions on improvement I'm all ears.

    For example the...

    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 22, 2010 at 6:11 am

    #1240845

  • RE: How to Display SQL services account information using TSQL

    For dtsconfig files, you can do a Windows Explorer search on the directory and it should be able to search inside the files for the account name in question. Just...

    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 22, 2010 at 6:00 am

    #1240840

  • RE: Today's Random Word!

    Chili!

    We're having a chili cooking contest for lunch today. It's gonna be fun. I LOVE my workplace... @=)

    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 22, 2010 at 5:57 am

    #1240838

  • RE: Today's Random Word!

    Ray K (10/21/2010)

    Craig Farrell (10/21/2010)

    fowl language

    Quack! Honk! Gobble! Cluck!!!

    Hee!

    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 22, 2010 at 5:57 am

    #1240836

  • RE: Bundle/Group data elements linked in M-M table

    kajf (10/21/2010)

    Following your instructions I applied an outer join (of course my way might be wrong). For simplicity I have not include the WHERE #AC_Temp.C IS NULL statement to show...

    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 21, 2010 at 10:45 am

    #1240465

  • RE: Using Like

    kancherla.ks (10/21/2010)

    i have to select a column from a table which has all these 80 words so i am planning to write this using LIke.

    please suggest me if you...

    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 21, 2010 at 8:55 am

    #1240382

Viewing 15 posts - 7,111 through 7,125 (of 9,720 total)