i have a .net console application and using MSSQL server 2008 on a clustered box. i have an automated process that runs on a server and builds information in my database. the application runs fine on my development boxes i can run it 100 times. But when i run it on my automated server is starts to get timeouts.
(0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
UPDATE SDL_DropList SET DualCredit = 'Y' WHERE PIDM = '330348'
As you see a very simple SQl statement but i run that command about 3000 items on the database for different users