Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time out Expand / Collapse
Author
Message
Posted Friday, November 2, 2012 5:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 3:42 AM
Points: 7, Visits: 13
Hi,

I'm doing bulk insert which is taking 36sec approx. can anyone tell me how to execute using asp.net c#. normal executenonquery is throwing timeout expection

Thanks in Advance
Post #1380282
Posted Friday, November 2, 2012 5:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:55 AM
Points: 2,852, Visits: 5,107
Change SqlCommand.CommandTimeout to higher number. Default is 30 sec...


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1380286
Posted Friday, November 2, 2012 5:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 3:42 AM
Points: 7, Visits: 13
I set it to 0 that means infinity right? if i'm not wrong
Post #1380296
Posted Friday, November 2, 2012 9:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:38 AM
Points: 33,267, Visits: 15,436
0 should be infinity.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout%28v=VS.71%29.aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1380473
Posted Wednesday, November 7, 2012 4:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 3:42 AM
Points: 7, Visits: 13
Thanks all it worked for me..
Post #1381904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse