where do you want to display...Report, or UI or Query result?

SQL 2008 R2 - Change Tracking may help you...

http://msdn.microsoft.com/en-us/library/cc280462(v=sql.105).aspx

[font="Verdana"]i have similar issue, a store procedure was called from ETL Packages.

when executed store procedure alone warning was shown on result window but executing from pacakges was failed due to...

following will remove only duplicate records

here is example

DECLARE @tmpTable table(

--CREATE TABLE @phonebook (

[id] [varchar] (30),

[firstname] [varchar] (30),

[lastname] [varchar] (30),

[company] [varchar] (100)

)

INSERT @tmpTable SELECT '902','suresh','bangalore','sm soft'

INSERT @tmpTable SELECT '905','ramesh','xyz','company llc'

INSERT @tmpTable...

write vbscript task and reset object name to empty

Use SQL Profile and  Set Login to required users

Check Orignial File Name and Current File(s) Location

and Also what database you are creating in Attach as 'xxxx' and specify database owne 'sa' or backup user name

Suresh

Try recreate table by delete table and create new table with same name.

sometimes or.. Rename doesn't rename table name in sysobject

Try this,

Select Patient,invoice count(*)

From TablepateientInvoice

Group by Patient,invoice

Having count(*) > 1