Re: Very strange problem I am facing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/04/04


Date: Wed, 4 Aug 2004 08:02:39 -0400

1. It could be a trigger on the table doing something strange.
2. If you are doing an insert select or insert exec, your code might also be
doing the bad thing.

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"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: Email unkown when trying to add user in AD mode
    ... The problem is that I can't add them as a user in Active Directory mode. ... Wayne Snyder, MCDBA, SQL Server MVP ... > SharePoint Services). ... >> community of SQL Server professionals. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: which datatype do use for this?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... >> consider the image data type. ... >> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: How to learn .Net
    ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... have an appreciation of a few development tools such as Visual Basic v5, ... > Jamie Thomson ...
    (microsoft.public.sqlserver.server)
  • Re: bug or unknown feature in tsql/somewhere?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... "Mika Vääräniemi" wrote in message ... > By accident I changed the order of two rows and it started working!?! ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS Column Datatype Property?
    ... newsreaders will break the link across lines and any embedded link ... rendering will not account for this. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)