Forum Replies Created

Viewing 15 posts - 7,276 through 7,290 (of 9,720 total)

  • RE: Database Goes Missing

    That's good information, Stephan. I didn't even see that there. Thanks.

    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 7, 2010 at 12:34 pm

    #1233862

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/7/2010)

    Brandie Tarvin (10/7/2010)

    ...But on a serious note: 17 feet long and yes, my Mom used the actual pattern when she knitted it back in the '80s. Not 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 7, 2010 at 12:10 pm

    #1233838

  • RE: Are the posted questions getting worse?

    Kit G (10/7/2010)

    Brandie Tarvin (10/7/2010)

    jcrawf02 (10/7/2010)

    it's that whole theory about how time-travel is impossible because once it's possible, you'll inevitably change things in such a way that the timestream...

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

    #1233829

  • RE: Database Goes Missing

    Stephan Douglas (10/7/2010)

    If the SSAS database is no longer visible in management studio.

    Check the file system for the db files, see if somehow they got deleted.

    Stephan, I found out this...

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

    #1233824

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/7/2010)

    it's that whole theory about how time-travel is impossible because once it's possible, you'll inevitably change things in such a way that the timestream it was invented in...

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

    #1233815

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

    liewsb (10/7/2010)

    Hi Gail and Brandie,

    Thanks for your helps so far.

    AS I just take other this DB job, I really need you all helps to slove this urgent issue now...

    Stop. Take...

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

    #1233812

  • RE: Potential Issue with Re-Naming Stored Procedures

    But if you're going to rename and alter, you might as well just drop and create. It's cleaner.

    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 7, 2010 at 9:40 am

    #1233712

  • RE: Potential Issue with Re-Naming Stored Procedures

    Nakul Vachhrajani (10/6/2010)

    Use sys.sql_modules instead.

    Thanks, Nakul. I didn't even know this table existed.

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

    #1233445

  • RE: Potential Issue with Re-Naming Stored Procedures

    Dropping and recreating procs is a regular part of our SDLC. We only ever use rename when we're going to archive off the proc. We want to make sure that...

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

    #1233443

  • RE: Database Goes Missing

    Here's a sample path for where your SSAS database could be located. Check this and see if you can find the .cub and .dim files associated with the cube. 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.

    October 7, 2010 at 6:00 am

    #1233437

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

    October 7, 2010 at 5:44 am

    #1233426

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

    October 7, 2010 at 5:38 am

    #1233421

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

    October 7, 2010 at 5:31 am

    #1233418

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

    October 7, 2010 at 5:31 am

    #1233416

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

    October 6, 2010 at 12:29 pm

    #1232942

Viewing 15 posts - 7,276 through 7,290 (of 9,720 total)