January 30, 2003 at 12:17 pm
Hi,
I'm running a trace on sql server 2000 and it returns the following information (amongst other)...
ntusername: whatever
loginname: sa
hostname: whatever
applicationname: Microsoft(R) Windows (R) 2000 Operating System
I want to change the password for the sa account on sql server but don't want to do this until I know what the applicationname above is.
Do you have any idea, all comments appreciated.
Thanks
sho
Edited by - shoayb on 01/30/2003 12:19:51 PM
January 30, 2003 at 12:52 pm
You can get the current SPID by query @@SPID and then you can find the application name by querying against sysprocesses in the master database. For instance:
SELECT program_name
FROM sysprocesses
WHERE spid = @@SPID
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply