since the lines in the text area are delimited by char(13) and Char(10), you can use thse two chars to parse the text into a table.

the following sample sp does...

Thank you Scott, I will try the code.

Thanks to everyone. 

Perhaps I didn't make me clear. What I want to know is that in a SP what is the transaction isolation level  CURRENTLY being used. The isolation...

When you truncate log, it's logged in the SQL server ErrorLog file.

You can also get the information in master..sysperfinfo.

Object_name: SQLServeratabases

Counter: Log Truncations and...

Instead of the server names, You can use genric names as linked server names, e.g. 

Define the business linked server on the ERP db server, given the linked server name as something like...

I think you need to use a domain user account that can access the mapped drive as the proxy account.

You can set up the link server on the destination server, and perform your inserting there.

It sounds to me that the backup is corrupted or not finished. You can run the following command to verify it:

RESTORE HEADERONLY FROM DISK='your back up file name'

If the backup...

1) If you are using windows 2000 advanced server, based on my test on a heavy transactional sql server, turning hyperthreading off will greatly increase perfromance

2) If you are...

dbcc dropcleanbuffers only drops clean buffer. But if you modified or inserted data before you run the test, the dirty pages may still in the buffer.

You can run CHECKPOINT after...

SQLDiag.exe just runs once when you launch it. But it takes some time to finish becuase it collects lots of software and hardware inofrmation

In some cases, the @@servername and serverproperty('servername') does not always return the same result. It's safe to use serverproeprty('servername') becuase The 'servername' server property automatically reports changes in the network...

select Host_name() returns the local machine name.

select CAST(SERVERPROPERTY('servername') as nvarchar(255)) always returns the server host name.

you can try this in query analyzer from local server and remote client.

You can use UPDATE to do it directly.

create table test (ID int, Doc ntext)

GO

CREATE PROCEDURE usp_TEst @ID int,@Doc nText

AS

PRINT DATALENGTH(@Doc)

UPDATE test set <A href="mailto

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us