Hi Steve,

The download file is 500 Mb by the way. You have 500 Gb which would indeed be a chunky download.

A quick update on this:

We have a query that's using a bad query plan.
Have tried setting up a process to remove the plan from the plan cache...

I got this error when importing from a flat file to an SQL table. The table had an identity column and I had the 'Keep Identity' checkbox checked. When...

Hi Jeff,

I'm with you regarding the adding more disk space but It's not my decision and I have to explore the options. I also think it's complicated by the fact...

Hi Luis,

We're freeing up 25% of the space as we're removing a lot of image data but it's still a big database (115gb) with 150m rows of data across 3000...

By linked server I'm on about a linked server object set up on SQL Server with:

Exec sp_addlinkedserver N'<server name>', N'SQL Server';

EXEC sp_addlinkedsrvlogin '<server name>'

The view is set up on sql...

...scratch that... I've just recreated the connection from excel and it's all good!

Thanks very much for the replies. You've helped me see things a little clearer.

The whole point of implementing the trigger was to update the 'Total Machine Hours' field on the...

Setting up the users as system administrators under server roles has solved this problem.