SSMS 2008: Ctrl-Shift-M

#41

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#42

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#43

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#44

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#45

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#46

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

I guess we need to be more adaptable :-)

"Tibor Karaszi" wrote:

Quote:

Did you see my advice?

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

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote in message
news:4490DA4C-D56A-4E2E-9518-99F42F95EE00 (AT) microsoft (DOT) com...
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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.

#47

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

#48

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

#49

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

#50

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