Forum Replies Created

Viewing 15 posts - 7,291 through 7,305 (of 9,725 total)

  • RE: Query not returning the right amount of records.

    Chris Morris-439714 (10/7/2010)


    So, what's this all about?

    INNER JOIN SOP30300

    ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE AND RM20101.DOCNUMBR = SOP30300.SOPNUMBE

    Are you absolutely sure that RM20101.DOCNUMBR should match to SOP30300.SOPNUMBE ? Look at...

    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.

  • RE: How to truncate log file in SQL Server 2005

    liewsb (10/7/2010)


    my scheduled backup is from Right click on DB->Task->Backup, and choose Database. The output file is having extension .bak

    But you don't say what type of backup you're doing. There...

    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.

  • RE: Are the posted questions getting worse?

    GilaMonster (10/7/2010)


    This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx

    Time to get the crystal ball out again.

    Apparently it's my turn to feel snippy. I couldn't resist.

    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.

  • RE: Update stats error

    Google your error. See what you come up with. When you get confused, refer to these threads:

    How to ask questions

    How to post problems[/url]

    How to post code questions[/url]

    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.

  • RE: Today's Random Word!

    Brandie Tarvin (10/6/2010)


    mbricker-600840 (10/6/2010)


    Tom.Thomson (10/6/2010)


    Brandie Tarvin (10/6/2010)


    CirquedeSQLeil (10/6/2010)


    Wow, SSC is all about milestones this week.

    This thread is about to break 3000 posts too.

    Post for the sake of bumping the post...

    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.

  • RE: Today's Random Word!

    mbricker-600840 (10/6/2010)


    Tom.Thomson (10/6/2010)


    Brandie Tarvin (10/6/2010)


    CirquedeSQLeil (10/6/2010)


    Wow, SSC is all about milestones this week.

    This thread is about to break 3000 posts too.

    Post for the sake of bumping the post #. @=)

    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.

  • RE: Are the posted questions getting worse?

    Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not...

    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.

  • RE: Query not returning the right amount of records.

    kbnyny (10/6/2010)


    I have a query that is not pull all the data that it should be pulling. It should return 170 records. Before i added on Table SOP30300 I was...

    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.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)


    The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems...

    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.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)


    Brandie Tarvin (10/6/2010)


    Stefan Krzywicki (10/6/2010)


    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    Really? I haven't had any problems with it. What's your issue?

    EDIT:...

    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.

  • RE: Today's Random Word!

    CirquedeSQLeil (10/6/2010)


    Wow, SSC is all about milestones this week.

    This thread is about to break 3000 posts too.

    Post for the sake of bumping the post #. @=)

    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.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)


    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    Really? I haven't had any problems with it. What's your issue?

    EDIT: Sorry. Thought you were...

    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.

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (10/6/2010)


    Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

    Numeric instead of Integar? Bad cowboy! Doesn't he know that extra byte...

    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.

  • RE: Today's Random Word!

    Ray K (10/6/2010)


    crookj (10/6/2010)


    Chris Morris-439714 (10/5/2010)


    Giant carnivorous mice

    Vorpal Bunny - Quest for the Holy Grail.

    Holy Hand Grenade of Antioch

    ...And thou shalt count to three. Not to four, which is greater...

    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.

  • RE: Database Goes Missing

    Greg Edwards-268690 (10/6/2010)


    I'd also check security for who has access.

    Best piece of advice on this thread yet.

    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.

Viewing 15 posts - 7,291 through 7,305 (of 9,725 total)