Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 9,731 total)

  • RE: Are the posted questions getting worse?

    So today I learned that it is possible to create an infinite loop in SQL. With a CURSOR no less.

    What an interesting day it's been already. @=)

    Apparently FETCH NEXT 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.

  • RE: Are the posted questions getting worse?

    djj (5/23/2016)


    Talk about needing for a crystal ball

    http://forums.sqlteam.com/t/hi-can-some-one-help-me/6447

    I've asked this question many times, but people keep saying there's no help for me... :w00t:

    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.

  • RE: Remote Connection problem on Standalone instance

    gfoxxy93 (5/23/2016)


    Few things on here worth triple checking

    Please reread my second 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.

  • RE: SQL Server Service won't Start After adding server to domain

    crazy_new (5/23/2016)


    I ran the repair and it did not fix the issue. The Database Engine Services, Data Quality Services, Full-Text and Semantic Extractions for Search and the SQL 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.

  • RE: SQL Server Service won't Start After adding server to domain

    gfoxxy93 (5/23/2016)


    Good post covering failed startup scenarios by msdn

    SQL Server Service Not starting[/url]

    Looks like you can change a few regusty values to repoint data files whilst SQL server engine 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.

  • RE: Remote Connection problem on Standalone instance

    gfoxxy93 (5/23/2016)


    Do a remote port scan is 1433 open?

    Yes.

    EDIT: If you look at my second post, that pretty much proves 1433 is open. But the coworker is working on something...

    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.

  • RE: Remote Connection problem on Standalone instance

    Hrrrmmmm. This is annoying. If I go into TCP/IP on the server, click over to the IP Addresses tab, scroll down to IPAll and enter 1433 into the TCP Port...

    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.

  • RE: Are the posted questions getting worse?

    ThomasRushton (5/23/2016)


    Been a bit quiet here over the weekend - was there an outage, or did everyone else suddenly have an attack of Real Life?

    Spent the weekend pulling vines off...

    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.

  • RE: log file growth

    How often are you backing up your database?

    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.

  • RE: Linked Server issue

    I have to agree with gfoxxy93 on this. This is not a SQL specific error.

    Think of it this way. Have you ever run into a metadata / data type conversion...

    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.

  • RE: SQL Server Service won't Start After adding server to domain

    crazy_new (5/22/2016)


    If I repair it using the setup, which folder do I point it to as the installation media folder? Every folder I choose this thing has a problem with....

    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.

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/20/2016)


    Ed Wagner (5/20/2016)


    Brandie Tarvin (5/20/2016)


    So...

    Installing our new prod servers. Was doing swimmingly until I got to the Add Node to Cluster. Got to the account...

    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.

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/20/2016)


    Brandie Tarvin (5/20/2016)


    So...

    Installing our new prod servers. Was doing swimmingly until I got to the Add Node to Cluster. Got to the account / password page of 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.

  • RE: Are the posted questions getting worse?

    So...

    Installing our new prod servers. Was doing swimmingly until I got to the Add Node to Cluster. Got to the account / password page of the install and forgot 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.

  • RE: SQL Server Service won't Start After adding server to domain

    Have you tried repairing the install?

    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.

Viewing 15 posts - 1,711 through 1,725 (of 9,731 total)