this might be a good place to start, granted its for 2008, but the principles are the same

also a primary key cannot contain a NULL value, but a UNIQUE constraint can contain 1 row which is NULL

You might be lucky to get all that in one tool.

From what I remember, user account creation etc is not captured in DM, Spotlight, Foglight or SQLMonitor.

I appologies to Idera...

kopajb-884292 (3/6/2012)

---

I am considering to purchase a monitoring tool for our SQL environment. At the moment, I've narrowed my choices down to 3 tools namely, (1)SCOM 2007 R2 with SQL...

i have attached an ebook on SQL injection.

what is actually happening? are you loosing tables? are you sure its coming from the website? are you running profile to see where...

+1 on the AD groups, by far the best way to manage SSRS security

To add on to what Jack already said, if they do not warrent the need to be...

you would also want to exclude any spid below 50 so that no system processes are picked up as well which could take longer than X seconds

this will help to capture the deadlock graph 24/7 incase one happens during the night

create a table to store the xml

CREATE TABLE DeadlockDetails

(

ID BIGINT IDENTITY(1,1),

DateCollected DATETIME DEFAULT GETDATE(),

DeadlockGraph XML,

CONSTRAINT...

Just need to pass in the schema name along with the object name a bit like

sp_helpindex 'ddl.ddlchangelog'

what is the status of the database?

select state_desc, user_access_desc, is_read_only from sys.databases where name = 'AdminMig'

select

name

from

cats

union

select

'refund'

something like this?

also isn't this the same as this post here, if so there is no need to cross post

do you have to use a ## table, could you not just use a # table?

you would want to build a query up which looks at sys.dm_exec_requests and cross applies it to sys.dm_exec_sql_text where the sys.dm_exec_requests.total_elapsed_time is greater than the number of seconds what you...

take a look at this link http://msdn.microsoft.com/en-us/library/ms188902.aspx, should give you what you need

maybe this url will help here