Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 9,722 total)

  • RE: need to copy 100 tables from 1 server/db to another server/db..

    The easiest way?

    I'd say restore the database to the other server and delete the unneeded tables. Which runs into problems if you delete FK related tables in the wrong...

    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.

    February 28, 2012 at 8:00 am

    #1452611

  • RE: Adding a fresh table to replication subscription which is not from publisher

    Not that it should break replication unless you're connecting the new table to an existing "article" table, but ...

    Which side of replication are you intending to add the table?

    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.

    February 28, 2012 at 7:56 am

    #1452609

  • RE: Need answers for interview questions...

    Koen Verbeeck (2/28/2012)

    GilaMonster (2/28/2012)

    satishm94 (2/28/2012)

    4)What is proxy server? Why do u need it?

    No such thing as a proxy server in SQL Server

    Maybe proxy accounts in SQL Agent?

    No. Based on 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.

    February 28, 2012 at 7:52 am

    #1452608

  • RE: Are the posted questions getting worse?

    LutzM (2/27/2012)

    Koen Verbeeck (2/27/2012)

    ..

    This one obviously is (on another site):

    interview questions

    ...

    I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, 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.

    February 27, 2012 at 11:06 am

    #1452198

  • RE: 2005 Setup Support Files Will Not Install

    Thank you for posting that.

    Anti-Virus software kills things every time. I have seen more problems caused by that... Sorry I didn't think about it in your situation.

    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.

    February 27, 2012 at 7:01 am

    #1452046

  • RE: Query runs much slower when connect to SQL Server locally.

    Which node has the newer network driver? The slow one or the fast one?

    And what are your network card configurations for both servers?

    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.

    February 27, 2012 at 6:16 am

    #1452022

  • RE: Are the posted questions getting worse?

    Congrats on the new job, Lynn. I love Colorado Springs. If I get a chance to move to Colorado, that's the city I want to live in.

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

    February 27, 2012 at 5:22 am

    #1451994

  • RE: Are the posted questions getting worse?

    LutzM (2/25/2012)

    Jeff Moden (2/25/2012)

    Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.

    http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx

    <shudder>

    It becomes rather scary when seen 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.

    February 27, 2012 at 5:19 am

    #1451992

  • RE: How do I return only entries with multiple categories in a junction table?

    CELKO (2/24/2012)

    This is an environment that I INHERITED. I DID NOT BUILD THIS. This is based on a production environment, and I have limited leeway as 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.

    February 27, 2012 at 5:14 am

    #1451990

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    I've never actually run into the problem that Gail describes. I was just throwing out a W.A.G. as to what she could have meant. I'm sure she'll reply with more...

    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.

    February 24, 2012 at 12:40 pm

    #1451560

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    patrickmcginnis59 (2/24/2012)

    When thinking this through, slowness of the system in my mind brings things closer together instead of keeping things spread apart, as queries lasting longer by inference brings their...

    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.

    February 24, 2012 at 11:47 am

    #1451534

  • RE: Today's Random Word!

    crookj (2/24/2012)

    WOTD - Hubbub

    Noise

    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.

    February 24, 2012 at 11:29 am

    #1451530

  • RE: How to prevent a sore throat after hours of presenting ppt ?

    ALZDBA (2/24/2012)

    Here's another list of tips 40 QUICK TIPS FOR SPEAKERS[/url] which do make sense too.

    I love that link. Thank you, Johan.

    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.

    February 24, 2012 at 4:30 am

    #1451306

  • RE: Are the posted questions getting worse?

    Is anyone else having trouble getting to topics they've responded to in the past couple of days?

    I just tried to check a couple of topics via the notification link 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.

    February 24, 2012 at 4:29 am

    #1451305

  • RE: 2005 Setup Support Files Will Not Install

    You are quite welcome. I will warn you though, that I'm only 90% certain of the registry issues. So if you still have problems after cleaning it up, let us...

    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.

    February 23, 2012 at 12:01 pm

    #1451071

Viewing 15 posts - 4,666 through 4,680 (of 9,722 total)