Forum Replies Created

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

  • 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

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

    dudekula.kareemulla, Lowell said more plainly what I was thinking but didn't say.

    Lowell (5/19/2016)

    i think synonyms don't magically solve cross database chaining.

    Synonym or no synonym, you have to give the users...

    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:22 am

    #1880161

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

    kreuzer (5/19/2016)

    have you checked with your domain admins, if there is a valid SPN in the domain for you SQL-Server?

    Or worse, the server could be using a previous registered SPN....

    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:17 am

    #1880157

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

    Pretty much the same way you grant permissions to objects in a database.

    GRANT <permission> ON <synonym> TO <login>

    But why would you need synonyms on the same server? It's easy enough...

    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:12 am

    #1880153

  • RE: SQL Server 2012: Server permissions deleted overnight

    Lord Lucan (5/19/2016)

    Hi,

    Thanks; where/how could I access the logs?

    This is the 2008 link, but it should still help. Though given what permissions you listed above and the fact that...

    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:09 am

    #1880152

  • RE: Are the posted questions getting worse?

    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 Learning with R) 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.

    May 19, 2016 at 4:32 am

    #1880131

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