The T-SQL CURRENT_USER function is probably what you're looking for.
Normally auditing is done on the server, so you may want to consider
that approach.
--Mary
On Wed, 26 Jul 2006 11:34:01 -0700, nycdon
<nycdon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I'm trying to grab the SQL server login name for auditting.
thanks,
Don
"Mary Chipman [MSFT]" wrote:
What exactly are you trying to do? Perhaps if you provide more detail
someone can advise you. If you are asking if you can retrieve a login
and password from SQL Server, then the answer is no.
--Mary
On Tue, 25 Jul 2006 09:22:02 -0700, nycdon
<nycdon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
is possible to get the sql server login thru vba in Access 2003?
thanks!
Re: Full text setup questions ... this is SQL Server T-SQL... To create the catalog in the IS MMC go to ... (microsoft.public.sqlserver.fulltext)
Re: Upsize to SQL Server ... I feel that with such a model, it will not be easy for me to use the power of T-SQL; I feel uneasy about interjecting an additional connection layer between the app and the db; I feel uneasy about the many posts here about problems associated with this model. ... I use T-SQL when it gives me some positive advantage over Access, enough of an advantage to justify the extra work. ... I can either use T-SQL on the server to create a view or I can write a pass-through query in Access and send raw SQL up to the server. ... (comp.databases.ms-access)
Re: db restore + transaktionsprotokoll ... >> angenommen der server geht kaputt. ... >> nun wie kann ich das via enterprise manager wiederherstellen?... > verwende T-SQL.... Dann kannst Du als Rücksicherung from... (microsoft.public.de.sqlserver)
Re: Upgrade from SQL Server 7.0 to 2000 ... Server 7.0 to 2000 from T-SQL commands, statements, syntax etc ...standpoint....Microsoft SQL Server 2000". ... but i am looking for changes from SQL Server... (microsoft.public.sqlserver)
Re: Custom Row Functions: Access vs. SQL Server ... When compared with other "time" issues like the speed of data over the wire, what other tasks the server might be performing when you ask it to call the function etc, I think I am not going to worry about it, barring Steve coming up with something I have overlooked. ... Is T-SQL really that slow? ... performance is great, but Access works slightly better with the MS SQL Server back-end, and you have to make sure your ODBC settings are just right, for PostgreSQL to work correctly with Access on the front-end. ... (comp.databases.ms-access)
