Thanks everyone, I have taken MyDoggieJessie's idea's with Scot's amendments, it works well and is now live in the prod environment.. 🙂

Ta

David

Hi,

I have had locking issues with the xp_cmdshell executing within the uncommited transaction so I have moved the catch up the script. I guess I could nest try/catch blocks which...

Grant makes a good point about using COPY_ONLY and Ed's point about data security is a very valid one in this digital age. Follow their advise..

Hi,

I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the user which starts...

I would start by adding tempdb data files inline with the current wisdom from SQL Product Support which is to have 1 file per core up to 8 cores, over...

Another shot in the dark.. 🙂

How many Tempdb data files do you have? Using current wisdom on this you should have eight. I have seen your symptoms on a server...

I came across this article a while back. It might help

http://www.sqlskills.com/blogs/paul/example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-io-errors/

Ta

David

Hi,

My first step would be to set up a Central Management Server. There is a great article on it here:

http://www.brentozar.com/archive/2008/08/sql-server-2008s-new-central-management-server/

Then I would execute sp_spaceused against your group of servers,...

Hi,

something like this should work;

select [Year],

[FinanceValue-2014],

[FinanceValue-2013],

[FinanceValue-2012],

'FinanceValue Variance' = [FinanceValue-2014]-[FinanceValue-2013],

'SumofVariance' = CONVERT(MONEY,(([FinanceValue-2014]-[FinanceValue-2013])+[FinanceValue-2012]),2)

from Finance

Ta

David

Hi Dave,

My first question would be, whether you need all of the tables within the database, it maybe better to isolate a number of key tables then script those to...

Lowell and Keith,

Thanks for your input, I have modified my proc using Lowell's last script and it performs well.

Thanks for your time

Ta

David

Hi Keith,

I'll get on and read the artical.. 🙂

In the meantime I have been working with this as an example. The first row is correct, second has no order number,...