Great! Thanks for the detailed response.

I was trying pointer to check if can be done with OPENXML but I like your solution.

Thanks,

SQLArch

I checked and its Sheet1. Also I used the some old file for Archive folder which did worked earlier ( about month back).

Any more suggestions.

Actually it is ntext in table. I removed casting to varchar(max) and it worked. Though I don't see any reason why cast is cutting off at 8000 characters.

Thanks for your help....

Sorry about that. See that I declared the variable as varchar(max) but still it truncates at 8000 characters.

Here is the code:

Create procedure [dbo].

I am using Begin Transaction instead of Begin Distributed Transaction.

But if this is the case it should not run successfully any night.

I am using this:

SET XACT_ABORT ON

 BEGIN TRAN

insert remoteserver.mydatabase.dbo.mytable(docName, scfForm,...

I am using 2 Linked SQL Servers (MSSQL Server 2000) and using MS Distributed Transaction Coordinator for transactions. 

maxdop hint limits query but not stored procedure. Is there any set parameter for sql to turn on and off for procedure level.

As a workarround, I removed XACT_ABORT OFF from...

I tried few more tests.

If the table name is with space. i.e created table [Titles Type] from Title in pubs and used tranasctional replication on other server. Replication successful....

Use this vbs

SQlServer=WScript.Arguments(0)

Filename=WScript.Arguments(1)

const TrustedConnection = 256

dim version1

Set oPackage1 = CreateObject("DTS.Package2")

oPackage1.LoadFromStorageFile Filename,"","","",""

oPackage1.SaveToSQLServer SQlServer, , , TrustedConnection

Set oPackage1 = Nothing

You get this error if you try to insert data from one  datatype to another. for example nvarchar(50) to varchar(50). Changing datatype to nvarchar(50) should solve the problem.

You can try increasing ODBC timout for Access query. I think default is 60 secounds by Access.

You mean EM SQL DMO is also not reading data from next_run_time column in sysjobschedules? 

How can I get the correct next_run_time data similar to EM? I want to generate timely report...

I had this problem lot of time.

If 2 users are connected using same data. it might be locked for one, as Access is designed the way that it puts page...

You can use freeware of codesmith. I found this very interesting tool. It will generate html files and .chm files too, if you use addons.

The procs and even triggers are already using nocount ON.

Does anybody know how can I increase DiskIO for process. Like I use DBCC WAKEUP to get the process running if...