SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Using xp_fixeddrives across a Linked Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

patshaw
Posting Yak Master

177 Posts

Posted - 03/20/2008 :  08:37:47  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
5581 Posts

Posted - 03/20/2008 :  08:52:57  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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"
Go to Top of Page

patshaw
Posting Yak Master

177 Posts

Posted - 03/20/2008 :  10:38:50  Show Profile  Reply with Quote
Works a charm - Thank You.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000