Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how can we know that how many users are connected in
perticuler server??????

Question Posted / yudistara

Answers were Sorted based on User's Feedback



how can we know that how many users are connected in perticuler server??????..

Answer / rajesh kumar

select * from sys.dm_exec_os_connections

or

select * from sys.dm_exec_os_sessions

Is This Answer Correct ?    3 Yes 2 No

how can we know that how many users are connected in perticuler server??????..

Answer / vishnu

sp_who which is documented or sp_who2 which is similar but
technically not documented.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

Explain how to maintain a fill factor in existing indexes?

0 Answers  

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

How do you check sql server is up and running?

0 Answers  

Can you explain the role of each service?

1 Answers  

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

Explain what is sql server english query?

0 Answers  

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

What is the difference between cartesian product and cross join?

0 Answers  

What does the INSTEAD OF trigger do?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories