Hi,
I'm having trouble using vb.net (vs.net 2005/2008) and sql express (SP2) to
develop applications. For a particular project I randomly get command
timeouts.
I have checked that the project doesnt have SQL Debugger active (Project \
Properties\ Debug \ Enable SQL Server debugging unticked).
Also made sure that AutoClose is off for this database.
Using sp_who I can see that one process has a suspended status, and there
that are no current blockings(blk).
The queries general come back in sub seconds, so nothing huge.
Anyone think of other things I may have missed?
I'm having trouble using vb.net (vs.net 2005/2008) and sql express (SP2) to
develop applications. For a particular project I randomly get command
timeouts.
I have checked that the project doesnt have SQL Debugger active (Project \
Properties\ Debug \ Enable SQL Server debugging unticked).
Also made sure that AutoClose is off for this database.
Using sp_who I can see that one process has a suspended status, and there
that are no current blockings(blk).
The queries general come back in sub seconds, so nothing huge.
Anyone think of other things I may have missed?