that DMV will only show current information, to capture blocking information the only thing I can think of is sp_blocker_ps008

your running SQL 2008r2 and SQL 2008 see if this helpshttp://msdn.microsoft.com/en-us/library/ms143241%28v=sql.105%29.aspx

One other thing having xp_cmdshell enabled is a risk so as part of your process you should enable and disable it as required

the technet link http://technet.microsoft.com/en-us/library/cc778414%28v=WS.10%29.aspx doesn't say if you need to run this from a DC either

I'm fairly sure you can run the AD command line tools from any machine, workstation or server, thats in the domain not just a DC, you will of course need...

think it could be possible if you enable xp_cmdshell then use a dsmod command

what I would also suggest is that you add the users to an internet deny group rather...

Agggghhhhh 😛

Good question and a very good learning point, thanks

Good luck Anthony, it will all come back to you, what sections did you score less on last time out?

624 is not a million miles away brushing up on 1-2...

SCOM, Solarwinds etc. will all do this kind of thing if there already in your organisation make friends with your Server OS team or person. Other than that there's...

What windows group would the account that runs your sql server agent service be in?

A = None, the account should have the least possible level of privlages, when you use...

There was an artical on this here http://www.sqlservercentral.com/Forums/Topic1063979-1237-1.aspx, i've not tested the script personally so don't know how sucessful it is but the suggestion of setting your DB to single...

Not always a best practice but starting the SQL Browser Service can remove the need to use ports # if your not using 1433, 1434.

If your specifying the port number you don't need the instance name eg,

yourserver, 1433 or 192.168.5.5, 1433 should work

EDIT: made up my own ip address so, not that I...

Koen Verbeeck (6/14/2012)

---

amit_adarsh (6/14/2012)

---

I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create

a key ...

Can feel the love in the room:-D:w00t::-P