I'm running SSMS with SQL Server 2008. Under SSMS Options, Execution
time-out is set to 0 seconds (i.e. no time-out), and SET LOCK TIMEOUT is set
to -1 milliseconds. I have a certain SQL command that takes a while to
execute. If I run it in the Query window as a straigth SQL command, it will
execute after a minute or two. However, if I create a View using the exact
same SQL command, pull up the View in SSMS in Design mode, and execute the
View, the following happens: First, at the bottom of the screen, it says
"Executing Query. Waiting for response from data source." After about 30
seconds, a window comes up with the error message: "SQL Execution Error." ...
"Error Source: .Net SqlClient Data Provider. Error Message: Timeout expired.
The timeout period elapsed prior to completion of the operation or the server
is not responding." First Question: How can I tell SSMS not to timeout on
the View?

Incidentally, one reason I use a View is to be able to edit the rows that
are returned. If I use a straight SQL command in the Query window, I cannot
edit the rows returned. Second Question: Is there a way to run a query in
the Query window and tell SSMS to allow me to edit the results?
--
Ed

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Ed,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that when you run query in view design
mode, a timeout expired error happens. If I have misunderstood, please let
me know.

in order to address your concern, I would like to explain the following.
1 Based on your description, I know that the reason for creating a view is
that you would like to modify the result of the query manually. however, it
is not allowed for us to modify the result of the query directly. we need
to save the result first.

2 For your convenience, it is suggest to use select into command to save
the result of thequery into a table and we can execute the sql command in
the the Query window. there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms189499.aspx

3 also, please To perform long-running operations via SSMS, go to
Tools->Options->Designers and in the Table Options, set the "Transaction
time-out after" value to something more (such as 90 if your operation takes
less than 3 mins.)

Besides, please tell me if you have concern on the time the query executes.

If there is anything unclear, let me know.

Have a nice day!

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: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======