I assume you guys are saying that a column with a property of IDENTITY is a bad choice for a clustered index becuase it has been beat in your/our heads...

You can not delete from a view that references multiple tables (AFAIK)

Try this:

use tempdb

create table one (nbr int)

create table two (nbr int)

create table three (nbr int)

insert into one select 1...

SA covers you for three years, if you do not think you need/want to upgrade within that timeframe, you should not buy SA as it is more expensive (almost double...

DTS is an awesome tool, this link covers some of the basics -

http://techrepublic.com.com/5100-6268-1043668.html

the books mentioned by Mani are good

HTH

36%, 52% Frank...wow

There are different ways to do this, for something like this linked servers may be a pain and I would use a DTS package to run the SQL scripts on...

Look up sp_addlinkedserver in BOL and see if that helps.

I enjoyed my copy from Seattle PASS, when do we get another one?

And to add to Frank's post, deleted rows would cause the appearance of gaps.

This page may help - http://www.algonet.se/~sommar/error-handling-II.html

As you are not converting the actual column to a string, you might be right Jonathan, have to run some tests to confirm, also didn't realize it wasn't stored as...

Very true

Does watching football (american) count as life outside of computers and databases?

I suspect you are needing something like this

create trigger foo on tablename

for update, insert

as

update tablename set modifiedDate = getdate()

where EventID in (select eventid from inserted)

This will accomodate batch inserts...

Like Gary said, replication might be a possibility. Are you using this as an N-tier design and will be running reports from the second server or is this strictly for...