Now, after trolling through some system tables, I come to find out that this was a snapshot backup. We do not do snapshots. How could this have just...

Also, in case it matters for the solution, the replication components were not even installed for this instance. I do see replication system stored procs in master though. ...

I usethe following to KILL all connections to a given DB. Might be overkill for what you need.

CREATE PROC dbo.smKillUsersInDB

@DBName VARCHAR(20)

AS

SET NOCOUNT ON

DECLARE

@ID INT

,@MSG VARCHAR(10)

WHILE 1 =...

Understood about it being a VIEW. I am just impressed with the efficiency. Seems to return data for all indexes much quicker than a DBCC SHOWCONTIG.

Well the standard answer to that question is, "it depends". This is a very broad question. At a minimum, you need to run a combination of sp_who2 and...

If it opens sometimes and not others than I would guess that the second part of the error "timeout elapsed" is the more relevant piece. Are you having performance...

Sorry for asking the obvious, but do you have enough permissions?

Well if the database is already created you can shrink it either through SSMS or TSQL. If you want all future databases to be created at a certain size,...

Understood, but talk about trying to reinvent the wheel!

Any administration of the DB must be done by a means other than normal SQL Server processes, which likely means...