With Project_view(WorkId,Name,StatusCurrent,ActiveProcess,ActiveGateDate,ActualStartDate,ActualEndDate)

As

(

Select distinct vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vp.process_name as ActiveProcess,vw.actual_start_date as ActiveGateDate,vw.actual_start_date,

vw.actual_end_date

from view_work vw INNER JOIN View_Process vp ON vw.process_id = vp.process_id

join View_Work wv on wv.active_gate =...

You can go on http://www.microsoft.com/store to get MS's current list price.

UK price for 2008 R2 Enterprise is

1 CPU is £23,850,

Server + 25 CALS is £10,780

CAL's arn't listed but from...

wrap the second select in another CTE then query that CTE using datediff functions on the second date columns DATEDIFF(DAY, DefineStart, DefineEnd) AS DefineDuration

yes its just the backups. SQL wont let you delete an LDF if its in use and attached to a database so you will know if your trying to...

Bill and Ben the flower pot men

can you post the full stack dump? mean while script the db and transfer the data.

I am guessing that there will be something in the metadata which it doesn't like on 2008.

Can you script the database and run the script on 2008? If so...

Mr Bean

in the SET @diskpath statement

SET @diskPath = 'C:\TransactionLog\Production_Log'+ CAST(YEAR(GETDATE()) AS CHAR(4)) + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + CAST(DAY(GETDATE()) AS VARCHAR(2)) + put hours calculation here + put minutes calculation here +...

the below will give you a good starting point, you will need to modify it to change the order of the eventtime and get it to do some aggregates to...

Has it logged anything in the SQL error log?

Doh, sorry it was the DMV one I had not the perfmon, any how, both still very good.

I had a copy of this on A2 supplied by Quest in a old job but couldnt take it with me and never found it again, good find.

Number of options what could do this are Replication, Log Shipping, SSIS, Custom backup / restore automation

All depends what you need to do. If its only a sub set...

I think your with the majority of everyone else I know, UAC...