Re: Get a list of files a SQL Server instance can access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 18:41:10 +0100

At the TSQL level, EM uses some extended stored procedures. Run Profiler and see what they are. Not
documented, use at own risk etc.

I'm not sure whether these procedures are available through DMO, though. It would be great to have a
DMO trace tool, btw. A quick check in BOL didn't show anything obvious. The closest I could come is
the EnumDirectories method, perhaps worth using as a starting point? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Graham Morris" <Graywing@newsgroup.nospam> wrote in message 
news:eVG$wvUCFHA.3976@tk2msftngp13.phx.gbl...
> I'd like to be able to present my user with a tree view of the devices and directories a remote 
> SQL Server machine can access.
>
> What I need to do is what Enterprise Manager can do:  if I connect to a SQL Server database on a 
> remote machine to do a backup, when I come to select a filename the browse button shows me a view 
> of devices and directories on the remote machine.
>
> Is this a private trick reserved to EM or is there a way to do it with SQL-DMO?
>
> Thanks in advance for any help
>
> ---
> Graham
>

Relevant Pages