Forum Replies Created

Viewing 15 posts - 7,486 through 7,500 (of 9,720 total)

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    Okay, It looks like it's publication type. Hover your mouse over the publication in SSMS (under Replication -> Local Publications) and Publication Type is fourth down.

    I'm walking through this myself....

    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.

    September 17, 2010 at 4:36 pm

    #1223376

  • RE: D: drive is full and transaction log is full

    GilaMonster (9/17/2010)

    hallhome (9/17/2010)

    Update: I took Gail's advice and moved tempdb to another drive and recycled SQL Server. The database in question was able to recover and I was...

    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.

    September 17, 2010 at 12:07 pm

    #1223252

  • RE: How Do I resolve SSMS 'is busy" issue

    Now that's an interesting fix... I'll have to remember it and see if it works the next time I come across that issue.

    I don't use the Designer much though, so...

    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.

    September 17, 2010 at 11:55 am

    #1223244

  • RE: Page Splitting

    sqlbuddy123 (9/17/2010)

    Suppose that if a page is 100% full and if a new record record needs to be inserted somewhere in-between the records on that page, then SQL Server will...

    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.

    September 17, 2010 at 11:54 am

    #1223241

  • RE: Are the posted questions getting worse?

    Hey, all. It's been forever since I've done replication. I'm trying to help this guy out here. While I'm looking stuff up, would someone else mind sticking their nose into...

    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.

    September 17, 2010 at 11:46 am

    #1223234

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    Mark,

    Making assumptions with SQL Server is the quickest way of losing a database. Be careful about that.

    Did you set up replication yourself or are you working with someone else's setup?...

    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.

    September 17, 2010 at 11:44 am

    #1223233

  • RE: Query takes too long to run

    steveb. (9/17/2010)

    Chris Morris-439714 (9/17/2010)

    The table placement may well be the source of your performance problem.

    I have heard this before, that the order of the table placement in the join...

    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.

    September 17, 2010 at 11:37 am

    #1223226

  • RE: Today's Random Word!

    Bread Pudding with Jack Daniel sauce...

    It's more than one word, but it's what I'm eating right now. Nom!

    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.

    September 17, 2010 at 11:33 am

    #1223224

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/17/2010)

    Of course, people are easily confused because DBA's can also be used to show possession (and no, I'm not talking about demonic possession although a lot of DBA's...

    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.

    September 17, 2010 at 11:30 am

    #1223223

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/17/2010)

    CirquedeSQLeil (9/17/2010)

    But what does the null represent?

    Mean editor?

    Nope.

    Null = Clueless

    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.

    September 17, 2010 at 11:27 am

    #1223220

  • RE: Page Splitting

    Give us the exact wording of your error message.

    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.

    September 17, 2010 at 8:52 am

    #1223079

  • RE: Query takes too long to run

    Also, a row count would be nice. If you've got a wide, long table, that could take a long time no matter how well optimized your query 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.

    September 17, 2010 at 8:45 am

    #1223070

  • RE: collation issue

    I believe, in some instances, you can make changes in the GUI that T-SQL does not enable you to make. You can try using the GUI, but don't be surprised...

    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.

    September 17, 2010 at 8:43 am

    #1223066

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    It's been a while since I've played with replication, but I'll give this a shot.

    How is your replication set up? Do you have Updating Subscribers? If not, chances are your...

    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.

    September 17, 2010 at 8:41 am

    #1223062

  • RE: How Do I resolve SSMS 'is busy" issue

    What service pack are you running?

    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.

    September 17, 2010 at 8:28 am

    #1223045

Viewing 15 posts - 7,486 through 7,500 (of 9,720 total)