Forum Replies Created

Viewing 15 posts - 8,071 through 8,085 (of 9,720 total)

  • RE: Truncate rollback

    SwaroopRaj (4/23/2010)


    yep.. i thought that 'truncate' would never rollback. That was the way i was taught in past. You proved that wrong for me now.

    The thing that trips most...

    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: Truncate rollback

    The person who posted the question should have specified environment. I didn't have to run the code to know the VALUES statement wouldn't work in 2005. Therefore, I chose "Error"...

    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: Visual Studio Version?

    Thank you. I greatly appreciate your assistance.

    Now all I have to do is make sure I've got space on my HD cleared out. @=)

    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: Talking Back

    jcrawf02 (4/16/2010)


    I wouldn't think writing a blog post would really be different from writing an article? If you're going to write a slop blog, then you'd write a slop article...

    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: Talking Back

    Jeff Moden (4/15/2010)


    I agree with that which has already been stated... I'd like to see SSC spend more time and money on getting people to publish articles than spending even...

    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: Talking Back

    CirquedeSQLeil (4/15/2010)


    Revenant (4/15/2010)


    Microsoft:

    "As a general rule, Microsoft has a very simple policy on blogs: We expect employees to be smart and exercise good judgment. ..."

    I like this stance. ...

    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: Talking Back

    FYI: The Ben Silverman blog link points to a parked webpage at Go Daddy.com

    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: SQL Job appear to run when job has been disabled???

    I'm going to have to do more research. I'm now being told this happens when disabling jobs through the GUI, not just the code.

    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: SQL Job appear to run when job has been disabled???

    We've apparently had the same problem. In disabling jobs (jobs that restore backups down to our Dev server) during month end, the job gets disabled but then still runs as...

    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: SQL 2005 - MDF deleted LOG file available

    durai nagarajan (4/5/2010)


    yes still want to recover it because while trying inserting more than a year data may miss out that too from different sources.

    You never did answer Gail's question.

    Is...

    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: SQL 2005 - MDF deleted LOG file available

    It sounds like this latest question is something different from your original post. If that is indeed the case, please remember that new & unrelated questions should have their own...

    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: SQL 2005 - MDF deleted LOG file available

    chrisph (3/31/2010)


    Is it possible the server team could go back and restore the .mdf from their backup procedures?

    I would check/ask if they have "volume shadow copy" enabled on the 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.

  • RE: Drop all connections

    river1 (3/31/2010)


    No need steve, i want to delete almost all the logins. But thanks

    But disabling them first will guarantee you'll be able to delete them afterwards.

    Can't logon to the system...

    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: Need freq. updated, writeable copy of OLTP db for reporting

    Glad we could help. BTW, setting up a restore as an auto-job is probably going to be the hardest part. Once you have it set up, you can pretty much...

    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: Install SQL server 2005 developer edition

    If the software was already staged, chances are that's why it's skipping the software check. It's probably been short-cutted to do so.

    Basically, you'll have to manually do the checks 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.

Viewing 15 posts - 8,071 through 8,085 (of 9,720 total)