GRANT ALTER ON SCHEMA::dbo TO db_viewcreator

This will say they have permission to alter the schema, but SQL needs to know what it can alter and as you have only given...

you need to grant alter on the schema that you want the view to be created in to the role. if you have just given CREATE VIEW to the...

create the role then grant CREATE VIEW to the role this will also imply ALTER as well

created a condition and policy on my test machine and its working as intended using a schema = 'dbo', screen shot shows the violation

this is the script, just need to...

also take a look at ApexSQL Doc

another way would be to create a custom DDL trigger for the CREATE_PROCEDURE event which reads in the XML details of the procedure creation and checks the schema XML node....

by default everything will be created in DBO unless one of two things, you explicitally give it a different schema or your default schema is different than dbo on the...

also try here, http://bit.ly/HppLBX

You tried this?

http://support.microsoft.com/kb/2387686

changing the code to this works without dividing cpu_ticks with ms_ticks

SELECT

record_time,

SQLProcessUtilization,

SystemIdle,

100 - SystemIdle - SQLProcessUtilization AS OtherProcessUtilization

FROM (

SELECT

record.value('(./Record/@id)[1]', 'int') AS record_id,

record.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]', 'int') AS SystemIdle,

record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int') AS SQLProcessUtilization,

record_time

FROM (

select...

you would have to build in some logic to the parameters like

if @minage < @maxage do nothing

if @minage > @maxage set @minage = @maxage, @maxage = @minage --needs to be...

i think something a bit more sinister is at play here as I did just that Rob and got a Eventtime of 2012-04-24 16:33:383.443 so I am thinking something is...

from this url sys.dm_os_ring_buffers is only there for backwards compatability and is not guaranteed, so what is the new DMV replacement for this DMV?

the sys.dm_os_ring_buffers table stores the past ~4 hours worth of CPU data so its just a case of running this once every 2 hours and loading it into a table...

i would look at creating a calendar table with the dates in for start and end of month, that way you can do dateparts on GETDATE to get the month...