Aha, a new network-rooster a the barn wanting to galvanize so (s)he is thé employee of the year !

1) Don't panic (I know...

- sqlserver needs some (?) time to check and correct it..

- Can you post an example script for a job where you encounter...

In that case, I hope this can help out

TEST_TEST_TEST

declare @ParentTbName sysname

declare @ParentTbOwner sysname

Select @ParentTbName = 'T_Server' -- = your table to be dropped

,...

Include dbo to Model-db so it is included in every new db that will be created.

Try this 

_test_test_test_...

-- jobi dd 19/03/2004

-- toevoegen YourDomain\YourDBOUser aan server en met db_owner-rechten op alle...

there is a web sql-management intereface (I beleive at MS) downloadable, I cannot rember where, but it had this functionality.

If I find it...

you mean dropping the parent table will also drop all dependant tables ?

sqlserver does not support that. You'll have to build your drop-ddl yourself.

You can do that with a recurrent...

Are you looking at the same instance of sqlserver ?

Are server1 and server2 nodes from the same cluster ?

maybe sp_helpindex 'yourobject' as a base for your generate script may be quiet usable combined with the undocumend sp_meforeachtb.

IMO it's tricky to drop all indexes just to do a BCP.

This will hurt you system _and_ it will hurt again when you recreate these indexes !

And in the mean...

What you (they) did not put into it, you'll not get out of it the easy way

Lest's hope you have naming-conventions to point...

- apparently that bug/malfunction has not been solved with sp4

 check support.microsoft.com/?kbid=883551

my 2ct

- also keep locking in mind !

- sp_updatestats + dbcc updateusage will rectify your statistics

- you can use sql-perfmon to find out what is consuming how man.

Check out Data Transformation Services (DTS) in your Enterprise manager.

This will be more simple and intuitive.

If you don't invest in determining the correct datatype for you attributes/columns, don't even wast time at performance !

Indeed,with sqlserver you only have a...

Move your sp-validation to your vb-code and use SQLBULKCOPY (vb.net).

this is a "fast load" if you have ordered your data according to the clustered index of your table.