I can't speak for the clustered environment but SQL2000 does NOT require the service accounts to be local administrators.

The accounts obviously need full privileges to the directories that SQL uses...

I believe that each filegroup gets assigned its own thread so the only benefit you will get will be from whatever using separate threads gives you.

If you pass in a string containing nothing but spaces LEN will return 0.

UPDATE dbo.account

SET dbo.account.balance = DT.TotalAmount

FROM dbo.account

INNER JOIN (

select sum(amount) AS TotalAmount, account_num from atransaction

group by account_num

) AS DT

ON dbo.account.account_num = DT.account_num

Set up a role in DB2 explicitly to allow the execution of a stored procedure to insert the records into the appropriate table.

Add the user from DB1 to DB2 but...

Start reading up about the sp_makewebtask and sp_runwebtask.

In summary you can design a simple text template of what you want with tags where your source query should insert its...

UPDATE updatetble1

SET updatetble1.updatecol1 = updatetble2.updatecol2

FROM updatetble1 INNER JOIN updatetble2

ON updatetble1.joiningcolumn = updatetble2.joiningcolumn

WHERE Yourcondition = Your Value

An element is the main tag itself such as <Element>

An attribute is a value within the definition of an element such as <Element MyAttribute="An attribute value" />

How can I have 0.00632 reads and writes?

Use SCOPE_IDENTITY because SCOPE_IDENTITY identifies the last identity value for the current scope where as @@IDENTITY identifies the last identity regardless of scope.

SELECT @@VERSION

SP3 = 8.00.760

SP4 = 8.00.2039

SP4 plus embarrassing fix for memory problem in SP4 = 8.00.2040.

You should be on at least SP3

If you have an dbo.addOrderLine stored procedure then you could set up a dbo.addOrder stored procedure that accepts the parameters necessary to add an order and a single order line.

Wrap...

The N'string' thing converts an standard ASCII string to a unicode one.

db_owner is a database role that can do absolutely anything within the database. Destroy tables, alter stored procedures,...

Doesn't this mean that Excel has to be installed on the server?

If not then wouldn't it be better to break out the task so that one task writes the Excel...

Regardless of whether you have used sp_detach_db you can attach the MDF and LDF files.

As ever, backup your MASTER database on your target server before and after the attach.

You will...