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

Explain trigger and its types?

0 Answers  

---

What is a cursor, index in sql?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Can we install sql server 2016 on windows 7?

0 Answers  

---

Explain about service Broker functions?

0 Answers  

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

What is meant by datasource?

0 Answers  

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

How do I completely remove sql server instance?

0 Answers  

---