"Joe" <j**@aol.com> wrote in message
news:%238auQX65FHA.3876@TK2MSFTNGP09.phx.gbl...
> Does Management Studio have a Macro Language or Automation object I can
> attach to through .Net to automate some repetitive tasks through the GUI?
>
> My biggest complaint about Management Studio is the inability to open a
> .sql file without respecifying my connection information each time.
>
> One suggestion I was give was to use the Insert File as Text, but that's
> the same thing as it inserts the file into the middle of my current query
> window and then when I save it has no idea which file I am really editing.
>
> Another suggestion was to use project and create multiple connections.
> This does not work because: (1) you can only have one connection to each
> sever.  If I need to connect to multiple databases on the same server, I
> cannot. (2) Each SQL script can only be associated to one and only one
> connection object.
>
> So what I would like to do is intercept the File Open Event (or whatever
> it is called) and replace it with my own logic.
>
> Any ideas?
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23EcXHT%235FHA.2600@tk2msftngp13.phx.gbl...
> There are several ways to do this without using Management studio.  One is
> to use SQLCMD and the other is SMO.  You can find more details about both
> in BooksOnLine.
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "Joe" <j**@aol.com> wrote in message
> news:%238auQX65FHA.3876@TK2MSFTNGP09.phx.gbl...
>> Does Management Studio have a Macro Language or Automation object I can
>> attach to through .Net to automate some repetitive tasks through the GUI?
>>
>> My biggest complaint about Management Studio is the inability to open a
>> .sql file without respecifying my connection information each time.
>>
>> One suggestion I was give was to use the Insert File as Text, but that's
>> the same thing as it inserts the file into the middle of my current query
>> window and then when I save it has no idea which file I am really
>> editing.
>>
>> Another suggestion was to use project and create multiple connections.
>> This does not work because: (1) you can only have one connection to each
>> sever.  If I need to connect to multiple databases on the same server, I
>> cannot. (2) Each SQL script can only be associated to one and only one
>> connection object.
>>
>> So what I would like to do is intercept the File Open Event (or whatever
>> it is called) and replace it with my own logic.
>>
>> Any ideas?
>>
>
>

"Joe" <j**@aol.com> wrote in message
news:%23fw1nMG6FHA.2676@TK2MSFTNGP15.phx.gbl...
>I think I keep missing my target on this... I am NOT looking to manage SQL
>Server - there are loads of options out there.  I am looking to Mange /
>Automate / Customize the way Management Studio behaves.   I think it is a
>great new tool, but incomplete and annoying in some ways....
>
> The example I gave about file open is just that - an example.  It's not
> crippling and there are probably many workarounds - but they are just that
> workarounds, not solutions.
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23EcXHT%235FHA.2600@tk2msftngp13.phx.gbl...
>> There are several ways to do this without using Management studio.  One
>> is to use SQLCMD and the other is SMO.  You can find more details about
>> both in BooksOnLine.
>>
>> --
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Joe" <j**@aol.com> wrote in message
>> news:%238auQX65FHA.3876@TK2MSFTNGP09.phx.gbl...
>>> Does Management Studio have a Macro Language or Automation object I can
>>> attach to through .Net to automate some repetitive tasks through the
>>> GUI?
>>>
>>> My biggest complaint about Management Studio is the inability to open a
>>> .sql file without respecifying my connection information each time.
>>>
>>> One suggestion I was give was to use the Insert File as Text, but that's
>>> the same thing as it inserts the file into the middle of my current
>>> query window and then when I save it has no idea which file I am really
>>> editing.
>>>
>>> Another suggestion was to use project and create multiple connections.
>>> This does not work because: (1) you can only have one connection to each
>>> sever.  If I need to connect to multiple databases on the same server, I
>>> cannot. (2) Each SQL script can only be associated to one and only one
>>> connection object.
>>>
>>> So what I would like to do is intercept the File Open Event (or whatever
>>> it is called) and replace it with my own logic.
>>>
>>> Any ideas?
>>>
>>
>>
>
>