Post reply

not getting program_name in sys.sysprocesses table

  • June 10, 2009 at 5:48 am

    #155811

    Hi my name is Ravish Dhingra.

    I am working on .net project named TDS. its has a exe with the same name "TDS". When I start a application it makes connection with SQL. and when I check the Program_name in sys.sysprocesses table I get pogram_name as a ".Net Sql data Provider". However it should be "TDS" as my application name is TDS. I have also checked the same thing in another vb application in that case it is showing the name of exe.

    Please help me out.

    Waiting for reply's

  • June 10, 2009 at 6:43 am

    #1007316

    I am still waiting fot the reply. If any body could not understand the situation. I'll explain to that person.

  • June 10, 2009 at 6:57 am

    #1007334

    Ravish,

    I think you should put it in the connection string

    http://www.sqlservercentral.com/articles/Administration/worstpracticebadconnectionstringsandbadinfoinsyspr/802/

    (I am not sure this is what you are looking for)

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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