This may interest some people, I think the video that goes with it is available on the PASS website http://www.sqlpass.org/, the artical goes into situations when you would use the...

The comment is cut and pasted from the DAC section of BOL also, i'm confused :ermm:

Do you mean the SQL Browser Service?

The most restrictive option only applies if you have a deny and a grant to the same permission

Koen Verbeeck (6/13/2012)

Good remark. The admin could have specified the...

Couldn't the administrator initiate the DAC with a specific port number?

Edit: agree with the earlier comments from Koen good question

Uninstall and reinstall it is the advice i'd give you

Edit: also plan your installation a little better than just clicking setup.exe and selecting the defaults if this is going to...

I was not aware of that Jeffrey so thanks for the information I will look into it but thinking out loud doesn't setting up SPN's require domain admin rights in...

Guessing its restarting the SQL Server Services

wesley sneijder

Bumruff

Do you have more details of the error; my guess without any further details would be that the data access layer requires kerberos delegation

If you need the information for some kind of compliance auditing purposes i'd maybe recommend a third party tool, i've heard idera do one quest or redgate may offer similar...

As above you should not use full recovery unless you are backing up the transaction log, to shrink the log file as stolen from bol

USE AdventureWorks2008R2;

GO

-- Truncate the log by...

Looking at what they've done I can (vaguely) remember sampling a flat cap and a gold digger while drinking in your fine town before partaking in the watching of association...