Jon,

DBGhost it the answer to your porblem.

With DBGhost you will not only know what changed but it will build an update script for sync'n deployment to testing.

We've used several comparsion...

The temp table #TmpA is out of scope for the sproc sp2.

You can either create the temp table in sp1 as ##TmpA making it global, or call sp2 from within...

If you need a parameterized view, use a udf that retuns a table. Its much easier to develop, test, and deploy then nested procedures using the INSERT INTO statements.

Christopher DeMeyer

In our company, I have made it a rule to always include a comment line like (--ForEncryption--) in the proper place within each SP, UDF, or VIEW created. Then on...