Thanks BobAtDBS for stating the obvious   Was merely trying to add some general information to this topic without going into the specific example of...

Simple rule - use IDENTITY columns where they are required.  If you need one then you will know.

If you are just talking about adding an identity column to a table where...

I had a similar trigger problem before - the update trigger was being fired even although the physical update on the table was updating 0 rows.  This meant that the...

Use the Client Network Utility and set up an alias for MYSERVER\MYINSTANCE.  It's the \ that is the killer !!.

Try this instead but run it from an osql window.

select 'dbcc ' + tablename + convert(char(1),0xa) + 'go'

from tablelist

Much neater and easier - old sybase trick.