Using xp_fixeddrives across a Linked Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Using xp_fixeddrives across a Linked Server

Author

Topic

patshaw
Posting Yak Master

177 Posts

Posted - 2008-03-20 : 08:37:47

Hi,

If i use:


exec MyLinkedServer.master.dbo.xp_fixeddrives

I get results results back in an instant.

If I try:


insert into #temp1
exec MyLinkedServer.master.dbo.xp_fixeddrives

then the query hangs forever. Does anyone know why this may be?

Thanks.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-20 : 08:52:57

See if the last solution in below thread is useful for you:

http://www.developmentnow.com/g/113_2005_5_0_0_526805/Using-xp-fixeddrives-on-a-linked-server.htm

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

patshaw
Posting Yak Master

177 Posts

Posted - 2008-03-20 : 10:38:50

Works a charm - Thank You.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources