Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SSMS 2008: Ctrl-Shift-M

 
   Database Forums (Home) -> Tools RSS
Next:  Upgrade from SQLExpress 2008 to SQLExpress 2008 w..  
Author Message
TomT

External


Since: Mar 03, 2006
Posts: 12



(Msg. 1) Posted: Thu Aug 28, 2008 4:25 pm
Post subject: SSMS 2008: Ctrl-Shift-M
Archived from groups: microsoft>public>sqlserver>tools (more info?)

Ctrl-Shift-M does not appear to work in this version (for templates), is this
a bug?

Thanks

 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
Mark Han[MSFT]

External


Since: Aug 29, 2008
Posts: 20



(Msg. 2) Posted: Fri Aug 29, 2008 6:05 am
Post subject: RE: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello Customer

Thank you for contacting Microsoft Online Community Support. It is Mark, a
SQL Server Engineer. I'm glad to assist you with the issue.

For this case, you indicated that when Ctrl-Shift-M, the Specify Values
for Template Parameters dialog box doesn't appear. Is it correct? If I
misunderstand anything, please tell me directly. It will help us to resolve
this issue quickly. Once the issue resolved, I'll appreciate your
verification.

In order to resolve the issue, I would like to explain the following
I) I have re-produce the issue and compare it with SQL Server 2005
Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key
does not exist in SQL Server 2008 Management Studio. If you have concerns
on that, please send us a feedback via the
address(https://connect.microsoft.com/sql). Besides I'm consulting with our
dev team with the issue; if anything updates, we will public it.

II) Ctrl-Shift-M is used to replace template parameters, we also can open
Specify Values for Template Parameters
manually
1) On the Query menu, click Specify Values for Template Parameters.
2) In the Specify Values for Template Parameters dialog box, the
Values column contains suggested value for the
parameter (Database Name in the example above). Accept the value
or replace it with a new value, and then click OK
to close the Replace Template Parameters dialog box and modify
the script in the query editor.

If anything is unclear, please let me know.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg DeleteThis @microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 891



(Msg. 3) Posted: Fri Aug 29, 2008 9:55 am
Post subject: Re: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Seems this one also is either there or not along with F8, ctrl-N etc. Check out:
http://sqlblog.com/blogs/tibor_karaszi/archive/2008/08/26/missing-f8-o...trl-n-i

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"TomT" wrote in message

> Ctrl-Shift-M does not appear to work in this version (for templates), is this
> a bug?
>
> Thanks
 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
TomT

External


Since: Mar 03, 2006
Posts: 12



(Msg. 4) Posted: Fri Aug 29, 2008 10:15 am
Post subject: RE: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks for your reply Mark - I can only add this (language in new sp
template, SSMS 2008):

-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.

That's why I assumed it was still there

"Mark Han[MSFT]" wrote:

> Hello Customer
>
> Thank you for contacting Microsoft Online Community Support. It is Mark, a
> SQL Server Engineer. I'm glad to assist you with the issue.
>
> For this case, you indicated that when Ctrl-Shift-M, the Specify Values
> for Template Parameters dialog box doesn't appear. Is it correct? If I
> misunderstand anything, please tell me directly. It will help us to resolve
> this issue quickly. Once the issue resolved, I'll appreciate your
> verification.
>
> In order to resolve the issue, I would like to explain the following
> I) I have re-produce the issue and compare it with SQL Server 2005
> Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key
> does not exist in SQL Server 2008 Management Studio. If you have concerns
> on that, please send us a feedback via the
> address(https://connect.microsoft.com/sql). Besides I'm consulting with our
> dev team with the issue; if anything updates, we will public it.
>
> II) Ctrl-Shift-M is used to replace template parameters, we also can open
> Specify Values for Template Parameters
> manually
> 1) On the Query menu, click Specify Values for Template Parameters.
> 2) In the Specify Values for Template Parameters dialog box, the
> Values column contains suggested value for the
> parameter (Database Name in the example above). Accept the value
> or replace it with a new value, and then click OK
> to close the Replace Template Parameters dialog box and modify
> the script in the query editor.
>
> If anything is unclear, please let me know.
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> ===========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
> ===========================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 891



