Re: Very strange problem I am facing

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 16:27:41 +0530

Hi,

In additions to Uri's post.. Could you run the SQL Profiler and execute the
ASP application (screen) which insert into that table.
After the insertion check the profiler output for the activities happened.

Check if you have any insert triggers which will populate the data for this
table.
Execute sp_depends <table_name> to get the dependant objects on that table.

Thanks
Hari
MCDBA

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:e3k4WDheEHA.596@TK2MSFTNGP11.phx.gbl...
> manisha
> Need more info.
> Why do you think that a single INSERT statement could not insert 6 rows
into
> the table
> Can you show us the query?
>
>
>
>
> "manisha_css" <manishacss@discussions.microsoft.com> wrote in message
> news:ACB94111-F85D-4FB5-B84E-D8B44D522DBD@microsoft.com...
> > On local server everything was working ok. (ASP/IIS Server/MS SQL 2000),
I
> shifted to live and one table started giving me problem. The name of table
> is 'tmpNews' and if i insert anything thr ASP it is getting replicated 6
> times.
> >
> > I just do not understand why, i tried to drop the table. recreated it
> again, restarted the database server, but i always get 6 records for 1
> insert statement.
> >
> > Pls Pls help me i am in big trouble.
> >
> > regards
> > Manisha
>
>

Relevant Pages

  • Re: SCOPE_IDENTITY() returns NULL
    ... My program uses Delphi ADO VCL components: ... I traced with SQL Profiler and it seems that between above ... Execute() and Openthere many internal commands are ... >> insert statements into an identity column occur in the scope. ...
    (microsoft.public.sqlserver.programming)
  • Re: executenonquery - insert works only in debug mode
    ... If I execute this code in run mode ... > insert fails and table Magazzini_Selezionati is empty. ... you will find the Sql Profiler among other tools shipped with SQLServer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem displaying OLAP cube results in Excel
    ... If you capture the MDX query submitted by Excel using the SQL Profiler ... tool, and execute it separately in Management Studio, you can check the ...
    (microsoft.public.sqlserver.olap)
  • RE: SQL Server and LAN Manager Authentication Level
    ... I've run SQL Profiler and I've noticed following: ... SQL:BatchStarting EXECUTE ... Best regards and a Happy Easter ...
    (microsoft.public.sqlserver.security)