Thanks for the quick response. Though, using @@User gives an error (Must declare the variable '@@User'). I ended up using the hostname instead of the user because I figured that one out.
-- get the users hostname
SET @UserHostname = (SELECT hostname from master.dbo.sysprocesses
Where...
Hi, I have a need to get the name of the user logged in (who invoked) a stored procedure. I want to store settings that are user specific in a table. When the same user requests a setting, he needs to get his own settings. How can you tell who called a SP (or UDF) from within the procedure? Or...
I have used touch screen in a few VB projects and they are totally independent. I am not sure if all touch screens are the same but the ones I have used do nothing more than mimic a mouse click. You just need to set your screen up with big buttons plug in your touch screen and go.
You can get what looks like garbage output if you dont have the parameters such as baud, parity ect.. set up correctly. It is also possible that the vendor saves everything in a binary format and it is being transfered and displayed as ASCII.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.