Hello friends
i want to select nt window login (System login) name in sql server 2000.
Like If i am login with vijay name then selected name should be vijay
Regards
Vijay Singh
Last edited by vijay2006; Apr 22nd, 2008 at 10:37 AM.
What kind of authentication are you using now?
Please use [Code]your code goes in here[/Code] tags when posting code.
When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
Before posting your question, did you look here?
Got a question on Linux? Visit our Linux sister site.
I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.
Creating A Wizard In VB.NET
Paging A Recordset
What is wrong with using On Error Resume Next
Good Article: Language Enhancements In Visual Basic 2010
Upgrading VB6 Code To VB.NET
Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked
Have you tried the environment variable System_User...
Select System_User
Try this select statement in a query window - see what you get. Sometimes it comes back with a DOMAIN attached to the front of the value.
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
Some Informative Links: [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
[ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]
MS MVP 2006, 2007, 2008
Posting Permissions
Reply With Quote