Forum Replies Created

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

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

    May 23, 2016 at 7:04 am

    #1880736

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

    May 23, 2016 at 6:36 am

    #1880717

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

    May 23, 2016 at 6:29 am

    #1880716

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

    May 23, 2016 at 6:27 am

    #1880714

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

    May 23, 2016 at 5:35 am

    #1880705

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

    May 20, 2016 at 10:59 am

    #1880549

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

    May 20, 2016 at 6:08 am

    #1880467

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

    May 20, 2016 at 5:27 am

    #1880454

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

    May 20, 2016 at 5:15 am

    #1880452

  • RE: MSDB..BackupSet table and weird Server_name data

    shahm10 (5/19/2016)

    Backupset table in Dev server will also contain information about backups that were taken on other servers and restored on Dev server.

    Ah. That makes sense.

    It also makes my job...

    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.

    May 19, 2016 at 11:31 am

    #1880318

  • RE: How can i give Grant permission for synonyms from another database in same server.

    You could grant those individual permissions to an account, but it is usually considered far easier to maintain such things by creating a role and then adding the users or...

    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.

    May 19, 2016 at 8:59 am

    #1880273

  • RE: SQL Server 2012: Server permissions deleted overnight

    GilaMonster (5/19/2016)

    Brandie Tarvin (5/19/2016)

    The alternate explanation for this behavior is some sort of security sweep that removes individual permissions.

    And

    along with any tables, views, stored procs etc that I have created.

    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.

    May 19, 2016 at 6:37 am

    #1880176

  • RE: Enormous Transaction Log!

    Ken McKelvey (5/19/2016)

    Brandie Tarvin (5/19/2016)

    Ken McKelvey (5/18/2016)

    tcalloway (5/17/2016)

    I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, 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.

    May 19, 2016 at 6:34 am

    #1880168

  • RE: Enormous Transaction Log!

    I just noticed this line...

    tcalloway (5/17/2016)

    How can I write this procedure differently to prevent so many transaction entries? Or, how can I consistently and successfully shrink my enormous transaction...

    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.

    May 19, 2016 at 6:30 am

    #1880167

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (5/19/2016)

    Brandie Tarvin (5/19/2016)

    GilaMonster (5/19/2016)

    Lynn Pettis (5/18/2016)

    Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016.

    Oooh. Am very tempted to grab both the R and the Data bundles.

    The free book yesterday (Machine...

    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.

    May 19, 2016 at 6:23 am

    #1880162

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