In SQL2K, we can generate scripts just for PK and FK, or just Indexes.
Somehow, I could not to do that in SQL 2005, it does not give me the options
to generate only Indexes.
Any idea?This is a severe shortcoming in the tool (both not being able to right-click
the indexes node under a table and script all, and not being able to select
multiple items anywhere in Object Explorer). But thankfully, there is help
coming soon with Service Pack 2, which swaps out the Summary tab for a new
context-sensitive tab called Object Explorer Details. In this tab, when you
expand a table and highlight the Indexes node on the left, you can select
multiple items on the right, right-click them, and follow a Script > menu.
I talked about this briefly here:
http://www.aaronbertrand.com/rant.asp?r=499
"TBoon" <allblacks15@.hotmail.com> wrote in message
news:uo0a3dODHHA.4404@.TK2MSFTNGP03.phx.gbl...
> In SQL2K, we can generate scripts just for PK and FK, or just Indexes.
> Somehow, I could not to do that in SQL 2005, it does not give me the
> options to generate only Indexes.
> Any idea?
>|||In addition to Aaron's, post:
Meanwhile, consider doing some SMO coding: http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TBoon" <allblacks15@.hotmail.com> wrote in message news:uo0a3dODHHA.4404@.TK2MSFTNGP03.phx.gbl...
> In SQL2K, we can generate scripts just for PK and FK, or just Indexes.
> Somehow, I could not to do that in SQL 2005, it does not give me the options to generate only
> Indexes.
> Any idea?
>|||Hi,Aaron
Hmm, it is possible that I do not understand you , but I can highlight more
than one item (SPfor example) in Object Explorer and script them out to the
new window
I have SQL Server 2005 Dev Edition
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23GNKeHPDHHA.3524@.TK2MSFTNGP06.phx.gbl...
> This is a severe shortcoming in the tool (both not being able to
> right-click the indexes node under a table and script all, and not being
> able to select multiple items anywhere in Object Explorer). But
> thankfully, there is help coming soon with Service Pack 2, which swaps out
> the Summary tab for a new context-sensitive tab called Object Explorer
> Details. In this tab, when you expand a table and highlight the Indexes
> node on the left, you can select multiple items on the right, right-click
> them, and follow a Script > menu.
> I talked about this briefly here:
> http://www.aaronbertrand.com/rant.asp?r=499
>
>
>
> "TBoon" <allblacks15@.hotmail.com> wrote in message
> news:uo0a3dODHHA.4404@.TK2MSFTNGP03.phx.gbl...
>> In SQL2K, we can generate scripts just for PK and FK, or just Indexes.
>> Somehow, I could not to do that in SQL 2005, it does not give me the
>> options to generate only Indexes.
>> Any idea?
>|||I don't know how you could do that. When I click on an object like a table,
and hold shift or control to try and click a second table, the second table
is highlighted (even if I am still holding shift or control).
Maybe you could take a screen shot of what you are talking about, because I
don't know of any node in Object Explorer that allows this (SP2 or prior).
We're talking about Management Studio here, right? Not Query Analyzer?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23B5w9lSDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Hi,Aaron
> Hmm, it is possible that I do not understand you , but I can highlight
> more than one item (SPfor example) in Object Explorer and script them out
> to the new window
> I have SQL Server 2005 Dev Edition|||Hi ,Aaron
> We're talking about Management Studio here, right? Not Query Analyzer?
Sure , here is the morning , but I had already two coffees :-))))))
>I don't know how you could do that. When I click on an object like a
>table, and hold shift or control to try and click a second table, the
>second table is highlighted (even if I am still holding shift or control).
In Summery Tab I click on SP --hold Ctrl button and then secon SP --
I can send you a print screen if you want , just tell me the email address
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ONxNC3SDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I don't know how you could do that. When I click on an object like a
>table, and hold shift or control to try and click a second table, the
>second table is highlighted (even if I am still holding shift or control).
> Maybe you could take a screen shot of what you are talking about, because
> I don't know of any node in Object Explorer that allows this (SP2 or
> prior).
> We're talking about Management Studio here, right? Not Query Analyzer?
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23B5w9lSDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>> Hi,Aaron
>> Hmm, it is possible that I do not understand you , but I can highlight
>> more than one item (SPfor example) in Object Explorer and script them out
>> to the new window
>> I have SQL Server 2005 Dev Edition
>|||> In Summery Tab
(!) I was talking about Object Explorer (the left pane). I never used the
Summary Tab.
And as luck would have it, I don't have a pre-SP2 server within reach to
even see what you're talking about. Again, I was talking about in Object
Explorer, which I had initially expected to allow you to select multiple
objects.
A|||Ok,
I was confused by your statement
<coming soon with Service Pack 2, which swaps out the >Summary tab for a new
> context-sensitive tab called Object Explorer Details.
Well, I just wanted to say that on the righ pane (Summary Tab) you can do
that
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e0aKhcXDHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> In Summery Tab
> (!) I was talking about Object Explorer (the left pane). I never used the
> Summary Tab.
> And as luck would have it, I don't have a pre-SP2 server within reach to
> even see what you're talking about. Again, I was talking about in Object
> Explorer, which I had initially expected to allow you to select multiple
> objects.
> A
>
