----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: DheerajKReddy Message 1 in Discussion Hi, I am working on a VB.NET application. Database is SQL Server 2000. I have a table where one of the column's default value should be the windows login user name. This table is populated via a trigger when a delete happens in the related table. i.e basically I am logging all the "Deletes" into another table with details like who deleted them and when was it deleted. In the web.config my setting is <add key="CONNECTION_STRING" value="Server=localhost;Database=dat;UId=us; Password=pt; pooling=false" /> If I use SUSER_SNAME(), I am getting the value "us" - the database user. But I want the Windows Login Name. How will I get this? Please help Regards Dheeraj ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
