Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/18/2016)

    Tell me, is this (third post) just fixing the symptom, not the problem?

    That's an awful lot of work just to avoid transaction log backups.

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

    #1880130

  • RE: Enormous Transaction Log!

    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 a table and then...

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

    #1880129

  • RE: Are the posted questions getting worse?

    jasona.work (5/18/2016)

    GENUINE AMISH SERVERS

    Only the best servers hand-built by talented Amish craftsman from the latest (to them) DEC Alpha processors! Each server loaded with a whopping 16MB of 72-pin...

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

    #1880128

  • RE: how to connect to SQL Server 2014

    smw147 (5/19/2016)

    Have you tried enabling the UDP ports 1433 (default instance) and 1434 (names instances) in the firewall on the server (incoming & outgoing)? I have found this helps...

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

    #1880127

  • RE: how to connect to SQL Server 2014

    dukanif (5/18/2016)

    can anybody see my PC via teamviewre ? to check all of it .

    If your company can't hire someone local, I'm sure one of us would be willing 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 18, 2016 at 12:09 pm

    #1879953

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