SQL Express - Identity specification property - how to change

#21

Don't forget all the other data that get's deleted as well - all the tables
that reference the Foo table which likely contain time important information
like order_date, trade_date etc...

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

#22

Tony Rogerson (tonyrogerson (AT) torver (DOT) net) writes:

Quote:

Don't forget all the other data that get's deleted as well - all the
tables that reference the Foo table which likely contain time important
information like order_date, trade_date etc...

Yeah, if there are some cascading foreign keys, or triggers a lot of
things can happen when Joe runs a no-op!

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Express - Identity specification property - how to change

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: SQL Express - Identity specification property - how to change - 11-29-2007 , 02:12 AM

Re: SQL Express - Identity specification property - how to change - 11-29-2007 , 02:17 AM