Prompt for User Input in SS2K QA

• Jim Underwood

  Mr or Mrs. 500

  Points: 593

  More actions

  May 26, 2004 at 10:19 am

  #102037

  Is there any way to prompt for user input in a SQL script running in SQL Server 2000 SP3 Query Analyzer?

  I'm looking for something like the VB function InputBox().

  This is for use by DBA, not end-users.  I'm developing some templates for DBAs that need for the DBA to make a decision.

  Best Regards,

  Jim

• May 31, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 735912

  More actions

  May 31, 2004 at 9:18 am

  #508412

  Not that I know of, but you could use VBScript and SQL-DMO to execute quries for a DBA.