The original question was how big is the db. this is answered by looking at how much space is allocated for that db, the maxsize filed in the sysfiles table.

if...

The following statement will give you the currently allocated size of a database:

SELECT [maxsize] AS 'pages', (CAST([maxsize] AS bigint) * 8192) AS 'bytes'

FROM dbo.sysfiles WITH (NOLOCK)

WHERE ([status] & 64)...

Of 25 sql servers that I manage in the healthcare industry, 5 of them exceed 1 Terabyte in size. The smallest server contains ~8.5 billion rows of data across 4 databases, and around...

These 'phantom connections' typically are connections from a DTS package. In some cases they appear to remain connected for some time after the actual connection has completed its work. If you...