• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Query Analyzer - Prompting for a value

Hi Folks,

I need to write a script which will prompt the person running the script for their name.  Is this possible to do at all?

Thanks for any help,

Stuart.
0
Stuart_Johnson
Asked:
Stuart_Johnson
1 Solution
 
nmcdermaidCommented:
Not in query analyzer.

Thwe simplest way I can think of to do this is:


-A DTS package, but the user will require DTS runtimes on their PC

or

-A batch file (which can prompt for a name then use OSQL to run your script). Again they need OSQL installed

OR

-VBScript which is has slightly more sophisiticated input and usually all the libraries required are installe by default on any windows PC


0
 
imran_fastCommented:
No query analyzer will not prompt for any user input. try using any other frontend application for that.
0
 
Stuart_JohnsonAuthor Commented:
Thanks for the info guys.  I figured as much.  I just needed confirmation to prove it.

Stu.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now