How to browse SQL Server hard drive

[nctran]

Like SQL Server Enterprise Manager tool, when we create database we can browse the Server hard drive to select a folder for Datafile.

Do they use window API to do it ? or how?
I can not find Any windows API that does that.

thanks,

nctran.

 

[sguslan]

If Enterprise Manager is running on the server hosting the sql server , then the drives you browse in creating the database are the local drives on the server. But if you load Enterprise Manager on a nother machine then you'll be browsing the local disk on that machine not that of the server.

You still can create databases on the server using Query Analyzer with create database command. The path you provide in the command are actually the paths on the server local drives, so the path has to be present on the server local drives.. ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[sguslan]

More info on Create database:

http://www.msdn.microsoft.com/library/en-us/tsqlref/ts_create_1up1.asp

________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[Eldaria]

sguslan:

I'm not sure you are entirley correct there.

I have just used the Enterprise manager to create an additional Database on the server, from a remote PC.
I'm on the same LAN, but I'm using the Administration Tools from another PC than the server.
And when I browsed, I got the drives that are on the server.

Regards.
Brian Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.

 

[sguslan]

When i tested it on my client workstation it worked as I descibed. ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[Eldaria]

Odd, maybe different settings somewhere.
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.

 

[nctran]

Hi again!

I am really interested in how to browse the SQL Server hard drive from a Client PC, by using DMO or DTS or SQL-NS or windows API...etc...

EnterPrise Manager tool has provided buttons everywhere to browse the system data files, log files and it browses the SQL Server Hard drives not Client hard drives (You only save data to your local pc when your database is private not sharing with others)

I have not come across any API function that does that. I hope someone has been there done that, please let me know

thanks,