Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Command Timeout

Reply
 
Old 05-05-2008   #1 (permalink)
rob schieber


 
 

Command Timeout

Any ideas why a text query would timeout w/ a dataAdapter and the Command
object, but execute quickly via Management Studio?

Thanks

--
Rob Schieber



My System SpecsSystem Spec
Old 05-05-2008   #2 (permalink)
rob schieber


 
 

Re: Command Timeout

We were actually able to fix this, we ran dbcc flushprocindb([databaseId]),
and the query executed normally through ado.net. Maybe bad execution plan
or statistics?

"rob schieber" <no-one@xxxxxx> wrote in message
news:eqEt8DvrIHA.2292@xxxxxx
Quote:

> Any ideas why a text query would timeout w/ a dataAdapter and the Command
> object, but execute quickly via Management Studio?
>
> Thanks
>
> --
> Rob Schieber
>

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Running a command from inside a script, command line is corrupted PowerShell
Solved Make a command prompt run a command as soon as it opens? General Discussion
UAC Timeout ?!? .NET General
BeginTransaction causes command to ignore timeout .NET General
Anyway to timeout a command PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46