Forum Replies Created

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

  • RE: Database Goes Missing

    Okay. I've tested the DDL trigger and it does not work against SSAS databases. Unfortunately.

    I have it straight from the horse's mouth that when reprocessing occurs, there is data file...

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

    #1234208

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

    Be aware that just typing in CHECKPOINT and executing it does not mean that it will execute immediately. SQL Server will run it immediately only if it's convenient to 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 8, 2010 at 5:23 am

    #1234156

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/8/2010)

    The Dixie Flatline (10/7/2010)

    I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who...

    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 8, 2010 at 5:17 am

    #1234151

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/8/2010)

    WayneS (10/7/2010)

    Brandie Tarvin (10/7/2010)

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

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

    #1234149

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/7/2010)

    I'd been intending to ask at some point as I do go to a number of cons, mostly in the NE US + WorldCon any year it isn'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.

    October 7, 2010 at 12:41 pm

    #1233871

  • 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

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