In addition to Remi's suggestion:

I assume that the @itemid is a passed in variable (before the AS).  Instead of using this variable set an internal (after the AS) variable.  There...

I guess the 1st question is:

WHY do you need to break the data into 5 different tables housing pieces\parts of the 1 table?

DBCC CHECKIDENT should be able to help you.  Information can be found in BOL or here is one link.  I searched Yahoo with "change identity seed SQL":

http://search.yahoo.com/search?p=change+identity+seed+SQL&tab=Web&fr=my-vert-web-top

To trace the times that each one takes you will need to flush the cache between runs of the stored-procedures.  It sounds like the stored-procedures are being cached and the...

Have you tried this without referencing tempdb?

AFAIK information from sysdepends does not affect performance (at least we haven't noticed it here).

The only way to get the information back is to drop\re-create objects in the proper order...

Did you try copying my code and changing the servername?

Try osql -SServerNameHere -E -dmaster -Q"sp_msforeachdb @command1='print "?"'"

Ok.  I'll bite.  IF you know the value is going to be a 5 digit number and you want to DISPLAY (assumption here) it as 0000n why not set the...

I would research BOL for PATINDEX and CHARINDEX along with REPLACE.  I believe you will want to look for CHAR(13).  If that is not the correct ASCII value you can play...

It is.  You will need to build a WHERE clause that looks for the yyyy/mm/dd format.  Research CHARINDEX and PATINDEX in BOL for help.

Remember TEST, TEST, TEST

Unfortunately, that is the way to do it

Can you please provide what it is you are trying to accomplish?  I think that we may be able to come up with a different solution then GOTO.  AFAIK in...

Can you provide more information about what you are trying to get?  Physical file location? Filename?  How to read it?

If you want this CREATE TABLE @FILENAME (PHONE VARCHAR(10)) you will need to build ALL of it into a variable and then EXEC the variable or sp_runsql....