A little tongue in check but Question #1 would have to be:  What changed on your network last week?

Beyond that, what type of replication, across what type/speed link?

Joe

Will -

You have my sympathy, the restoration of a server from scratch to pre-crash status is often a complex, time consuming and frustrating experience.  Ideally...

Sounds like a good case for seperate windows security groups (e.g. development_users & production_users or some such)?  Users can be members of one group, both groups or neither group...

Or is...

Since I'm running SQL Server 2000 on a bunch of Windows 2003 Server machines I know it can be done! 

Without knowing more about your configuration there are a lot of possibilities...

CREATE PROC USP_CalculateEconImpactDays @MeetingID INT, @MeetingEventCategoryID CHAR(1), @DelDays INT

AS

SET NOCOUNT ON

if @MeetingEventCategoryID = 'L'

 select @DelDays * 175 AS LocalEconImpactDaysTotal

if @MeetingEventCategoryID = 'N'

 select @DelDays * 420 AS NatEconImpactDaysTotal

if @MeetingEventCategoryID =...

Select * from test2..table2

two dots.

Joe

Would it be too much to ask for your database owners/object creators to specify that the object should be owned by dbo (e.g. create table dbo.tablename... rather than just create...

I agree with Enthusiast, there are a lot of unanswered questions here.

I can safely say that a 40 million row table is no big deal assuming you're running on the...

About 2 weeks after we moved into our current data center the whole data center went down for about 17 hours... freak problem caused an arc in the power room...

Just out of curiosity - what percent of the data in the table are you deleting? 

Another possible solution would be to copy the data you wish to keep into...

JW this is a wag but what you probably need is two stored procedures (or one that returns multiple recordsets) to retrieve all of the information on a specific player, something...

Uh oh!  Please google "sql injection" before you get to far along with your project, the type of application you are proposing is incredibly risky/dangerous.

Since you're using bcp for both export and import use bcp native type/data format (-n) rather than delimited/text (-c) for your file format and you should be fine regardless of the content...