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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 finding failing inserts

Author  Topic 

rohans
Posting Yak Master

194 Posts

Posted - 2010-12-06 : 20:04:10
Hi:
Where could I look to get a log of all my failed inserts. I am trying to find this for my ASP application.

Thank you

All help appreciated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-06 : 23:45:00
You would need to add this logging functionality to your ASP application.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rohans
Posting Yak Master

194 Posts

Posted - 2010-12-07 : 12:37:24
Does SQL have the capability to do this. Maybe for a specific user account.

All help appreciated.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-07 : 13:41:42
It has the ability to do it if you code it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -