Does this look right:

1. On "new" Subscriber: restore a copy of the subscriber DB.

2. On Distributor:

Go to Replication, Publications...delete the subscription.

3. On Distributor(Publisher database): run these...

-- Adding the registered...

interesting.

what about a situation where u have, for one process, 2000 sp calls to delete FK records. Would cascading deletes be faster there?

no check is not a good thing to use. Optimizer can use the default constraint in its execution decisions but if data is inputted with no check then it cannot.

DTS...

i would have to so this every morning.

not a good option.

Then read this:

INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453

sp_blocker_pss80(for 2000) is very good for this.

Read this first:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q271/5/09.asp&NoWebContent=1

what would be best in terms of performance?

2 ints or varchar?

there will have to be some conversion here for the web display. Show feet.inches for some, total area for others,...

no.

12.10 and 12.1 are different for my data. 12 feet 10 inches, 12 feet 1 inch.

If I insert 12.1, I want it to stay as 12.1. If I insert 12.10,...

simple recovery model.

- truncated.

For the sake of completeness...

This code will script out the drop index for all non-clustered indexs(excluding any unique primary key indexes).

DROP INDEX...

select 'drop index ' + object_name(ind.id) + '.' +...

-- Drop all NCI's(excluding any PK unique)

select 'drop index ' + object_name(ind.id) + '.' + ind.name

from sysindexes ind, sysobjects obj

where ind.id = obj.id

and obj.xtype = 'U'

and obj.type <> 'K'

and...

is scripting the common method?

what about scripting the replication out?

Select distinct

db_name() as CurrentDatabase,

object_Name(d.depid) As TableName,

s.name + '.' + o.name As Dependency,

substring(v.name, 5, 16) As Type

From sysobjects o

Inner Join master.dbo.spt_values v On o.xtype = SubString(v.name,1,2) Collate database_default And v.type...

how would triggers handle the denormalization?

can you elaborate please.