Post reply

hostname and program_name not displayed in Sysprocesses table

  • April 22, 2010 at 12:37 am

    #146597

    Hi

    We are using OMNIS 7.3 software to connect sql server 2k. But my problem is master..sysprocesses table not showing hostname and program_name (but its showing nt_domain and nt_username correctly)

    Anyone kindly let me know this is a bug in SQL Server 2000?

    Regards

    Nagarajan S

  • April 22, 2010 at 2:23 am

    #1155909

    It must be some missing property in the connection string. What does product documentation say?

    -- Gianluca Sartori

  • April 22, 2010 at 4:20 am

    #1155957

    As already stated above : probably these parameters haven't been provided by the connection.

    Some applications use a config or ini file which provide the connection string.

    e.g.

    add key="SQLServerConnectionString" value="Data Source=TheDevServer\Instance01;Initial Catalog=MyDatabase;Integrated Security=SSPI;"

    In this example it is just a regular connection string, so you can modify it with the extra info

    add key="SQLServerConnectionString" value="Data Source=TheDevServer\Instance01;Initial Catalog=MyDatabase;Integrated Security=SSPI;Application Name=This Is my Application Version 0.0.88;"

    Test it before putting it in prod !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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