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...

just need to add in the nessesary date parts

select CONVERT(NVARCHAR,(DATEPART(HOUR,getdate())))

select CONVERT(NVARCHAR,(DATEPART(MINUTE,getdate())))

What do you get when you run DBCC CHECKCATALOG in the DB?

You need to group by ALL columns which are not contained in an aggregate function.

This is cleaver marketing, they are not actually asking for the test engines,...