Re: Capturing SQL code that generates error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 14:50:51 +0100

Have you considered using Profiler? Let us know if you need help with using
Profiler to capture the statement and the error. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"DanetteB" <DanetteB@discussions.microsoft.com> wrote in message
news:E5E14CFC-8F1C-49F5-AEE5-40C14448FC86@microsoft.com...
I have an application that imports application data based on the Windows
Installer .MSI schema into a SQL database. If it possible that the data in
the tables exceeds the size allowed in our database. When that happens, an
error message is generated. This is fine as the user has the option to
'Ignore.'
The problem is that I cannot tell what application is being imported when
the error message is produced. Is there a method to capturing the 'parent'
SQL insert statements so that I can get the application name?
Thanks

Relevant Pages

  • Re: how to write sql to use Profiler to capture sql and sp running longer than 5 sec
    ... In the subject you write "how to write sql to use Profiler to capture sql ... and sp running longe" but when you ask the question you wrote ... Look up system stored procedures in the BOL that you can run to capture the ...
    (microsoft.public.sqlserver.programming)
  • Re: find out how often is a table get updated/inserted
    ... You can use profiler, capture the data to a file or table... ... The event should be SQL Statement Ending. ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Auditing SP Execute.
    ... I want to capture the user name and the time (using sql). ... i dont want ... to run profiler for ever. ...
    (microsoft.public.sqlserver.security)
  • RE: How can I get the last login date for a login ????
    ... You could capture it using SQL ... Profiler and output the information to a SQL table, ... triggers on user tables to track this. ...
    (microsoft.public.sqlserver.security)
  • SSIS not converting between non-unicode and unicode
    ... I don't know about you, but adding data conversion objects, and selecting each field... ... asking for a fix to automatically convert non-unicode to unicode in 2005!!! ... I am converting a simple (at least in the SQL Server 2000 DTS days) to this ... error message stays the same ...
    (microsoft.public.sqlserver.dts)