If it is doing it during DEBUG I would suggest printing the LEN and the CODE() for the character that is being passed in.

Clearly DEBUG is translating the space in...

The only way that I can think of is to use an OPENROWSET and predefined connection but that isn't a way I would choose to do it.

Are you using Windows...

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,...