XP_cmdshell Execution in SQL Server 2005 / 2008

In this video Brian covers how to use xp_cmdshell in sql server 2005 / 2008.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Don Weigend on 1/21/2009

I enjoy these short "to the point" training videos since they cover a very specific topic to a deeper level than just telling me about the topic. Keep up the great work!

Marc on 1/21/2009

Good, clear and thorough. Thank you

R James Reichard on 1/21/2009

AGAIN, I like the short and to the point video tips. Great job!

anthony on 1/22/2009

Great video - short and full of good advice.

Tcharly Florestal on 1/22/2009

Straight to the point.

Jason Martinez on 1/31/2009

Explained beautifully

Taariq on 8/22/2009

Very clear and simple to understand :)

aks on 10/29/2009

Liked it. Informative.

A Alagu Ganesh on 1/20/2010

Good

A Alagu Ganesh on 1/20/2010

good

Lamar Marsengill on 7/16/2010

GREAT information!!! Thanks.

Phillip on 8/6/2010

What about turning it on within a sql stored procedure then execute a command and immediately turn it back off within the same stored procedure? Would you consider that a fairly secure use of xp_cmdshell?

Matt on 8/6/2010

I really enjoyed this video. Wouldn't mind seeing another going over some real world scenarios for use of it.

stan on 8/6/2010

Your presentation video was very clear. The fonts were sharp and not blurry. Thanks.

ASHISH KURIYAL on 8/6/2010

very good. specially live example of proxy account problem in 2008

Richard Ray on 8/7/2010

Very complete, no missed steps, good coverage given to essential security considerations.

Spike Kelly on 8/9/2010

Excellent !

ivan on 8/18/2010

god video!!

Steve Culshaw on 8/25/2010

Great run through

Eric on 4/29/2011

Very helpful video. I'm familiar with xp_cmdshell, but didn't know it could be enabled/disabled for particular users.

shiv on 6/28/2011

ok

Edward Pochinski on 6/28/2011

Nice demo showing the proxy creation level.

Michael on 6/28/2011

Wooooo!

Prashant Thakwani on 6/28/2011

Good one

Lamar Marsengill on 6/29/2011

Great info

Carlos B. Vasquez on 7/4/2011

I don't need to go to books online for a better explanation of how to use xp_cmdshell features of SQL Server

Jason Harris on 7/18/2011

Great succint explanation of XP_cmdshell in 2005.

Maurice Ivory on 11/16/2011

If you don't need it, then keep it turned off!!