Forum Replies Created

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

  • RE: Load Files in date order

    Brandie Tarvin (4/10/2014)


    Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.

    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: Load Files in date order

    Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.

    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: Execute Permission Problem on Stored Procedure

    Chris Wooding (4/1/2014)


    Granting execute on the schema has worked in other databases. Is it because this user is part of domain users and therefore only using those permissions rather than...

    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: Execute Permission Problem on Stored Procedure

    Odd question. Is there perhaps a database trigger that is rolling back any attempts at A) Executing this proc, or B) deleting data from this (or all) tables?

    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: Execute Permission Problem on Stored Procedure

    I think Lowell's on the right track here. It seems the jumping around has a lot to do with your issues.

    If you are able to impersonate the login using this...

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

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

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

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

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

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

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

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

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

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

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