You can use BCP to export all Data from all Tables to flat files. As for the Objects, just script them!

Why would you require a third party tool?

Whats wrong with Enterprise Manager? You can manage your SQL 7.0 Servers with the SQL 2000 tools (EM, QA etc).

Believe me the 3rd...

Conevrt to what DataType?

rstone,

Can you give us a solution to this ? How would you write it?

This is indeed not your average trigger!

You are concatenating a  ',' after the quotename statement.

rstone,

You are correct. I forgot about multi row updates inside a trigger.

I haven't unit tested this but give it a go!

CREATE TRIGGER SumValue ON XYZ1

FOR INSERT

AS

DECLARE @CustomerID INTEGER

DECLARE @Date DATETIME

DECLARE @TotalValue INTEGER

DECLARE @CustomerID2 INTEGER

DECLARE @Date2 DATETIME

DECLARE @Value INTEGER

SELECT @CustomerID = CustomerID,...

Huh, Primary Index? You mean Clustered Index!

You have mentioned "So what I need to do is have a trigger that fires on the insert of a row into table one,...

I believe you just need to SUM the Balance Column and then GROUP BY Record,Type, In, Out    

Have a look at SELECT INTO in BOL.

Lets say that Field1 is a BIT DataType.

DECLARE @Param VARCHAR (5)

If Field1 = 1

  BEGIN

    SET @Param = 'True'

ELSE

    SET @Param = 'False'

    END

Your talking about Partioned Views!

However, How many million records are there and what is the growth per day?

Lets analyze this from the ground up before you dive into Partioned Views!

In my experience I have not found any performance issues with regards to storing Images in a Database as oppossed to storing them in a directory on a Server!

It just...

Parameter Marker? You mean Input Parameters to a Stored Procedure!

What are you trying to achieve here? Input Parameters to a Stored Procedure is a different kettle of fish compared to...

Or you can use a cursor!