I've done a lot of work on audit logging. (Even wrote articles on it for this site.) Clustered indexes based on the insert sequence can definitely help with...

There's a prevalidate option on most items. You can turn that off. I've had to do so few times when a few too many properties were variable-dependent.

Are you trying to turn an existing column into an identity, or to add an identity column (new column) to a table?

Adding one is easy:

alter table dbo.MyTable

add ID int identity;

I think you can achieve the functionality more easily with the HierarchyID datatype in SQL 2008. Check out these articles, see if they have what you need:

http://msdn.microsoft.com/en-us/library/bb677290.aspx

http://msdn.microsoft.com/en-us/library/bb677193.aspx

Chris Morris (2/6/2009)

---

Grant Fritchey (2/6/2009)

---

Oh there are individuals, but the culture seems different. The Air Force bases were always so clean & orderly & mannered where as, except for boot...

Chris Morris (2/6/2009)

---

GSquared (2/6/2009)

---

Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I speak...

I use a trace for that.

The views only hold onto data for procs that have been cached, and flush and reload every time the execution plan changes. That means...

You can maintain referential integrity through your own code in whatever manner suits your requirements the best. You can't have foreign keys that reference a different database, whether on...

What error message do you get?

Again with the SQL being the database. It's not a valid equality statement. Select != set-multiply. If that's all you're saying, that's fine. SQL is not...

Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I speak extremely fluent American.

Bob Hovious (2/5/2009)

---

So my question here would be do you assume worst case that it's going to be hit really hard and go for the tabular method and take a...

One solution, probably a good one, in that case would be to set up a single master database with the common data (as you proposed), then have the other copies...

Nope. It's going to be one insert statement per table.

Do different people connect to the database with different credentials, or do they use a web page that passes a single set of credentials? (The later is much more...