The Primary Key Contraints has a different name or it does not exist.

Try querying the sys.ojects, sys.constarints & sys.columns tables. Also you the GUI to identify ihe constraints on a...

I have llisted some articles concerning this topic.

http://articles.techrepublic.com.com/5100-10878_11-1043671.html

http://www.devx.com/getHelpOn/10MinuteSolution/16507/1954

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Afterlooking at the explain plan you may want to consider the floowing:

THE IS NOT NULL will result in a table scan.

You may want to use a Non-ANSI Standard JOIN...

Setting up a Linked Server in a 64 bit environment requires an additional step.

Please refer to the following link:

http://www.mssqltips.com/tip.asp?tip=1433

You are attempting to add a record to a child table that does not have a corresponding value in the parent table as defined in the Foreign Key.

The error message...

You can do this at the Server Level but it requirees rebuilding the Master Database & reloading the Databases.

http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

Gift Peddie

Thanks

If you decide to move the Database to another Server and decomission the current Database Serve, please consider using an Alias SQL Server Name and/or a DNS Entry to redirect.

tks

Thanks

Avoid using Dynamic SQL embedded in the User Interface and Stored Procedures.

http://www.codeproject.com/KB/database/SqlInjectionAttacks.aspx

http://aspalliance.com/385_Using_SQL_Server_Stored_Procedures_To_Prevent_SQL_Injection

http://www.wwwcoder.com/Directory/tabid/68/type/art/site/2966/parentid/258/Default.aspx

http://www.appsecinc.com/presentations/Manipulating_SQL_Server_Using_SQL_Injection.pdf

The PSSDIAG data collection utility is commonly used to collect information prior to a consolidation.

Refer to the following Links:

http://support.microsoft.com/kb/830232

http://support.microsoft.com/servicedesks/webcasts/wc082401/WC082401.ppt

There a number of other factors to consider that are addressed...

The requirement requires that was provided is to return the first record created.

No pun intended but I really got myself into the Dog House with this post:-)

Your code is excellent and I appreciate your going out of your way.

I will archive it for future reference.

In this case I will only have one table to work with...