Actually, I used the Maintenance Plan Wizard to create the maintenance plan and the T-SQL I posted is what the Wizard generated. So, not sure how the 'N's got there.

No, same error is generated with the SSMS.

Thank you. You answered my question.

Thanks, that did it.

Thanks, that help a lot!

Paul

Well, my solution was to restore it into a SQL Server 2000 database, instead of SQL Server Express.

So, no real clever T-SQL here.

Sorry.

Thanks,

Paul

Sorry, looks like this should have been posted in the SQL Server 2005 forum.

I have solved my problem.

Thanks,

Paul

Thanks I will give it a try.

Thanks, this is great link!

Paul

Yes, the querry does. A Parcel ID in the Field_Data table should be in the GIS_Data table too.

Plus, this is a temporary app, so doing it right will spend more...

I see the GIS_Data as the master table. This is where ALL parcel ids live. Some are duplicate IDs, but the records are not duplicates. True, some more normalization...

Thanks for the script. I am kind of new to T-SQL could you give me a quick summary of what this does?

I should mention that the records with the duplicate...

True, there is about 1,000+ records with Parcel IDs in GIS_DATA (some of these are duplicate IDs, as mentioned). Field_Data gets populated with Parcel IDs once users add field data...

I understand that the Business Intelligence Development Studio or BIDS, is the development platform for SSIS packages. Also, Visual Studio 2005, and BIDS are exactly the same shell or IDE....