Sp_who And Citrix
Jul 31, 2006
I have some users on Citrix, running an Access front end with ODBC
attached tables.
In sp_who. on a normal workstation they'd usually show once or maybe
more but all with the same hostname so counting actual number of users
is easy, group on loginame,hostname.
When someone connects from a Citrix server, I append the connection
number to the workstation name in the connect string so the hostname
looks something like "CITRIXBOXICA-tcp#256" also for terminal services
the hostname will look like "GANDALFRDP-Tcp#8".
The problem is that on Citrix the user appears twice with a different
tcp number, the hostname is made up of the name of the citrix/ts server
+ the environment variable %SESSIONNAME%, which is surely static for a
session?
Has anyone seen this in Citrix? Does it ghost old connections? I looged
out and in again just now and saw the sessions look like:
CITRIXBOXICA-tcp#199 & CITRIXBOXICA-tcp#254 for my user name then
after re-logging on I got CITRIXBOXICA-tcp#199 & CITRIXBOXICA-tcp#256
so that session 199 has stuck there but wasn't visible in sp_who while
not logged into the Citrix box.
View 1 Replies
ADVERTISEMENT
Aug 29, 2007
I'm trying to make an DTS which concet to oracle driver.
When I make an DTS in client SQL Sever installed locally (PC) it does conect. But when I use the client from Citrix MetaFrame it does NOT conect.
Any suggestion?... Thanks in advance.
In quiet oceans, all ships have a good captain.
View 5 Replies
View Related
Nov 3, 2006
Hi,
I'm wondering about the behaviour of the HOST_ID() function with clients running on a Citrix server.
As I said in my post about "dynamical views", I'd like to use the host_id as a terminal ID, assuming this number will be unique.
In my current configuration, each user has a client on his workstation which connects to SQL Server, an it works fine. But what happens if i migrate my clients on a Citrix server. Will I always have the same host_id or not ?
View 3 Replies
View Related
Jan 21, 2008
What do I have to do to set up replication over Citrix Metaframe? Right now, the best I can do is to export tables from one database, and then import them into the other database over the Citrix link.
Thanks in advance for any help.
View 3 Replies
View Related
Nov 15, 2007
I have an Access front-end with a SQL backend. The access front-end connects to a different database dependent on the user and function . The user is prompted to select a database and a new dsn is passed to reconnect the sql tables to the selected database. The program is run both locally and over Citrix. The program has run without error for 2+ years. Yesterday, I made a change to an ocx on 1 form and now I cannot connect via Citrix. The application runs without error locally. When I try to connect via Citrix, I get a SQL Login error SQL State 01S00 Error 4060. When I step through the code locally, the code runs as it should and does not error.
Any ideas?
View 1 Replies
View Related
Oct 2, 2006
Hi,
I'm at a loss as to why i am getting the following error:
Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154
I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this?
Many thanks in advance,
Grant
View 4 Replies
View Related
Jun 4, 2002
Hi,
How can I save result of sp_who into temp table or variables?
Thank you,
Elena
View 1 Replies
View Related
Jul 17, 2002
Hi!
I want schedule a job to run sp_who at 5 a.m.
How can I save the sp_who result to check it later.
Thank you,
Elena
View 2 Replies
View Related
Mar 16, 2004
Is there any way to write a line to a table showing who had a lock at a particular time?
We have a need to rollback transactions that persist for too long and cause application errors. what i want to do is to dump the details of the connection into a table for analysis later.
i am thinking along the lines of
SELECT loginname
FROM sp_who
WHERE spid in
(
SELECT spid
FROM sp_lock
)
or something!!!!
any ideas anyone?
View 3 Replies
View Related
Dec 13, 2005
Hi!
I need some examples of SP_Lock & SP_Who.
Best Regards,
Shabber Abbas Rizvi.
View 1 Replies
View Related
Jun 16, 2004
Hi,
Beside sp_who which shows the number of connections to databases,
is there any other sp that shows us the starting time for each connection because the
sp_who does not show the starting of the connection.
Thanks.
View 1 Replies
View Related
May 11, 2000
Hi,
I'm using SQL SERVER 7.0. When I do sp_who from Query Analyser to see who has processes running, I get three statuses on the processes, 'runnable', 'background', 'sleeping'.
I can't find anywhere in books, BOL, anywhere that tells me a definition of what each of these statuses mean.
Can anyone help me out?
Thanks,
Darrin
View 1 Replies
View Related
Apr 2, 2008
Dear All,
i've a doubt regarding the difference between sp_who and sp_who2.
i've read in one article stating that sp_who is documented and sp_who2 is un documented.what is meant by this?
and please provide me the articles related to locks(what are different types of locks)
thank you very much
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 4 Replies
View Related
Feb 1, 2007
Hello All,
I need to find out which user are connected to a What database. For this I can Use SP_WHo. But How can i fetch the required fields only dat too in Query Analyzer
Thank you in advance
View 1 Replies
View Related
Nov 30, 2005
Hello 2 all,Maybe my question can be very stupid, but I'm a little confused.When I run sp_who on my database, I see one process (accessing remotelymy database from another database on another SQL server) many manytimes.Well, I assume that this is one process, because I cannot imagin thatthe data aquiring can be done by almost 1000 (thousand) openedconnections.This is what I have. Almost 1000 spids running (sleeping) with cmd =awaiting command.The best part is, that when I run sp_lock, I see, that the currentsession of the client, (lets say spid 53) is locking tempdb, withobjects id below 10 (system).As far as i know, and as far as I'm using this in my software, there isno necessity to open-close-open-close connection.Normaly, you can just open a connection to db, with assigned spid, andoperate within this just one. After the disconect ist done, the sessionshoould be removed.I think, there is something wrong in the way, the remote system isconnecting to my database, but i'm not sure is it normal what I'mexpieriencing or not.below, a piece of that what sp_who returned:SPIDECIDstatusloginnamehostnameblkdbnamecmd2660sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMAND2670sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMAND2680sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMAND2690sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMAND2700sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMAND2710sleeping remote_user_namehost_ERP 0PRIMARY_PROCESS_DBAWAITING COMMANDand these are locks from sp_lock 53 which is the current runningprocess:53700DB SGRANT53260TAB IXGRANT53210TAB IXGRANT53230TAB IXGRANT53220TAB IXGRANT532120TAB IXGRANT53290TAB IXGRANT532110TAB IXGRANT53232KEY(1902141b21c7) XGRANT53213KEY(e60041ad2c6f) XGRANT53232KEY(5b0233670fb9) XGRANT53232KEY(6e0212a7298c) XGRANT53232KEY(97013ece81c8) XGRANT53231KEY(e7006f987fb0) XGRANT53213KEY(ad00a33f46b9) XGRANT53210643560700TAB Sch-MGRANTany idee?ThanksMateusz
View 1 Replies
View Related
Sep 12, 2007
Hi
I would like to convert sp_who into a table/query. Please help
Thanks
View 3 Replies
View Related
Sep 12, 2007
Hi
How to convert a sp_who in into a table/query
Please help
Raj.
View 2 Replies
View Related
Sep 26, 2007
Hi
we have one 'application'-user in sysusers that makes the connect to SqlServer for all users, for example:
Application Login-User: Thomas
DB-Connect-User: AppUser
With this solution, in Activity-Monitor or with sp_who I don't know, what is the real name of the connected user.
Any possibility to change the login-information after the connect, so that i can see 'Thomas' in Activity-Monitor or with sp_who?
Thanks for your help.
Thomas
View 4 Replies
View Related
