Determine filepath from open SQL script

Question

Post reply

Determine filepath from open SQL script

laurence.proctor

SSChasing Mays

Points: 601
More actions
October 1, 2012 at 3:05 am

#282368

Hi everyone,
Can any one tell me how to determine the file path of an open SQL file in the management studio?
I am trying to run an update script which open other SQL files. These update files (and folders) will always be relative to the update script which could be installed to different locations; so what I want is to be able to determine the path of the update file being opened, so that variables do not need to be manually set.
Many thanks for everyone's help.
Laurence.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

okbangas SSChampion Points: 11773 More actions · Answer 1

Place the mouse pointer of the the file's tab.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]

laurence.proctor SSChasing Mays Points: 601 More actions · Answer 2

Thanks for the reply.

I know you can obtain the file path from looking at the tab. I want to be able to obtain the file path using TSQL within the script. It needs to be automatic.

Many thanks,

Laurence

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

<disclaimer> I don't even want to think about the security implications of what you are doing, so I will leave that to you</disclaimer>

Have you thought about using sqlcmd instead of ssms?

It can read files into the query stack using the ":r" command - and it uses relative paths ...

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);