SQLCMD

Question

SQLCMD

Steve Jones - SSC Editor

SSC Guru

Points: 736101
More actions
November 4, 2013 at 8:48 pm

#100880

Comments posted to this topic are about the item SQLCMD

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

😀 Easy question - no wait after looking deeper into this shouldn't I expect to see oh wait no it was easy thanks Steve for the QotD

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Easy one, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

logitestus SSCrazy Points: 2928 More actions · Answer 3

I have decided to post this instead of the usual, "nice question" comments...

This might not be correctly on topic but I have noticed something (and most likely this is not a unique phenomenon) - I am not truly interested if I got the "answer" right. I am more interested in if my thought process was running down the "correct" path.

I have been keeping some notes (excuse me while I hype OneNote for a second) on all the QotD's I answer along with the "thought" process behind my answer (I also note if I totally mess up and where I went wrong). In looking through the notes, I have found, the more QotD's I answer, the better my thought process has been.

Interesting note: still screwing up on the correct answer portion. The minute details of an exactly process/procedure/feature still escape me. I still get hit by the little gotcha's. I figure once I have a "proven" track record for understanding/thought process, I will start working on remembering the details.

Revenant SSC-Forever Points: 42467 More actions · Answer 4

Revenant

SSC-Forever

Points: 42467

November 5, 2013 at 10:21 am

#1664193

Really easy - thanks, Steve!

Jeff Moden SSC Guru Points: 1004299 More actions · Answer 5

Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

not sp_configure??

:w00t::-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004299 More actions · Answer 7

SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D

Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Jeff Moden (11/5/2013)
SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.

😎

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Dana Medley SSCertifiable Points: 6764 More actions · Answer 9

Jeff Moden (11/5/2013)
SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.

+1 😀

Everything is awesome!

sqlnaive SSCoach Points: 17437 More actions · Answer 10

Dana Medley (11/6/2013)
Jeff Moden (11/5/2013)
SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.
+1 😀

+2. 🙂

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Never used the SQLCMD before; but I guessed it right; lol 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 12

Nice question. We just went the route of genericizing some scripts using sqlcmd and having access to it within SSMS is a nice feature for developing those. Best of both worlds, IDE for dev, command line for automation, and no xp_cmdshell thank you very much 😀

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 13

Jeff Moden (11/5/2013)
SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.

Sorry, I was lead back here looking for another previous post. Your statement requires qualification Jeff.

Maybe in some environments that is true enough, obviosuly it is in your environment and fo ryou, but in general you're statement is incorrect. Having xp_cmdshell enabled reduces the overall security and auditability of an instance.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Jeff Moden SSC Guru Points: 1004299 More actions · Answer 14

opc.three (11/19/2013)
Jeff Moden (11/5/2013)
SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on all the time. There's no security advantage to turning it off.
Sorry, I was lead back here looking for another previous post. Your statement requires qualification Jeff.
Maybe in some environments that is true enough, obviosuly it is in your environment and fo ryou, but in general you're statement is incorrect. Having xp_cmdshell enabled reduces the overall security and auditability of an instance.

No, its not. It's just wrong for you and what you believe.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)