Forum Replies Created

Viewing 15 posts - 5,491 through 5,505 (of 9,715 total)

  • RE: Unable to connect DB server across domain

    Do you have a 2k8 server in the domain that VS2k5 is in? Have you tested the connection that way?

    I'm wondering if there's a problem with VS2k5 seeing SQL Server...

    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.

    July 26, 2011 at 7:50 am

    #1358518

  • RE: Symantec Backup Exec

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

    July 26, 2011 at 7:42 am

    #1358508

  • RE: When to use full-text

    In an effort to not scare you off of full-text, I've called in reinforcements to offer alternatives. I have, unfortunately, reached the limit of my knowledge in this subject.

    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.

    July 26, 2011 at 7:40 am

    #1358507

  • RE: Are the posted questions getting worse?

    Can someone with Full Text knowledge help out here: http://www.sqlservercentral.com/Forums/Topic1147434-1292-1.aspx#bm1147915

    I think I scared the OP into thinking Full Text was Evil and useless, which is not what I was trying...

    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.

    July 26, 2011 at 7:38 am

    #1358502

  • RE: How to properly design this DB

    Good to hear. Glad we 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.

    July 26, 2011 at 7:36 am

    #1358499

  • RE: Retrieving records for accounts opened between the first day and the last day of previous month

    Glad I could help.

    Remember, keep "pretty" on the user side. Don't worry about it for the backend stuff.

    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.

    July 26, 2011 at 7:34 am

    #1358498

  • RE: remove last character from string

    justintime (7/25/2011)

    yep gotcha on the string length parts. does the value that i set for the variable matter?

    We're just using the variable as an example. you don't...

    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.

    July 26, 2011 at 7:33 am

    #1358494

  • RE: remove last character from string

    Where the 5 and 4 are in my code, these are the string lengths. If you want a variable strength length, then you just replace the numbers with LEN(Myfield)-1 and...

    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.

    July 25, 2011 at 12:36 pm

    #1358064

  • RE: Are the posted questions getting worse?

    john.arnott (7/25/2011)

    Gus,

    Thanks for the encouragement. I've submitted my meta-QOD.

    And I can't wait to complain about the correct answer to 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.

    July 25, 2011 at 12:34 pm

    #1358063

  • RE: What's a safe backup?

    Ninja's_RGR'us (7/25/2011)

    Please not he said COPY and not MOVE. If something bad happens during the move you lose the DB, copy is safer there.

    Ninja, I'm sorry, but this reply...

    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.

    July 25, 2011 at 12:28 pm

    #1358057

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/25/2011)

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to...

    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.

    July 25, 2011 at 12:23 pm

    #1358052

  • RE: Are the posted questions getting worse?

    GilaMonster (7/25/2011)

    SQLRNNR (7/25/2011)

    GilaMonster (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand...

    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.

    July 25, 2011 at 12:12 pm

    #1358046

  • RE: Retrieving records for accounts opened between the first day and the last day of previous month

    rbond 51820 (7/25/2011)

    We are converting the date to string because the end users tend to "freak" when they see the system datetime with hh:mm:ss rather than just the date only...

    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.

    July 25, 2011 at 12:04 pm

    #1358037

  • RE: Are the posted questions getting worse?

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to me, Gus, and...

    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.

    July 25, 2011 at 12:02 pm

    #1358034

  • RE: sp_send_dbmail with dynamic body

    Dynamic SQL is when you populate a variable with a SQL query or another stored procedure. Read up on sp_executesql when you get a chance, so you understand what can...

    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.

    July 25, 2011 at 11:53 am

    #1358024

Viewing 15 posts - 5,491 through 5,505 (of 9,715 total)