Set SysProcesses.Program_Name from OSQL or T-SQL?

Question

Set SysProcesses.Program_Name from OSQL or T-SQL?

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101097 More actions · Answer 1

If it's not running from SQL, how does it even have a spid? I thought spid was used by SQL, kpid was used by Windows.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

David Burrows SSC Guru Points: 65142 More actions · Answer 2

Try this

osql -S "servername;app=appname"

Far away is close at hand in the images of elsewhere.
Anon.

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Because it connects to SQL Server using connection string.

_____________
Code for TallyGenerator

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 4

You, Sir, are not only a genius, but you've made my day... I tested it and that is precisely what I was looking for!

I've gotta ask, David... how in the heck did you figure that one out? I beat the heck out of BOL and the Web looking for just that type of information... ya gotta tell me... how did you find it?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 5

Oh Jeez... the simplicity of your solution is even more proof of your genius... I'm a bit ashamed that I didn't figure it out on my own... much like "SQL Injection" works, you did a "Connection Injection"... absolutely brilliant!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

David Burrows SSC Guru Points: 65142 More actions · Answer 6

how in the heck did you figure that one out

Too many years of programming, far too many to mention

I used to use the app property in my connection strings to enable me to do what you are doing and built the string bit by bit (server, user etc), so I thought, well, osql must do the same and if it did not validate the -S param before using it....... then with a simple test, lo and behold it worked.

"Connection Injection"

never thought of it that way, wonder if anyone tried this to sucessfully attack sql server in some way

p.s many thanks for the compliments, makes me very humble , genius, no, but on occasion...... maybe a flash of inspiration

Far away is close at hand in the images of elsewhere.
Anon.