USE SP_IntranetMySites_WebApp ---assuming databasename

DBCC CHECKDB

Look for output to determine table name or index name.

if objectid is returned...

select object_name('objectidreturnedinerror')

dbcc checktable ('tablename')

see books online for dbcc commands... repair_fast, repair_rebuild, repair_allow_data_loss.

Sometimes just...

You're in for a tough journey if you want to run existing dts packages in 2005... let alone a x64 environment.

All depends on complexity and exteral calls.

There is the package...

Every single production database of our's is set with 'sa' as the database owner. Certainly at all cost avoid making owners a user account ( even more so a...

Also, in activity monitor... last batch column. Or right click on the session and view details.

grab the spid and execute

dbcc inputbuffer (spid)

perhaps just a hung connection that is inactive?

Only thing I can suggest is starting a Profile Trace filtering on spid, or login, or whatever is unique and capturing. Unfortunately, this won't tell you what they did......

to make exact copy of default instance..

install named instance...

restore master db, other sytem dbs, followed by user dbs on name instance

Well, quick answer is yes...

install a named instance of SQL 2000 on a server with an existing instance and define where you want files to be placed, whichever disk partition...

Search around a bit through the user sites / blogs, but as I recall, distributor is the critical component here to have as 2005. Someone out there has a great...

I see Markus' query returns NULL... which I assume you don't want... and is handled here below with the inequality B.YN <> C.YN in the derived table:

Similar issue here... our developers went to town on table and index partitioning.  Their first solution was a one to one ratio of partions to files.  I had them strike...

Any chance there is a named instance that needs to be referenced?  I forget that all the time...

I certainly agree Joe!  Our test and dev environments are 32, and production 64... never-ending issues with linked-servers to Oracle crashing our SQL instance. The latest is database mail working...

You may also want to verify you are running sp2.  As I recall, I saw the same issue here and it was fixed with sp2.  Sorry, I was unable to...

I have to ask... is there more complex logic that needs to be performed other than SELECT from table2?

Why not a JOIN as such:

SELECT t2.* FROM Table2 t2

JOIN Table1 t1...

I don't think I've seen Clear Trace on anyone's list...

I use it every couple of months... very easy to use, and provides very valuable information regarding Prolile trace files

ClearTrace imports SQL...