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

What are temporal tables in sql server 2016?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

What is a filestream?

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

How to make remote connection in database?

0 Answers  

---

What is simple indexing method?

0 Answers  

---

How to disable a login name in ms sql server?

0 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---