How get full path location from any file in SQL Server

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

Hello

I need to know How can i get the root location file

for example:

I Have a text file "Text.txt" on hard disk Unit C

by SQL create a store procedure with parameter entry with the file name

"exec GetRootFileName 'text.txt'"

Thanks people.

If Need more information please comment this post.

Posted 6-Jul-15 17:18pm

Salomon Pineda Silva

Add a Solution

Comments

Dave Kreskowiak 7-Jul-15 0:26am

Yeah, this made no sense at all. Are these "files" or filenames stored in a database on the SQL Server? Are you trying to locate an actual file on a drive? What is this "GetRootFilename" your executing? Is it s stored procedure you wrote or what?

Salomon Pineda Silva 25-Jul-15 19:03pm

I try to get the same function when you serch a file in the explorer.

Dave Kreskowiak 25-Jul-15 19:13pm

OK, are you searching the file system for a file or are you searching for the filename in a database table?

Without a ton more detail from you everyone is just guessing at what you have to do.

Salomon Pineda Silva 25-Jul-15 21:17pm

you're right, for that I Put if you need more information. greetings

Dave Kreskowiak 25-Jul-15 21:42pm

I repeat, "Without a ton more detail from you everyone is just guessing at what you want to do."

ZurdoDev 7-Jul-15 8:36am

What exactly is your question?

Salomon Pineda Silva 25-Jul-15 19:04pm

When you search a file in you explorer, you get all files with the root location. In this case I want to try the same way but in SQLServer makin a stored procedure.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

adityasahver · Answer 1 · 2015-07-12T08:14:00

Solution 1

you cant do it based on the file name, as in various locations you can have file with the same name and extension. Instead write a powershell and try to achieve what you need.

Posted 12-Jul-15 8:14am

adityasahver