Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sky1224
Starting Member
12 Posts |
 Posted - 2009-12-17 : 20:59:46
|
| Good morning.I converted an Access query(very long and big SELECT query) to SQL Server.In MS SQL Server Management Studio, I select the <test> db and right clicked to select <New Query>, and the editted the converted query, and executed.Sometimes later(about 3 minutes? - my com:AMD Athlon 64 X2 DualCore 5000+ 2.6GHz, DDRII 2GB) the query was executed successfully.So I made the new <View> and saved it, and run it (<Open View>!).But the query doesn't run! Error Msg <Timeout Expired. The timeout peorid elapsed prior to completionof the operation or the server is not responding.>What can I do to execute this <View> query?Please Help me. Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-12-18 : 03:11:23
|
| HiCheck the code If u might using Join or while loop etc...OrMay be am not sure.To perform long-running operations via SSMS, go to Tools->Options->Designersand in the Table Options, set the "Transaction time-out after" value tosomething more.-------------------------R... |
 |
|
|
|
|
|
My Query : Timeout Expired!