Hi all,
In our win2k3 event viewer there are hundreds of failed logon attempts
for our SQL Server. Unfortunately, this log doesn't supply any
connection specific information which is what we need. Are there any
other logs that MSSQL 2000 keeps on it's own? I want to keep a record
of these attempts just in case something does happen we maybe will have
something to go on. Thanks!
--
Regards,
TroyHi,
It will be there in SQL Server Error logs as well. The location of the files
will be in \Program files\Microsoft sql server\server name\Log directory.
or you can execute XP_READERRORLOG from query analyzer .
Thanks
Hari
MCDBA
"Troy" <poster@.designguide.com> wrote in message
news:MPG.1a9d757e7936be5a98968e@.msnews.microsoft.com...
> Hi all,
> In our win2k3 event viewer there are hundreds of failed logon attempts
> for our SQL Server. Unfortunately, this log doesn't supply any
> connection specific information which is what we need. Are there any
> other logs that MSSQL 2000 keeps on it's own? I want to keep a record
> of these attempts just in case something does happen we maybe will have
> something to go on. Thanks!
> --
> --
> Regards,
> Troy
Showing posts with label unfortunately. Show all posts
Showing posts with label unfortunately. Show all posts
Thursday, February 16, 2012
Saturday, February 11, 2012
Access equivalent to @@identity
Hi,
I am trying to get the id of the record that was just inserted into the table. Unfortunately, I have to use Microsoft Access and @.@.identity will not work. Is there some other command that performs the same operation? I am hesitant to use MAX().
Your comments are greatly appreciated.
Thanks.Sorry, I didn't see a forum for Microsoft Access. Maybe this topic should be moved to "Other"??|||4GuysFromRolla.com : ASP FAQS : Databases, General
How do I get the record number of a just added record, using an Access database table? by Bill Wilkinson - 11/3/2000
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
ADO FAQ - Q9) How do I get the AutoNumber (or Identity) for a newly inserted record?
http://www.able-consulting.com/ADO_Faq.htm#Q9
INFO: Identity and Auto-Increment Fields in ADO 2.1 and Beyond
http://support.microsoft.com/support/kb/articles/q233/2/99.ASP
INFO: Identity (AutoIncrement) Columns in ADO or RDS
http://support.microsoft.com/support/kb/articles/q195/9/10.asp
User Tips: Getting the ID of the Just Inserted Database Record by Dan H. - 12/26/2000
http://www.4guysfromrolla.com/webtech/tips/t122600-1.shtml
I am trying to get the id of the record that was just inserted into the table. Unfortunately, I have to use Microsoft Access and @.@.identity will not work. Is there some other command that performs the same operation? I am hesitant to use MAX().
Your comments are greatly appreciated.
Thanks.Sorry, I didn't see a forum for Microsoft Access. Maybe this topic should be moved to "Other"??|||4GuysFromRolla.com : ASP FAQS : Databases, General
How do I get the record number of a just added record, using an Access database table? by Bill Wilkinson - 11/3/2000
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
ADO FAQ - Q9) How do I get the AutoNumber (or Identity) for a newly inserted record?
http://www.able-consulting.com/ADO_Faq.htm#Q9
INFO: Identity and Auto-Increment Fields in ADO 2.1 and Beyond
http://support.microsoft.com/support/kb/articles/q233/2/99.ASP
INFO: Identity (AutoIncrement) Columns in ADO or RDS
http://support.microsoft.com/support/kb/articles/q195/9/10.asp
User Tips: Getting the ID of the Just Inserted Database Record by Dan H. - 12/26/2000
http://www.4guysfromrolla.com/webtech/tips/t122600-1.shtml
Subscribe to:
Posts (Atom)