Terminal Services: get terminal machine netbios name, host

Terminal Services: get terminal machine netbios name, host_name() returns server

microsoft.public.sqlserver.programming

3 Mar 2006 9:58 AM

Ben

Hi

We have been using host_name() to return the workstation name. We now have
two terminals on our network and find that Host_Name() only returns the
server name.

Is there a function that will return the terminal name?

Thanks
B

3 Mar 2006 2:19 PM

In the case of Terminal Services, the application process is actually
running on the host server not the user's PC ?

If the database connection uses Windows Authentication supplied by the user,
then the system_user() function will return their network login ID.

Show quote

"Ben" <B**@Newsgroups.microsoft.com> wrote in message
news:OrnUEkqPGHA.1728@TK2MSFTNGP11.phx.gbl...
> Hi
>
> We have been using host_name() to return the workstation name. We now
> have
> two terminals on our network and find that Host_Name() only returns the
> server name.
>
> Is there a function that will return the terminal name?
>
> Thanks
> B
>
>

3 Mar 2006 3:12 PM

Ben

Hi JT

Yes the app is running on the TS, I need to know the workstation to divert
printing to a nearby printer.

Our application does not use Windows Authentication.

Thanks for your post.

B

Show quote

"JT" <some***@microsoft.com> wrote in message
news:eFl$v3sPGHA.2704@TK2MSFTNGP15.phx.gbl...
> In the case of Terminal Services, the application process is actually
> running on the host server not the user's PC ?
>
> If the database connection uses Windows Authentication supplied by the
user,
> then the system_user() function will return their network login ID.
>
> "Ben" <B**@Newsgroups.microsoft.com> wrote in message
> news:OrnUEkqPGHA.1728@TK2MSFTNGP11.phx.gbl...
> > Hi
> >
> > We have been using host_name() to return the workstation name. We now
> > have
> > two terminals on our network and find that Host_Name() only returns the
> > server name.
> >
> > Is there a function that will return the terminal name?
> >
> > Thanks
> > B
> >
> >
>
>