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 what role entity and relationship play in an ER diagram.

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 insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---