I think the question(s) that you have missed is - Do you require a point in time restore? What is your recovery point objective on that datasbase?

If you have...

Roy gave the answer. This is expected behaviour if the login is not granted view definition

Many thanks for your comment - I had misinterpreted the clustering as being the same. Now that makes sense.

Thank you for your re-direction to another resource (much like BOL). I was just after a quick opinion as they seemed to contradict themselves, but nevertheless.

BOL -

Object owners can grant permissions on the objects they own. Principals with CONTROL permission on a securable can grant permission on that securable.

Grantees of CONTROL permission on a...

How about using SP_MSFORACHTABLE 'EXEC SP_SPACEUSED [?]' and putting into a temp table/variable and running a select on that with a REPLACE on the size columns

The version that you are running may well have a different query plan. You may have an issue with parameter sniffing.

Check the account that the SQL Agent is running under and check that it has permissions to the server that you are trying to query.

I may suggest views and leave the base data alone. This would cut down on project time and would only need to update the references in the Sprocs, functions, etc.

Could you not create a DML trigger(s) on the table to stop any inputs that you don't require? There would be an overhead but you would need to weigh...

AS long as your db has not got any other activity on it that is required then the restore is fine. If not and other activity since or during is...

PearlJammer1 (5/16/2013)

---

I am doing some practice exercises from Microsofts training kit for 70-432 Implementation and Maintenance 2008(written by Mike Hotek) and am running the following code from page 148...

You should be able to use GETDATE()-1 of you are not worried about the time of day. If that does not work look at ...

in SQL - select CONVERT(DATETIME, DATEDIFF(dd,...

If you have plenty of disk space. It grows quite quickly.

thanks for all your suggestions