July 28, 2011 at 1:14 am
Is there anyway to get the - SQL Login last used in SQL Server 2000 on a particular database using T-SQL Scripts.
Auditing is enable.
Cheers,
- Win.
" Have a great day "
July 28, 2011 at 6:24 am
can anyone post any ideas on this ?
can we track in any way ??? Is this possible in SQL Server 2000 ?
Cheers,
- Win.
" Have a great day "
July 28, 2011 at 6:25 am
Where and how do you audit?
Where are the log files?
July 28, 2011 at 6:43 am
SQL Server Auditng is enabled on this instance.
Am I posting unclear question ?
Cheers,
- Win.
" Have a great day "
July 28, 2011 at 6:49 am
Not really but I for 1 has never done this, at all (that way). And I don't have a sql 2000 instance to play with.
Moreoever this is a sql 2K5 forum (we do have a 2000 & less forum)
Is this C2 auditing?
If so the files should be in the sql server folders. You could just theorically open those and dump into a temp table to proces them.
Might be simpler to just open them by hand.
It's quite possible that EM has something in the GUI to do this but I don't know... and can't search / test.
July 29, 2011 at 1:03 am
I am sorry, I should have been more clearer...
But we need this to be implemented in 2000 & 2005 servers as well.
Not C2 auditing. Simply enable server properties security for Login - failed & success audits.
Other than that they are not allowing me to change any settings...
Cheers,
- Win.
" Have a great day "
July 29, 2011 at 2:58 am
- Win. (7/29/2011)
I am sorry, I should have been more clearer...But we need this to be implemented in 2000 & 2005 servers as well.
Not C2 auditing. Simply enable server properties security for Login - failed & success audits.
Other than that they are not allowing me to change any settings...
Have you checked the sql logs?
It's either or the logs folder in sql server...
July 29, 2011 at 4:10 am
Log folder doesnt shows info clearly.
Here we have enough preveliges... Donno why they need only SQL Script for this.
I explained like SQL Server 2000 is not the much smart to provide every info and logs everything, what we need. We can try in SQL 2005 , but not in 2000. Am I wrong ????
Please correct me. Can anyone help me in getting the details.
Cheers,
- Win.
" Have a great day "
July 29, 2011 at 5:35 am
I found this on google, does it help?
July 29, 2011 at 6:20 am
Thanks much for your time.
Sorry to say, but I was looking for SQL query to store data into a temp table. So that client can query that and test or check from their end. Donno why they are specific about this.
Cheers,
- Win.
" Have a great day "
July 29, 2011 at 6:25 am
Send me the audit file and I'll see what I can do.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply