Yes Antare..this is a copy of the same message.

We made a similar dll for you but tried to repeat the problem once again at our site..This is what we have...

This DLL is executed from a stored procedure using sp_OAcreate method. Data is uploaded to the database from the textfiles using the txtdsn created (shown above)

levi

The current service pack is 3..do you suggest SP 4. more over the problem is in our customer site and we have to be very correct that this will solve...

The Scenario is like this

Group 1 = Cluster Group

Resources = Cluster IP address, Cluster Name, Quorum disk.

Group 2 = Disk Group

Resources = DISK E, DISK F

Now if I bring the...

I just went through and found an article by Andy about the MS Sqlserver 2000 Performance Tuning book... I bought the book today and hope this should help me in...

make sure you have move the files to the location where you want them to be before you attach.

The sp attach can be simple as this

sp_attach_db 'pubs','C:\newlocation\pubs.mdf','D:\newlocation\pubs.ldf'

I too faced a similar problem while restoring a SQL 7.database. The reason was the database i took the backup had the size defined as 1 gb datafile and 500mb...

Thanks a lot Antare..

I am looking out all the solutions explained by you...Well i can try them only if the Problem repeats....

levi

Hi Folks

here is an article that I digged from MSDN...from this can anybody find a solution so that the OS does not allocate port 5000.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rpc/ov-cnfig_5jzb.asp

Thanks...Antare..

Andy had suggested me /3GB Switch...I am still studying whether we should go for it...and also AWE...

Meghardy is right..you can try putting the Datafiles and logfiles on different Disk Sets. if you have configured raids place them under 2 different raid controllers which will give you...

Nothing else is running on the System except SQL and our application. The Total RAM is 4GB. the Virtual Memory is set to min 8 and max 10 Gb. There...

Thanks a lot Andy

That information was really helpful..

well we need to do this only on the weekend because we cannot bring down the machines until then...thanks once again.

Hi Andy / Antar

I am not using the /3Gb switch. It was a good suggestion and i am finding more on whether we should go for it...Please let me know...

Well..first of all I thank everyone here for the knowledge I gained from you guys.

The problem repeated here and now we are planning to change the Port No of our...