Viewing 5 posts - 1 through 5 (of 5 total)
Thanks BobAtDBS for stating the obvious Was merely trying to add some general information to this topic without going into the specific example of...
January 3, 2006 at 8:26 am
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...
January 3, 2006 at 7:22 am
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...
January 18, 2005 at 8:13 am
Use the Client Network Utility and set up an alias for MYSERVER\MYINSTANCE. It's the \ that is the killer !!.
July 5, 2004 at 5:04 am
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.
July 2, 2004 at 2:03 am
Viewing 5 posts - 1 through 5 (of 5 total)