SQL Mgmt Studio, External Tools, Arguments availalbe

Question

Post reply

SQL Mgmt Studio, External Tools, Arguments availalbe

Jim Collet

Old Hand

Points: 395
More actions
December 5, 2006 at 5:05 pm

#175174

In SQL 2000 QA, i could set up a custom tool to call an exe and pass arguments, the two i was most interested in were Server and Database of the connection.
In 2005 Mgmt Studio, there is a similar feature called External Tool and it does have arguments, but not the 2 i am looking for. is there a way to add custom arguments (i am thinking there isnt), or some other way to call an exe passing the db and server name?

Viewing 5 posts - 1 through 4 (of 4 total)

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

Robert Davis One Orange Chip Points: 28027 More actions · Answer 1

You should be able to simply pass in the arguments as you would if calling it from the command line.

For example, if I can call my application from the command line like this:

MyApplication.exe /S:ServerName /C:ConnectionString

Then in the arguments box, I would put: /S:ServerName /C:ConnectionString

As a test, I added a call to execute Remote Desktop using a saved connection file. In the arguments box, I added the line below, and it worked like a charm.

"C:\Documents and Settings\dba\My Documents\ServerName.rdp"

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Bhudev Prakash SSC-Addicted Points: 471 More actions · Answer 2

U can do it better than SQL 2000

1. Add Your External Tool

2. Give Title

3. Fill Command

4. Check Prompt for Arguments

5. U can use "Use Output Window" for your convenience.

When U'll run Ur external Tool then give your all arguments. No matters there are two or more than two.

Enjoy!

Robert Davis One Orange Chip Points: 28027 More actions · Answer 3

"Use Output Window" is greyed out in my SSMS. What does that do?

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Jim Collet Old Hand Points: 395 More actions · Answer 4

i am trying to emulate the options that are available in 2000QA for 2005 ssms.