64 bit

No experience

I also found this in my archive :

-- DBCC rebuild_log (dbname [, filename])

-- -- -- -- Create new database with same name, stop SQL Server, replace the MDF file from...

did you check usp_AttachDBWithMissingLogFile ?

http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp

What if you use EM to attach the db and you fill out the logfiles ?

from BOL :

The DIFFERENCE function compares the SOUNDEX values of two strings and evaluates the similarity between them, returning a value from 0 through 4, where 4 is the best...

did you try sp_attach_single_file_db ?

from BOL :

Usage Considerations

Before enabling AWE, consider the following:

• When awe enabled is set to 1, instances of SQL Server 2000 do not dynamically manage the size of the...

here's a good article :

http://www.sql-server-performance.com/awe_memory.asp 

HTH

here's the test result :

Msg 8618, Level 16, State 2, Line 1

The query processor could not produce a query plan because a worktable is required, and its minimum row...

I like the new SET option

there ara SAN systems that have an archiving option, meaning datafiles not used for x time migrate to tape until called for.

I've only seen the concept-picture, but have never seen...

- what kind of transaction are you using ?

- what kind of connection isolation level are you using ?

- what kind of lock-mechanism is active when the sp is being...

just a sidenote :

keep in mind ssc is running out of memory because we are !

so you could get this :

create proc spc_xxx

as

begin

set nocount on

-- first table is CUSTOMER table that have 2 field (id_cust,id_support)

-- second table is SUPPORT table that have 3 field (id_support,...