I'll see what I can do ...

I'm not that the office until Jan 5th ...

- Did you follow best practices by taking a backup before you moved the datafiles ??

- if you did perform a clean shutdown and there weren't any ongoing transactions, you...

- you should check "c:\program files\microsoft sqlserver 2005\"

there should be a mssql.1 folder, that one contains a file called "errorlog" if you post its content, we may be able to...

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005:

- http://msdn.microsoft.com/en-us/library/ms143799(SQL.90).aspx

also keep in mind you need to enable TCP/IP on your sqlserver instance (server configuration manager) and restart the sqlinstance for it to be able to allow connections over tcp/ip

even better, BOL now contains more info on DBCC statements then ever !

No yet for all, but for the most of them you'll ever use.

no doubt about it, you should fix the db in sql2000 !

btw: what service pack are you on (sql2K) ?

Keep a copy of the backup of the corrupted database !...

it may not only be the left join, but I guess most of the waste time will be the correlated join predicate !

apparently this can be an indexed item, but...

Well, the instance didn't failover, but it dumped like hell.

SQLErrorlog file stating ".... a lock it does not own .... " which IMO is a symptom for the lock manager...

bodhilove (12/23/2008)

---

Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2...

What service pack are you on ?

(should be at least SP1, better SP2, best SP3 😉 )

Select @@version

SQL Server 2005 Books Online (November 2008) topic "Monitoring Database Mirroring "...

Hey.... I've been referenced to :w00t: Thanks Barry 😉

The code is pointed to in the "How to use this article" section !

the word solutions has the hyperlink !....

Best practice is to keep the scope of a trigger as small as possible.

All executed by a trigger is in the same transaction as the original query (insert/update/delete) !

Meaning,...

Can you run this and post the results ?

/*

* DB Mirroring : followup

*

*/

/* show mirrored databases and their mirror-state */

Select db_name(database_id) as dbName

, *

from sys.database_mirroring

Where mirroring_guid is...

Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.

(make sure you have the latest version of BOL !)

-SQL2005...