Post reply

Process Monitor Program_Name question

  • January 10, 2014 at 5:40 am

    #284265

    I am updating our Invalid Login code and noticed several different references to SQL in the sysprocesses table. I'm trying to understand the difference between the three (as in what it means / what activity is causing this to pop up as the program name).

    Here's what I'm seeing:

    Microsoft SQL Server Management Studio – Query (This one is pretty obvious, someone is logged into a SSMS query window)

    Microsoft SQL Server Management Studio

    Microsoft SQL Server

    What type of activity causes the later two to pop up, though? What is the difference between the two?

    Does anyone know?

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

    #1679113

    Brandie

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

    John

  • January 10, 2014 at 6:02 am

    #1679121

    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 really SSMS running the queries.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 10, 2014 at 6:09 am

    #1679124

    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 really SSMS running the queries.

    Could you post the link?

    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

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

    #1679131

    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 Import / Export wizard both trigged the second one. But it's also trigged by something else which we couldn't track down. I'm hoping someone else has more input on this one.

    As far as the Linked Server for the third one... That makes sense given what I'm seeing this morning.

    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 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply