SSMS 2008: Ctrl-Shift-M

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

Thanks

Hello CustomerThank you for contacting Online Community Support.

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@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.

Seems this one also is either there or not along with F8, ctrl-N etc.

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-or-ctrl-n-in-ssms-2008.aspx

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

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

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

Did you see my advice?

Did you see my advice?

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

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

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

I guess we need to be more adaptable :-)

Hello Customer,Welcome, it is my pleasure to assist you with the techonical

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
appear?

-- 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@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

Hello Customer,After consulting with our development team, the issue is

Hello Customer,

After consulting with our development team, the issue is confirmed as
by-design. It looks like Ctrl-Shift-M is no longer mapped to the menu item
for Specify Values for Template Parameters in SSMS 2008.  If you have
concerns on that, please send a feedback via the
address(https://connect.microsoft.com/sql). Our develop team will prove it.

Besides, is anything I can assist you? if you have any questions, please
email me(v-fathan@online.microsoft.com)(remove online)

Thank you again for choosing Microsoft Online Community Support. I would
like to ensure that you have been 100% satisfied with our service.

Best regards,
Mark Han

Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

I posted here a while time ago that ctrl-M *is* available.

I posted here a while time ago that ctrl-M *is* available.

All you do is to switch to 2000 layout and then back to 2005 layout. It has worked on all instanced
I tried...

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

SSMS 2008: Ctrl-Shift-M

I have sent an email to you - thanks

SSMS 2008: Ctrl-Shift-M

Mark - my email bounced back, sent to v-fathan@online.microsoft.com

Take out the "online." part.

Take out the "online." part.  Or, just continue the conversation here, so
everyone can benefit (and provide input).  Did you try what Tibor suggested,
changing the keyboard scheme to 2000 and then back?



On 9/3/08 1:32 PM, in article
D07C909C-7184-49EE-B674-82F1F12EF4C7@microsoft.com, "TomT"

Thanks Aaron.

Thanks Aaron. I was giving him my email because he requested it earlier in
the thread - I think for follow up down the (perhaps long and winding) road
regarding this issue...?

Hello Tom,Thank you for the information and patience with me.

Hello Tom,

Thank you for the information and patience with me.

I have tied the Aaron's suggestion. It works. Thanks, Aaron.

Based on the current situation, SSMS 2008 doesn't have the same keyboard
scheme as SSMS 2000/SSMS 2005; and the below steps(Aaron's suggestion) are
a workaround.

The detail steps :
Open SSMS->Tool->Option->Environment->Key Board->Keyboard Scheme(set the
value to SQL Server 2000)->kick "OK"

There is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms177225.aspx

Besides, We have received our customer's feedback about the product issue.
Our product team will approve it.

Thanks again for choosing Microsoft Online Community Support. If you have
any other question, please email me. I will be gald to assist you.

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@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

SSMS 2008: Ctrl-Shift-M

(kambiz.kohanim@gmail.com) writes:

You should have two keyboard options: Standard and SQL 2000. The workaround
for this issue appears to be that you change this option, and if you want
the original option, you change back.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Do you mean you are using Management Studio Express (from Express with Toolsor

Do you mean you are using Management Studio Express (from Express with Tools
or Express with Advanced Services)?  Note that this is a scaled back tool
and doesn't support all of the features and functionality of the complete
SSMS tool.  I haven't used this version of the tool so am not even sure if
it has options for keyboard scheme and/or if CTRL+Shift+M is supported
there.

Also note that you should not see an option for "2005 layout"... The
keyboard scheme dropdown will have the options "SQL Server 2000" and
said "back to 2005 layout"...


On 9/6/08 3:21 AM, in article
c64ace4f-b531-4dad-a8e7-d4776c3975eb@w1g2000prk.googlegroups.com,

SSMS 2008: Ctrl-Shift-M

Thanks for the tip, but it does not seem to work for me. :-(
1. I have SQL 2008 Express and
2. I do not have the 2005 layout option. Do I need to add this to my 08
version?

Hello Kambiz,I agree with Erland and Aaron.

Hello Kambiz,

I agree with Erland and Aaron.  There is no an option for "2005 layout" in
Keyboard Scheme.

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@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

Hi Tom,What is this issue going on?

Hi Tom,

What is this issue going on?

If there is any issue, please feel free to post back. We are very glad for
further assistance.

Have a good day!

Best regards,
Charles Wang
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@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================