Basic SQLCMD Utilities

  • Anipaul

    SSC-Insane

    Points: 24681

    Comments posted to this topic are about the item Basic SQLCMD Utilities

  • Lokesh Vij

    SSChampion

    Points: 10836

    Thanks Paul for posting a nice question on SQL 2012. I referred this link and marked the correct answer 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Carlo Romagnano

    SSC-Insane

    Points: 21970

    Good to know, but never used!

    😀

  • Rich Weissler

    Hall of Fame

    Points: 3235

    I thought those three utilities were deprecated in SQL 2008. They don't seem to exist in SQL 2012. *confused*

  • This was removed by the editor as SPAM

  • Nakul Vachhrajani

    SSChampion

    Points: 10216

    I did not know about these, so this question was a learning experience. Thank-you very much, Paul!

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • call.copse

    SSCoach

    Points: 17186

    I had not realised there is literally a utility for everything, so I guess that's handy to know. I'd used sqlcmd and bcp but it's always good to learn of other possibilities.

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Badly worded question but with some research was able to get the three most likely answers that were either deprecated in 2012 or non-existent in 2012!

  • Rich Weissler

    Hall of Fame

    Points: 3235

    (Bob Brown) (2/22/2013)


    Badly worded question but with some research was able to get the three most likely answers that were either deprecated in 2012 or non-existent in 2012!

    Yes. 🙁 But the voices in the back of my head were reminding me that there were features of Profiler and Trace which were really deprecated in SQL 2012. Couldn't remember the details before my first cup of coffee. 🙂

    So apparently Profiler for Trace Capture and Trace Replay are deprecated. *shrug* I'm under the impression that Trace is deprecated. I've only used Profiler as a lazy dba's access/tool for trace. What else will Profiler be used for? *curious*

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Nakul Vachhrajani (2/22/2013)


    I did not know about these, so this question was a learning experience. Thank-you very much, Paul!

    same here 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • TomThomson

    SSC Guru

    Points: 104773

    Rich Weissler (2/22/2013)


    (Bob Brown) (2/22/2013)


    Badly worded question but with some research was able to get the three most likely answers that were either deprecated in 2012 or non-existent in 2012!

    Yes. 🙁 But the voices in the back of my head were reminding me that there were features of Profiler and Trace which were really deprecated in SQL 2012. Couldn't remember the details before my first cup of coffee. 🙂

    So apparently Profiler for Trace Capture and Trace Replay are deprecated. *shrug* I'm under the impression that Trace is deprecated. I've only used Profiler as a lazy dba's access/tool for trace. What else will Profiler be used for? *curious*

    It isn't deprecated for use with Analysis Services - and that's about all.

    Tom

  • TomThomson

    SSC Guru

    Points: 104773

    (Bob Brown) (2/22/2013)


    Badly worded question but with some research was able to get the three most likely answers that were either deprecated in 2012 or non-existent in 2012!

    I never did work out what the question was supposed to mean until after I had answered.

    Did it mean three things that were deprecated in 2012 but not in ant earlier release? That is the most likely meaning of the wording, but there aren't three such things in the list provided to chooose from.

    Did it mean three thatings that were deprecated in 2012 and perhaps also in earlier releases? That stretches the meaning of "from" rather a lot, but if the above meaning was wrong that seemed most likely. There are plent such things, but there are not three of them on the list.

    It didn't occur to me at all that the question wasn't about items in 2012 that were deprecated, but about items that weren't in 2012 at all. A very great stretch of the word deprecated - it's difficult to believe that anyone could write "deprecated from" when they meant "discontinued in" (although that appears to be what's happened here).

    So I picked profiler (which sot of fits the apparent meaning, since in 2012 it's deprecated for use in connection with anything other than analysis services) and picked a couple of others (which don't) at random so that I could see the answer.

    I do think the wording is awful, if it had just said "discontinued in" insead of "deprecated from" it would have been a much better question. And I might even have got in tight :w00t:

    Tom

  • ldorian81

    SSCommitted

    Points: 1694

    Nakul Vachhrajani (2/22/2013)


    I did not know about these, so this question was a learning experience. Thank-you very much, Paul!

    +1

    Regards
    ld

    Stoke-on-Trent
    United Kingdom

    If at first you don't succeed, go to the pub and drink away your current thought plan.

  • Mike Hays

    SSCommitted

    Points: 1871

    I too thought the wording was little off.

    makepipe Utility - This utility has been deprecated in Microsoft SQL Server 2005.

    http://msdn.microsoft.com/en-us/library/ms162804%28v=sql.90%29.aspx

    readpipe Utility - This utility has been deprecated in Microsoft SQL Server 2005.

    http://technet.microsoft.com/en-us/library/ms162818%28v=sql.90%29.aspx

    odbcping Utility - This utility has been deprecated in Microsoft SQL Server 2005.

    http://msdn.microsoft.com/en-us/library/ms162756%28v=sql.90%29.aspx

    However I still like the question, because it forced me to learn something new. Again, the idea of the question was excellent, but the wording, not so much.

    Mike

  • EL Jerry

    SSCertifiable

    Points: 7053

    Good question to end the week.

    Saludos,

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

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

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