Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 9,715 total)

  • RE: sql server name

    I'm not sure what you mean by empty. Could you clarify?

    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.

    January 30, 2012 at 7:54 am

    #1440000

  • RE: upgrade a database scheam

    Ouch. Sounds like you have SDLC issues.

    Is there a reason you can't use the Information_Schema and sys.objects tables / catalog views to do the checking with each addition / change...

    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.

    January 30, 2012 at 7:51 am

    #1439999

  • RE: sql server name

    Find the installation logs and verify that SQL Express installed correctly. Also, check your services to make sure that SQL Server service and SQL Agent Service are both running. You...

    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.

    January 30, 2012 at 7:44 am

    #1439991

  • RE: Export Database Design

    Use the Information_Schema catalog views to spit out a table / column list. Adjust the below code as necessary:

    SELECT Table_Catalog, Table_Schema, Table_Name, Column_Name, Is_Nullable,

    Column_Default, Data_Type, Character_Maximum_Length as ChLen,

    numeric_Precision,...

    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.

    January 30, 2012 at 7:39 am

    #1439988

  • RE: Today's Random Word!

    electricity

    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.

    January 30, 2012 at 7:32 am

    #1439984

  • RE: Replication as a partial DRS

    SQLKnowItAll (1/27/2012)

    Brandie Tarvin (1/27/2012)

    SQLKnowItAll (1/27/2012)

    If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending...

    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.

    January 30, 2012 at 7:26 am

    #1439977

  • RE: Replication as a partial DRS

    SQLKnowItAll (1/27/2012)

    If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending on the disaster...

    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.

    January 27, 2012 at 12:46 pm

    #1439589

  • RE: Replication as a partial DRS

    Jared,

    Actually, I'm approaching this from the POV of someone who did DR & BC design at a previous employer far far before I ever became a DBA.

    It's obvious 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.

    January 27, 2012 at 12:15 pm

    #1439569

  • RE: Replication as a partial DRS

    Reasons why I disagree with Replication as a DR solution.

    1) Latency. Depending on your replication setup, you could have more latency in it than in your normal database backups. Which...

    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.

    January 27, 2012 at 11:53 am

    #1439557

  • RE: Msg 7412, Sev 16, State 1, Line 75

    I'm reaching, but ... Does this help? http://guomingli.blogspot.com/2010/03/ole-db-provider-sqlncli-for-linked.html

    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.

    January 27, 2012 at 11:07 am

    #1439541

  • RE: Are the posted questions getting worse?

    Anybody here backup with BizTalk?

    http://www.sqlservercentral.com/Forums/Topic1242925-391-1.aspx#bm1242974

    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.

    January 27, 2012 at 10:55 am

    #1439538

  • RE: Are the posted questions getting worse?

    Someone help me. My brain is leaking.

    I think I need to stop answering forum questions for the day. My fingers and my head don't agree with each other, 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.

    January 27, 2012 at 9:36 am

    #1439477

  • RE: Msg 7412, Sev 16, State 1, Line 75

    Are your backups native SQL backups or are they using BizTalk to backup?

    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.

    January 27, 2012 at 9:33 am

    #1439473

  • RE: Msg 7412, Sev 16, State 1, Line 75

    CharlieL (1/27/2012)

    The backup that first failed was at midnight, when the server is quiet, so I don't think it's down to the server being busy.

    Wait. You're using a Linked 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.

    January 27, 2012 at 9:18 am

    #1439459

  • RE: Effect of Clustered Index Updates

    patrickmcginnis59 (1/27/2012)

    Brandie Tarvin (1/27/2012)

    If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs 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.

    January 27, 2012 at 7:45 am

    #1439372

Viewing 15 posts - 4,756 through 4,770 (of 9,715 total)