Re: There is already an object named ... in the database

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

From: Aaron Weiker (aaron_at_sqlprogrammer.org)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 17:33:18 -0500

Jan Doggen wrote:
> No ;-)
> It's the truncate. I delete the table beforehand like you suggest.
> Maybe I have to dig deeper into the way Delphi passes SQL statements onto
> SQL Server and handles transactions.
> Thanks for your suggestions,anyway.

Run profiler and see what is being sent to the database. Then go and run
the same statements in query analyzer. That should help diagnose what is
happening. 

-- 
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/

Relevant Pages

  • Re: TADODataset.Filter?
    ... I did try the LIKE operator as in SQL statements but ... where partial string filtering is concerned I didn't ... current Delphi online help there are comments ... the new features in Delphi. ...
    (borland.public.delphi.database.ado)
  • prepared command (or instruction) S000002 not found error
    ... we are trying to migrate our Delphi 5 BDE Win32 application to ADO and Delphi 2006 with Update 2 installed. ... We are accessing a iSeries (aka AS400). ... It is really wired because some SQL Statements runs and trying the VERY SAME SQL over ODBC works great, ...
    (borland.public.delphi.database.ado)