I had this issue. I increased the max size of the first file in the primary filegroup (thus allowing it to grow). I was then able to add new datafiles....

I had the same problem. Fixed it in the same way.

Just allowed the primary data file to increase by 500MB. That allowed me add new datafiles.

Thanks.

I have 150 Servers to upgrade and so I don't want to have to manually upgrade each of them. I tried recording an ISS file but this doesn't allow you to...

Contacted MS Support. After much troubleshooting eventually concurred that this was some sort of DCOM problem.

Installing hotfix KB896720 fixed the problem.

Hope this helps anyone else who has this...

Yes. The stored procedure forms part of the distributed transaction.

An example piece of code that fails is:

-----------------------------------------------------------

drop table #dbs

go

create table  #dbs(

 DATABASE_NAME   varchar(30) ,

 DATABASE_SIZE   int  ,

 REMARKS   varchar(500) 

)

go

 insert into #dbs(

 DATABASE_NAME ,

 DATABASE_SIZE ,

 REMARKS)

 exec ('

 exec "<Remote Server>".master.dbo.sp_databases

 ')

-----------------------------------------------------------

The problem is not...

I have now found out the error is only returned when i call a remote procedure in a distributed query.

A distributed query directly linking to the remote tables work...

I am not using windows authentication.

I have now tested the problem from a Windows 2000 to a Windows 2000 machine and am getting the same problem.

After having...

I believe we do have trouble going from one 2000 to another although I am restricted to only creating linked servers on an XP box and so...

Thanks for you help Brian. Unfortunately  I am still have problems.

Yes I am running SP2 on the central XP box. However...

Mr Peterson,

You indeed are an old hand and if i could, i would like to shake you by the hand.

I have now managed to get my linked server queries working....

Thanks dc.

I haven't had a chance to test this out yet but i think have diagnosed the problem. Will post another reply to thank you and let you know...

I am running XP on one machine and Windows 2000 server on the other. Both machines are in different domains.

Do either of these factors make a difference?