Tnx again for your info, Allen.

On I/O problem: that surely is the case. The server in question is configured with RAID 5, not the best config for bulk data actions....

Hey Allen,

Tnx for your response. This process is running on SQL Server 2000 Standard Edition sp3A with 3Gb internal RAM. SQL Server takes as much as it needs, max...

You were right, it was. For some strange reason the SQLServerAgent was running under another than usual account...

Tnx,

Hansje

"[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters\NullSessionShares]"

This may help if you, the DBA, are allowed to do such thing on a remote server. I can think of plenty of reasons(and have experienced them) why you are...

Tnx for the info, ppl. I am aware of the several RAID configs and their pro's and con's. I'm still not sure how to physically distinguish between diskarrays. I'm not...

Actually the reply was ment for Ishaan99. Take a look at the results. For 1 run of the INSERT statement you get double entries exactkly the same. Imagine you run...

"MS SQL Server 2000 Standard Edition server component is not supported on this operating system. Only client components will be available for installation."

I see this message only when using a...

"The Microsoft Way is to told you that SQL 2000 on Windows 2003 is not supported"

Michael,

don't know why you say that:

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

If we're talking Standard Edition, then, W2003 does support it....

Why don't you try it yourself?

CREATE TABLE [AA] (

[A1] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE TRIGGER InsertTest ON dbo.AA

FOR INSERT

AS

Insert into...

Differences may occur and might be legal, if the subscribertables can be updated on the subscriver itself. I'm guessing from you posting this is not the case.

On comparing: with inner...

If you can connect to the backupfile on server1 from server2, you can choose this backup with the task RESTORE FROM DEVICE in EM. Alternatively you can use the TSQL...

Are you sure you're installing on W2003 SERVER?!

Tnx for the response Paul. As I said in my first posting I am not allowed to work on the W2003 server directly, which poses some problem.

I did some further...

It runs fine on a SQL Server 7 Standard Edition. Haven't a SQL2K setup available right now. What release are you using?

Tnx for the info all. I will sure keep them in mind.