Interested to Buy Any Domain ? << Click Here >> for more details...
What stored procedure can you use to display the current processes?
- 1 Answers
- 963 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sudhanshu Shekhar
In SQL Server, you can use the sp_who2 stored procedure to view current processes. It returns information about active sessions and their related resources:
```sql
EXEC sp_who2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql or structured query language?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is a scheduled job or what is a scheduled task?
What are the source of constraints?
How to convert character strings into numeric values?
What are wait types?
What are the properties of the transaction?
What is clustered index
List the ways in which dynamic sql can be executed?
What are the different SQL Server Versions you have worked on?
What is a view in sql?
Does view occupy space?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Disadvantages of the indexes?
