Hi,

Problem: There are 4 SPs. When I execute the SPs using Connection object in VB6 it runs fine both in local and remote server.

But when I generated a SQL script (hence I have removed the IDENTITY feature in some of the tables and added a few new tables) and created a database in the remote server and then execute with the same method then it gives me a Timeout Expired Error!!

Connection timout is set to 1200.

I have checked the indexes and they are fine.

Please suggest.

__________________
Lalit Pratihari

Use query analyzer to see what execution plan is being used when executing these procs against the new database.

If it uses scans instead of seeks it may be that your statistics are out of date. You can examine that by using
DBCC SHOW_STATISTICS or STATS_DATE



David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com