Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 9,715 total)

  • RE: SQL Server Agent jobs running under SA

    wolfkillj (6/20/2013)

    Well, I have to say I'm stumped.

    Just to clarify, I understood from what you've posted that the SQL Agent service startup account is a Windows domain account that is...

    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.

    June 21, 2013 at 5:54 am

    #1626290

  • RE: SQL Server Agent jobs running under SA

    jasona.work (6/20/2013)

    OK, I don't know if this might help, but I found a similar issue elsewhere:

    Link to topic

    ...

    (PS, I do see on one of my servers in sysprocesses an NTLogin...

    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.

    June 21, 2013 at 5:48 am

    #1626289

  • RE: Possible article on persisting last SSRS parameter choices

    NP. Look forward to seeing the article.

    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.

    June 21, 2013 at 5:41 am

    #1626284

  • RE: SQL Server Agent jobs running under SA

    foxxo (6/21/2013)

    I'd like to question if it is actually running as sa.

    Is it the same if you use sys.dm_exec_sessions rather than the old sysprocesses?

    Also can you write the current security...

    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.

    June 21, 2013 at 4:43 am

    #1626272

  • RE: Possible article on persisting last SSRS parameter choices

    Check out this link: http://www.sqlservercentral.com/articles/SQLServerCentral/69267/%5B/url%5D

    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.

    June 21, 2013 at 4:22 am

    #1626262

  • RE: Are the posted questions getting worse?

    wolfkillj (6/20/2013)

    jcrawf02 (6/20/2013)

    Steve Jones - SSC Editor (6/20/2013)

    wolfkillj (6/20/2013)

    ...In the absence of a feature that would block or hide posts from a particular person, the only suggestion I have is...

    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.

    June 21, 2013 at 4:15 am

    #1626260

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/20/2013)

    Brandie Tarvin (6/20/2013)

    I need some advice, please.

    One of my thread questions has a poster on it who spent all day yesterday on Twitter telling me my problem is impossible...

    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.

    June 20, 2013 at 11:36 am

    #1626061

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/20/2013)

    Brandie Tarvin (6/20/2013)

    I need some advice, please.

    One of my thread questions has a poster on it who spent all day yesterday on Twitter telling me my problem is...

    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.

    June 20, 2013 at 10:51 am

    #1626040

  • RE: Are the posted questions getting worse?

    I need some advice, please.

    One of my thread questions has a poster on it who spent all day yesterday on Twitter telling me my problem is impossible (literally, he said...

    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.

    June 20, 2013 at 10:39 am

    #1626032

  • RE: Partitioning in SQL Server 2008

    SQLRNNR (6/20/2013)

    You also now know the procedures that are executing - you can look to tune those procedures.

    As for the code coming from Access or across the linked server, you...

    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.

    June 20, 2013 at 10:25 am

    #1626021

  • RE: SQL Server Agent jobs running under SA

    Robert Davis (6/20/2013)

    msdb is always owned by the sa account.

    Not true, actually.

    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.

    June 20, 2013 at 9:38 am

    #1625989

  • RE: SQL Server Agent jobs running under SA

    I don't believe it's on a DMZ, but that's something I'd need to ask the server team.

    EDIT: I'm pretty sure it's not as our corporate security guidelines are specifically against...

    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.

    June 20, 2013 at 7:11 am

    #1625891

  • RE: Are the posted questions getting worse?

    So this morning I've been frantically searching the internet on articles to help clarify a problem I'm experiencing, and what do I see?

    Gail Shaw's name all over the place.

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

    June 20, 2013 at 6:49 am

    #1625876

  • RE: SQL Server Agent jobs running under SA

    wolfkillj (6/19/2013)

    What does your job do (i.e., what kinds of steps - T-SQL commands, execute SSIS packages, etc.)? Do all steps happen on the same server\instance? What is the service...

    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.

    June 20, 2013 at 6:31 am

    #1625859

  • RE: Are the posted questions getting worse?

    Thanks, Jason. I appreciate the info.

    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.

    June 19, 2013 at 9:35 am

    #1625545

Viewing 15 posts - 3,526 through 3,540 (of 9,715 total)