euh ... got a question

What if you have the image in a dataset

How can you figure...

SELECT

 ll.pid AS PID,

 la.oic AS OIC, 

 lo.NAME_1 AS NAME1,

 lo.NAME_2 AS NAME2, 

 lo.ADDRESS_1 AS ADD1, 

 la.set_id AS SET_ID,

 (la.gen_impr_net + la.gen_land_net) AS Assesment

FROM OWNERS lo INNER JOIN

 land_legal ll ON lo.EQUITY_ID = ll.legal_id

INNER...

thanks for the feedback

sorry for the fase ref.

try :

ALTER DATABASE [Dorian Event Archiver] Set single_user WITH ROLLBACK IMMEDIATE

go

You _will_ have to follow the procedure described in Allan Cui's article !

try

DBCC rebuild_log ('Dorian Event Archiver', 'yourdrivepath\Dorian Event Archiver_Log.ldf')

?

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