Re: timeout expired on View
- From: Ed White <ewhite@xxxxxxxxxxxxxxxxx>
- Date: Tue, 30 Dec 2008 11:31:01 -0800
OK on points 1 and 2. Regarding your point 2, it's just as easy to create a
View to modify the data as it is to put the data into a new Table that can be
edited.
The Designers option was set to 60 seconds, and I increased it to 120.
Sometimes I still get the timeout error after about 30 seconds, but other
times I do not.
--
Ed
"Mark Han[MSFT]" wrote:
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@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.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/subscriptions/aa948874.aspx
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
- References:
- timeout expired on View
- From: Ed White
- Re: timeout expired on View
- From: Ekrem Önsoy
- Re: timeout expired on View
- From: Mark Han[MSFT]
- timeout expired on View
- Prev by Date: Re: SQL Server Management Studio Express on a USB Flash Drive
- Next by Date: Re: Greyed out View Designer and Query Designer
- Previous by thread: Re: timeout expired on View
- Index(es):
Relevant Pages
|
