No worries

Thanks for your advice John

My colleagues are visiting the sites anyway to perform training and I though it would save time - potentially it wont though.

Can I not just attach the mdf to an...

True - I should stop taking the easy way out! -S switch you say....

I really only want the data from the PC - and to make sure it isnt accessible...

Thanks John

I've just tried it using a batch file to stop the SQL Service and then copy the mdf and ldf to a datastick which worked fine

Thanks

Craig

Thanks for this - however when I'm testing it I get the an error stating

Named Pipes Provider could not provide a connection to SQL Server

SQLcmd: Error: Microsoft SQL Native...

Hi John

It does have the same name

Unfortunately they are not all in the same place

I have a team of 10 (non technical) people who are going to visit each location with a memory stick to remove...

My bad! AWE shouldn't have been on!

Must have clicked it by mistake and hadn't noticed - doh

Thanks anyway

Thanks, I'll take a look now.

I'm just using the filter menu in report builder, and selecting the relative date of 'yesterday', I've also tried 'n' day ago - but get the same result.

As you might...

I think this it

="To : " & Parameters!LastOrderDate.Value

Thanks

Doh!

No I wanted a date 1 year and 8 days ago...

learning all the time, just not quick enough eh 🙂

This is what I was meant to do...

DECLARE @startDate datetime;

DECLARE @enddate...

Thanks for this

If I run this

DECLARE @startDate datetime;

DECLARE @enddate datetime;

SET @startDate = dateadd(year, -8, dateadd(day, datediff(day, 0, getdate()), 0));

SET @endDate = dateadd(year, -1, dateadd(day, datediff(day, 0, getdate()), 0));

SELECT SUM(transactionamount)

FROM...

Thank you.

My sql is obviously running for a date range that is equal to or greater than the specified date, so when I run the script for 1 year ago,...

I'm currently using SQL Server 2005 and SQL Server Express 2005, is there anything available for this version?

I'm not sure they'd go for a SQL upgrade at the moment.

Thanks

--Edit, or...