How to run Transact SQL through text pad

[Rajendra P. KASHI]

Hi,
I'm currently looking for how to run Transact SQL commands from the textpad.
And get the result in the text pad itself. Like we run java programs in the text pad.

Please let us know how to do this in the text pad.

Thanking you,
Reagards,
Raj

[A. Mitelman]

in Preferences. Tools add new tool: OSQL

Command C:\MSSQL7\Binn\osql.exe
Parameters -Sservername -E -dpubs -i$File

You may check Prompt for parameters box.

Personaly I don't like the way it works but it works.