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.

"tell me why I don't like Mondays"

check out : Moving SQL Server databases to a new location with Detach/Attach

(http://support.microsoft.com/default.aspx?scid=kb;en-us;224071)

if I'm correct, after you changed your systemdate, sqlagent will change the "next rundate/time" to 27/05/2005 12:00AM. So the only thing it does is check wether it has the correct...

Do I really need to wait 4 hours until I can start differential backup? Yes

Do I need to check error code (probably, yes, and how to do this) after full...

Keep in mind some of them are created by implementing a constraint and need to be removed by drop constraint.

Here 's a little testcase to show how you can do...

yep

Check sqlagent master-server

I cannot test it right now, but if i remember correct, it would for...