(Msg. 5) Posted: Fri Aug 29, 2008 7:41 pm
Post subject: Re: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Did you see my advice?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"TomT" wrote in message

> Thanks for your reply Mark - I can only add this (language in new sp
> template, SSMS 2008):
>
> -- Template generated from Template Explorer using:
> -- Create Procedure (New Menu).SQL
> --
> -- Use the Specify Values for Template Parameters
> -- command (Ctrl-Shift-M) to fill in the parameter
> -- values below.
>
> That's why I assumed it was still there
>
> "Mark Han[MSFT]" wrote:
>
>> Hello Customer
>>
>> Thank you for contacting Microsoft Online Community Support. It is Mark, a
>> SQL Server Engineer. I'm glad to assist you with the issue.
>>
>> For this case, you indicated that when Ctrl-Shift-M, the Specify Values
>> for Template Parameters dialog box doesn't appear. Is it correct? If I
>> misunderstand anything, please tell me directly. It will help us to resolve
>> this issue quickly. Once the issue resolved, I'll appreciate your
>> verification.
>>
>> In order to resolve the issue, I would like to explain the following
>> I) I have re-produce the issue and compare it with SQL Server 2005
>> Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key
>> does not exist in SQL Server 2008 Management Studio. If you have concerns
>> on that, please send us a feedback via the
>> address(https://connect.microsoft.com/sql). Besides I'm consulting with our
>> dev team with the issue; if anything updates, we will public it.
>>
>> II) Ctrl-Shift-M is used to replace template parameters, we also can open
>> Specify Values for Template Parameters
>> manually
>> 1) On the Query menu, click Specify Values for Template Parameters.
>> 2) In the Specify Values for Template Parameters dialog box, the
>> Values column contains suggested value for the
>> parameter (Database Name in the example above). Accept the value
>> or replace it with a new value, and then click OK
>> to close the Replace Template Parameters dialog box and modify
>> the script in the query editor.
>>
>> If anything is unclear, please let me know.
>>
>> Best regards,
>> Mark Han
>> Microsoft Online Community Support
>> ===========================================================
>> Delighting our customers is our #1 priority. We welcome your
>> comments and suggestions about how we can improve the
>> support we provide to you. Please feel free to let my manager
>> know what you think of the level of service provided. You can
>> send feedback directly to my manager at: msdnmg.RemoveThis@microsoft.com.
>> ===========================================================
>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>>
>> Note: The MSDN Managed Newsgroup support offering is for
>> non-urgent issues where an initial response from the community
>> or a Microsoft Support Engineer within 1 business day is acceptable.
>> Please note that each follow up response may take approximately
>> 2 business days as the support professional working with you may
>> need further investigation to reach the most efficient resolution.
>> The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by
>> contacting Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ============================================================
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>>
>>
 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
TomT

External


Since: Mar 03, 2006
Posts: 12



(Msg. 6) Posted: Fri Aug 29, 2008 7:41 pm
Post subject: Re: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes, I did, thanks very much....

I guess we need to be more adaptable Smile

"Tibor Karaszi" wrote:

