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 is the maximum size of sql server database?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

What is rank function?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

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

0 Answers  

---

How to get the definition of a trigger back?

0 Answers  

---

Explain DBMS, RDBMS?

6 Answers  

---

What is a field name?

0 Answers  

---