I have tested this stored procedure against a local copy of my database at work and it works great. The only problem is I would like to alias the...

I appreciate the advice, however I never got this second instance running. In the end, I was able to circumvent the need for a second instance. So, problem...

OK, will do. Thanks Jared.

Hi SQLFRNDZ

This doesn't really clarify for me where running the gen script comes in. How will having a copy help me here? When I run the genscript, is it necessary...

yes Matt I am glad you are insinuating that these scripts do no good. Why reseed at all when in 2 tables these are FKs referencing a identity PK...

The strange behavior that occurs when I leave this code in my migration scripts is that it populates the first row of the ApprovalModel column with a 2. Therefore...

R.P. Rozema. I am very interested in understanding what you are saying better. Would you mind telling me line by line (yes, just brief words are fine) what each...

:w00t: Actually, still have this question:

What is the following clause, placed in front of an INSERT statement, accomplishing? Specifically wondering about lines 3,4,5.

DECLARE @Identity INT

DECLARE @IdentityStart INT = 1000000

SELECT @Identity...

figured it out. I need to delete rows from table before I can reseed.

as follows

delete from tablename

cool. thank you.

Sean, OK. I had intially tried it without a temp table but was getting an error message indicating the declare and set statements were out of scope.

Now I...

solution was to put the select statement into parenthesis.

declare @Eyear smallint

set @Eyear = (select Eyear from #tempYear)

woohoo. Thanks Sean for getting me there. Thanks to both for help.

Sean, would you kindly look at this?

I used your pseudocode and added a temp table because I am going to glue all scripts together AND create a temp table to...

thank you very much. That is a very good argument for not using the global temp table as many tabs are going to be opened and there is a high...

OK, so what you are saying is combine all files into one file. The batch seperator 'GO' makes certain to execute each individual script seperately anyway, and I can...