Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sysprocesses Expand / Collapse
Author
Message
Posted Monday, October 21, 2002 2:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 22, 2002 12:00 AM
Points: 2, Visits: 1
I need to set the column program_name on the table sysprocesses using a SQL
command to send via ODBC connection, who knows what command I have to send?
Thanks.
Pier Gaetano Novara





Post #7563
Posted Monday, October 21, 2002 4:07 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 13, 2014 10:40 AM
Points: 573, Visits: 107
You can set this in the connection string use the APP keyword i.e

"DRIVER=MSDQSQL;SERVER=(local);UID=sa;PWD=;APP=My application"

Have a look at SQLDriverConnect in BOL

Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088



Simon Sabin
SQL Server MVP

http://sqlblogcasts.com/blogs/simons
Post #44238
Posted Monday, October 21, 2002 7:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 22, 2002 12:00 AM
Points: 2, Visits: 1
I don't want set in during the connection but afterward.
Thanks
Pier Gaetano Novara




Post #44239
Posted Monday, October 21, 2002 2:45 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 13, 2014 10:40 AM
Points: 573, Visits: 107
Not possible all the parameters are fixed.

Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088



Simon Sabin
SQL Server MVP

http://sqlblogcasts.com/blogs/simons
Post #44240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse