arch the nice refs are gone, you must have edited the reply

I have one problem with an anymated gif, it appears to only...

I was trying to avoid just that

I'd seen you derive that info from " dRE.GetString(2) " and was hoping to find an equivalent...

you could offcourse use an alert in JobNumber1 final success step, wich launches JobNumber2, ... 

If this job-launching is depending on who/what launched the...

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 ?