Is @@connections thought to rise rapidly and continous???
Had anyone this problem?
Users are known in the database.
Thanks,


-----Original Message-----
From: Bauer Johannes
[mailto:mssqldba-ezmlmshield-x48481155.[Email address protected]
Sent: Monday, March 31, 2008 2:40 PM
To: LazyDBA Discussion
Subject: Connections Problems // exec sel_vc_needing_delete

Hello all,

I face following problem:

we have a sql2005 64bit environment and my connection attempts from
users are increasing for every seconds about for 3 users.
I do not know what exactly is going on there. I did some trace with SQL
Server profiler and there it says user login is connectiong of
application .netsqlclientdata provider, trying to execute following:

exec sel_vc_needing_delete

Has anyone an idea?
there are different users trying to do that.

I have identified now the stored procedure, but why is it trying to
execute it as another user?
Could it be, that it is not well definined in the application?


########################################################################
#############

This message and any attachments are solely for the use of the intended
recipients. They may contain privileged and/or confidential information
or other information protected from disclosure. If you are not an
intended recipient, you are hereby notified that you received this email
in error and that any review, dissemination, distribution or copying of
this email and any attachment is strictly prohibited. If you have
received this email in error, please contact the sender and delete the
message and any attachment from your system.

Thank You.

Andritz AG
Rechtsform/ Legal form: Aktiengesellschaft/ Corporation Firmensitz/
Registered seat: Graz Firmenbuchgericht/ Court of registry: Landes- als
Handelsgericht Graz Firmenbuchnummer/ Company registration: FN 50935 f
DVR: 005 0008
UID: ATU28609707
########################################################################
#############



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page