Nice question, thanks. Missed that the rebuild would re-enable the index, duh!

SQL Server Installation Centre (should be on your start menu) has a 'Installed SQL Server features discovery report' option in the Tools menu.

I think you've answered your own question there 🙂

A way around it would be to use dynamic sql...

Interesting, it should be able to be granted at the database or server scope!

Don't think compatibility level should affect it, and the VIEW DEFINITION securable was introduced with SQL 2005...

Hi, what SQL are you running at the moment and what error are you getting?

Thanks

Agreed, shrinks should definitely be avoided except in certain circumstances.

In answer to you questions:

Shrinkdatabase attempts to shrink all files, but only returns data for those that were actually shrunk.

Values are...

Hi, yeah CountDistinct will do that, if every value in the column is the same, which it looks like it is (year?).

One solution would be to change the column in...

Hi, the securables list shows objects by default - you need to search for database-level permissions.

(Search... All objects of the types... select database.. ok)

sp_helpprotect doesn't show information for all securables...

Hi, how is it not working - error, wrong count, something else?

Cheers

Gaz

Hi,

At this point, it might be easier to tell us exactly what date you're trying to get from the table 🙂

Kingston's solution seems to correct to me but if that's...

Your ascending ordering in the subquery means they're logically the same. If you were ordering by date descending then that would be a different matter.

Looking at your table structure, I'm tempted to agree with those that have said you need to UPDATE the table rather than INSERT.

Is the data already there and you just...

You're not providing a value for OrganizationID in your insert statement, and it's a not null field.

Unless it's an identity field the insert will fail.

Need something like this:

BEGIN

SET @sql =...

Hi Ben,

Yep, understood what you meant after I thought about it a bit.

You can't average the value for a given page - the value at 1 hour isn't comparable to...

Is it?

Edit: actually, I see how...