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...

i take it in the branch they DB's have the same name?

on the local server where two copies are they are differently named?

has the report been reconfigured so that when...

backup your SSRS encryption keys first,

backup your SSRS databases

then either detach/attach or copy/restore or another means of getting the DB from Server1 to Server2

reconfigure SSRS to point to the new...

ravisamigo (3/30/2012)

---

Thanks Henrico for your information.

Please advise me on the below.

Can we apply one licence key for more than one SQLServer2008 R2 developer installation?

or

Can we apply one licence key for...

Junk mail is typically sent via SMTP as it doesnt require a valid email to send from which is why you are seeing this even if you are using a...