Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chrissilverton
Starting Member
1 Post |
 Posted - 2005-05-24 : 11:11:48
|
Hi...I currently have a MS SQL database which ebales the user to pull out data relevant to there username, but they have to manually input there username. What id Really like to do is for the SQL to recognise the username theyve loggged on to windows with then pull the relevant data based on that???ANyone point me in the right directionThanks Chris  |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-24 : 11:24:07
|
| If you are using integrated security then system_user.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Pull data out of a table based on Windows Logon