473,382 Members | 1,635 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

What is @@SPID??

ganeshkumar08
Hello..

Can any one give me brief explaination regarding @@SPID.
And where we have to use it and to use it..

Ganesh
Apr 24 '08 #1
3 1415
ck9663
2,878 Expert 2GB
Hello..

Can any one give me brief explaination regarding @@SPID.
And where we have to use it and to use it..

Ganesh
Read more here
-- CK
Apr 24 '08 #2
Read more here
-- CK
I already read it,
I need a scenario where it is used and how it is used...

Ganesh
Apr 24 '08 #3
ck9663
2,878 Expert 2GB
Server monitoring.

If you want to know what your Process ID, then you can use that for a lot of things. Monitoring, logging, etc.

-- CK
Apr 24 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Travis L. Alltop | last post by:
Is there an easy way to do this? I can see the SPID on SQL but its hostname is just the Metaframe Server, and that does not tell who it belongs to on that server when there is multiple users on...
2
by: Paul | last post by:
Is there a way to get the SPID at runtime (the server-side connection/process ID, which you can see in the management/current_activity/process_info area in Enterprise Manager) from an active...
1
by: Matik | last post by:
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 remotely my database from another database on another...
2
by: JimLad | last post by:
Hi, In an existing ASP/ASP.NET 1.1 app running on IIS 6, I need to RELIABLY pass the logged in username through to the SQL Server 2000 database for auditing purposes. The current method is...
1
by: Absinthe | last post by:
I am seeing intermittent blocking problems. The strange part of it is, that the SPID listed in the Blk By column is the same as the SPID that is being blocked. Has anyone seen this before, or...
1
by: Agnes | last post by:
when One user open the application, he will access around 5 database so there will be 5 spid in the sql server , right? if there are 200 hundres user , there will be 1000 right?
7
by: =?Utf-8?B?S2plbGwgQnJhbmRlcw==?= | last post by:
Is there a way to get unique @@SPID to database when programming solutions for IIS in ASP. When trying I realize that the actual client/user against MSSQL database is IIS, not the currently...
1
by: liquidfirex | last post by:
I have looked at all documentation I can find but still cannot find the answer to my simple question! When connection pooling is enabled, all individual connections still maintain their own SPID...
1
by: Yoda | last post by:
Hi, which is the syntax for a stored procedure that return to me the exact @@SPID of my current connection? I'm using ADO in VB6 and i want to obtain @@SPID Thank u Rob
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.