Information about drop or detach db you can find in the SQL Server Default Trace.

Execute and post the result:

SELECT state_desc,is_auto_close_on

FROM sys.databases

WHERE name = 'DbName'

Rewrite the query or maybe creating a computed column on substring(dsn, 7, 5) and creating index on that column will help this query.

srobinson 596 (2/21/2013)

---

I have a table where I am unable to run a simple select statement from. I ran DBCC Checktable on it and got the following back:

DBCC results...

Which mirroring operating mode do you use?

eg.: http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/

http://msdn.microsoft.com/en-us/library/ms177429.aspx

"Note that if you restore a SQL Server 2005 or SQL Server 2008 database to SQL Server 2012, the database is automatically upgraded...."

ostress http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/02/01/precision-performance-for-microsoft-sql-server-using-rml-utilities-9-0.aspx

SQLQueryStress http://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/

IsSort tell SSIS that a source is sorted eg: via order by or external program that generated a file.

Sort transformation is performing sort.

So if you tell SSIS that you have...

I don't know about what you ask?

So "A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core"

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

Use SQLIO eg: http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/

I had the same or very similar problem, a COM object on x64 ported from sql 2000 and helped installing management studio, still don't know why 🙂

According to http://msdn.microsoft.com/en-us/library/ms175475.aspx

"

A database user for which the corresponding SQL Server login is undefined or is incorrectly defined on a server instance cannot log in to the instance. Such a...

Or try http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/ need no instance shutdown or reset.

Use mirroring. Not the SQL 2005 but the idea is the same eg: http://www.solidq.com/gl-en/News/Pages/Case-Study-Payvision-Migrates-to-SQL-Server-2008-with-Only-4-Seconds-of-Database-Downtime.aspx