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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-09-20 : 03:56:48
|
| when i run the query it works on SQL Query Analyzer but it times out on enterprise manager any suggestion to why it times out?Any possible ways of resolving the time out.Yogesh V. Desai. | SQLDBA| |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-20 : 03:59:44
|
Continue to use Query Analyzer.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-20 : 04:06:40
|
| To view data, why did you use EM?As said always use Query Analyser for all your data manipulationsMadhivananFailing to plan is Planning to fail |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 04:06:50
|
| this is not the permanant solutionYogesh V. Desai. | SQLDBA| |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 04:11:57
|
| OH Iccc I got it thanks you very much friendsYogesh V. Desai. | SQLDBA| |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-20 : 04:27:37
|
quote:
Originally posted by YogeshDesai
OH Iccc I got it thanks you very much friendsYogesh V. Desai. | SQLDBA|
What did you get?MadhivananFailing to plan is Planning to fail |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 08:08:41
|
| I understood what he want to explain that's it, We have always use QA for view which are genrating long reportsSQL IN Minds |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-20 : 23:56:04
|
| EM is not designed for query, that's why you have query analyzer. |
|
|
|
|
|
|
View time out from enterprise manager