also forgot to upload this ebook as well

when you open that book the title page contains a URL to a library, might be worth searching there, but not managed to find an unleashed one for SSIS...

you just need to hit the drop down arrow, which appears when you hover over the report, then you can modify a number of things and edit the actual RDL...

what account is being used as the data source account?

from what you are saying it seems like its using windows authentication with the users account?

this is the most secure way...

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