> Did you see my advice?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "TomT" wrote in message
>
> > Thanks for your reply Mark - I can only add this (language in new sp
> > template, SSMS 2008):
> >
> > -- Template generated from Template Explorer using:
> > -- Create Procedure (New Menu).SQL
> > --
> > -- Use the Specify Values for Template Parameters
> > -- command (Ctrl-Shift-M) to fill in the parameter
> > -- values below.
> >
> > That's why I assumed it was still there
> >
> > "Mark Han[MSFT]" wrote:
> >
> >> Hello Customer
> >>
> >> Thank you for contacting Microsoft Online Community Support. It is Mark, a
> >> SQL Server Engineer. I'm glad to assist you with the issue.
> >>
> >> For this case, you indicated that when Ctrl-Shift-M, the Specify Values
> >> for Template Parameters dialog box doesn't appear. Is it correct? If I
> >> misunderstand anything, please tell me directly. It will help us to resolve
> >> this issue quickly. Once the issue resolved, I'll appreciate your
> >> verification.
> >>
> >> In order to resolve the issue, I would like to explain the following
> >> I) I have re-produce the issue and compare it with SQL Server 2005
> >> Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key
> >> does not exist in SQL Server 2008 Management Studio. If you have concerns
> >> on that, please send us a feedback via the
> >> address(https://connect.microsoft.com/sql). Besides I'm consulting with our
> >> dev team with the issue; if anything updates, we will public it.
> >>
> >> II) Ctrl-Shift-M is used to replace template parameters, we also can open
> >> Specify Values for Template Parameters
> >> manually
> >> 1) On the Query menu, click Specify Values for Template Parameters.
> >> 2) In the Specify Values for Template Parameters dialog box, the
> >> Values column contains suggested value for the
> >> parameter (Database Name in the example above). Accept the value
> >> or replace it with a new value, and then click OK
> >> to close the Replace Template Parameters dialog box and modify
> >> the script in the query editor.
> >>
> >> If anything is unclear, please let me know.
> >>
> >> Best regards,
> >> Mark Han
> >> Microsoft Online Community Support
> >> ===========================================================
> >> Delighting our customers is our #1 priority. We welcome your
> >> comments and suggestions about how we can improve the
> >> support we provide to you. Please feel free to let my manager
> >> know what you think of the level of service provided. You can
> >> send feedback directly to my manager at: msdnmg.RemoveThis@microsoft.com.
> >> ===========================================================
> >> Get notification to my posts through email? Please refer to
> >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> >> ications.
> >>
> >> Note: The MSDN Managed Newsgroup support offering is for
> >> non-urgent issues where an initial response from the community
> >> or a Microsoft Support Engineer within 1 business day is acceptable.
> >> Please note that each follow up response may take approximately
> >> 2 business days as the support professional working with you may
> >> need further investigation to reach the most efficient resolution.
> >> The offering is not appropriate for situations
> >> that require urgent, real-time or phone-based interactions or complex
> >> project analysis and dump analysis issues. Issues of this nature are best
> >> handled working with a dedicated Microsoft Support Engineer by
> >> contacting Microsoft Customer Support Services (CSS) at
> >> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> >> ============================================================
> >> This posting is provided "AS IS" with no warranties, and confers no rights.
> >>
> >>
>
>
 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
Mark Han[MSFT]

External


Since: Aug 29, 2008
Posts: 20



(Msg. 7) Posted: Mon Sep 01, 2008 3:06 am
Post subject: RE: SSMS 2008: Ctrl-Shift-M [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello Customer,

Welcome, it is my pleasure to assist you with the techonical issue.

Through my test, it is confirmed that the Specify Values for Template
Parameters function still exist but the "Ctrl-Shift-M" shortcut key(call
the Specify Values for Template Parameters function) disappear in SSMS
2008. So to use Specify Values for Template Parameters function, we should
manually open it's dialog box. (Query ->Specify Values for Template
Parameters)

Based on the above, I'm consulting with our dev team. If anything updated,
I will email you. If it is convenient to you, could you please provide your
email address to me?

Besides, as you following description, does it mean that when you press the
"Ctrl-Shift-M", the Specify Values for Template Parameters dialog box
appear?

"-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below"

If you have any questions or concerns, please let me know.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg RemoveThis @microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: SSMS 2008: Ctrl-Shift-M 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSMS 2008 - Hi, This is my first post. I backed up my registered servers on SSMS 2008, including passwords, re-installed my OS from scratch, and imported the server list. When I run SSMS 2008 now, I get a .NET Framework unhandled exception error with the..

SSMS Error - We have two production servers running SQL 2000 and that are set up as linked servers. My desktop has SQL 2005 and I am using MAnagement Studio to connect to the first server. While running a stored procedure on a 1st remote server that inserts data..

SSMS with SS Express - I run SQL Server Express because it supports the local attach feature in Visual Studio but is it possible to install SSMS from the Developer edition of SQL Server on the same machine?

Scripting options in new SSMS - I am a little stunned by Microsoft removing the scripting options in the new SSMS. All our teams developement is driven by scripting objects (view and procs) with the drop and create and including the permissions..... Not to mention the table indexes..

Test operator using SSMS? - What happened to the ability to test email/page functionality for operators? I am using SSMS to manage a SS2000 instance, and in the Operator Properties page there isn't a way to test sending a notification. I know this isn't EM and things have..
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]