Answer / sreenivas

try this below query:

use <databasename>
go
select db_name(dbid) as db, count(dbid) as connections from sys.sysprocesses where dbid > 0 group by dbid

How to create a local temporary stored procedure?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

What is cte (common table expression)?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

Explain view in sql server?

0 Answers  

---

How to set database to be single_user in ms sql server?

0 Answers  

---