Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 9,715 total)

  • RE: Execute Permission Problem on Stored Procedure

    Is there any other information in the error you're seeing?

    I've run into this issue when the procedure is doing activity that requires higher level permissions (such as Truncate Table), but...

    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.

    March 31, 2014 at 6:05 am

    #1701552

  • RE: GUI Database Properties - Size & Space Available

    I started off using 1024, but the math still doesn't work out correctly for what I'm seeing. (FYI: I got the 128 from a couple of different blog posts. Here'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.

    February 11, 2014 at 7:44 am

    #1687903

  • RE: Compressed backup not restoring

    Steve Jones - SSC Editor (1/22/2014)

    Did you check properties on all subfolders or use some other method?

    The subfolder properties don't tell me if compression is on for them. I experimented...

    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.

    January 22, 2014 at 9:17 am

    #1682473

  • RE: Compressed backup not restoring

    Ah. I think it didn't uncompress the subfolders. The root allows me to restore the database files there just fine.

    So, nevermind. Thanks for reading.

    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.

    January 22, 2014 at 8:00 am

    #1682420

  • RE: Activity Monitor Waiting Resource question

    Thanks.

    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.

    January 20, 2014 at 8:25 am

    #1681581

  • RE: Activity Monitor Waiting Resource question

    Well, it's MS Access actually. We have linked tables and macros pulling data but we're about to retire a server and move to a new one. So the process works...

    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.

    January 16, 2014 at 12:18 pm

    #1680817

  • RE: subscription owner change

    Given that the service account should be in sysusers, and that page you referenced updates based on userID, I would say that yes, you can do exactly what you're thinking...

    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.

    January 16, 2014 at 4:48 am

    #1680592

  • RE: Process Monitor Program_Name question

    John Mitchell-245523 (1/10/2014)

    Brandie

    Could the second one be from Object Explorer or similar? I think you get the third for linked server queries.

    John

    I did notice that Object Explorer and 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.

    January 10, 2014 at 6:28 am

    #1679131

  • RE: Process Monitor Program_Name question

    GAH. Dup 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.

    January 10, 2014 at 6:24 am

    #1679128

  • RE: Process Monitor Program_Name question

    Lowell (1/10/2014)

    I believe there was another recent thread that said scheduled jobs that are executing use "Microsoft SQL Server Management Studio", i believe, which was very misleading, since it's not...

    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.

    January 10, 2014 at 6:09 am

    #1679124

  • RE: how to deal with growing tempdb data and log files

    To add to what Gail said, the ONLY 2 reasons you should consider shrinking TempDB would be:

    1) A runaway query that has caused TempDB to grow exponentially beyond the usual...

    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.

    January 10, 2014 at 5:46 am

    #1679112

  • RE: Restoring from broken backup chain

    Differential base... And so I learn a new term (that I arguably should have know before this).

    Thank you again, Gail. You are a star.

    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.

    December 19, 2013 at 11:26 am

    #1674936

  • RE: Restoring from broken backup chain

    GilaMonster (12/19/2013)

    Full backups do not break the log chain. Differential backups do not break the log chain

    I know that. The chain that was broken was between the differential and 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.

    December 19, 2013 at 10:58 am

    #1674932

  • RE: SQLServerCentral apologizes and you can win a book

    jk_in_San_Diego (12/5/2013)

    Once upon a time, in the dark ages of printed textbooks and such, plagarism was not only frowned upon, it was cause for immediate dismissal or expulsion from university.

    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.

    December 11, 2013 at 5:32 am

    #1672582

  • RE: SQLServerCentral apologizes and you can win a book

    Samuel Vella (12/5/2013)

    Brandie Tarvin (12/5/2013)

    One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement....

    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.

    December 5, 2013 at 7:00 am

    #1671063

Viewing 15 posts - 3,286 through 3,300 (of 9,715 total)