Interested to Buy Any Domain ? << Click Here >> for more details...
How can I know what query is executing by by a particural
user? (using sp id or any othe way.)
- 2 Answers
- 5274 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suvendu
SELECT *
FROM Master.dbo.sysprocesses
WHERE DBID NOT IN (1,2,3,4) -- Master, Tempdb, Model, MSDB
AND spid > 50
ORDER BY spid DESC
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prem
DBCC INputbuffer(spid)- Displays the last statement sent
from a client to an instance of Microsoft SQL Server 2005.
First 256 characters only will be displayed.
SQL statements can also be captured by running a profiler.
| Is This Answer Correct ? | 2 Yes | 2 No |
Why the trigger fires multiple times in single login?
Explain about SQLOS?
How do I start sql server 2016?
What are Sql Reporting Services and analysis services? Can u Explain
What is log cache in sql server?
What is database replication?
how we can store the value like that 001,003,023 etc in sql server 2005
List some major differences between triggers and stored procedures?
What is a natural primary key?
What is meant by indexing files?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How can I create a table from another table without copying any values from the old table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
