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

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

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  

---

How raid can influence database performance?

0 Answers  

---

When would you use sql joins?

0 Answers  

---

What do you think of this implementation? Can this be implemented better?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What is built-in/administrator?

0 Answers  

---

What is collation sensitivity?

0 Answers  

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

How to create database with physical files specified in ms sql server?

0 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---