[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

SQL Server 2000: Timeout Expire when I try to insert data from Enterprise manager


My table have about 700,000 record and no primary key.
I try to run this statement to insert record from enterprise manager

"insert into tableA (F1) value ('TEST')"

The Error occur "[Microsoft] [ODBC SQL SERVER DRIVER] Timeout Expire"

Thanks in advance,
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>My table have about 700,000 record and no primary key.
this is a possibility if the timeout reason, but not alone.

there might be a trigger on the table which performs very badly due to the missing primary key/indexes
Aneesh RetnakaranDatabase AdministratorCommented:
Hi orasaj,
Are you trying it from a workstation...

Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Hi you have tried this using Query Analyzer.
if not , please run your statement using Query Analyzer.

for this you need to connect with sql serever and then you run this script.

or you can check using profiler what's going on server when you run this server.
so if any error occured you can saw that in profiler also.

and i think after that you can take decision where is going something wrong..

Good Luck..
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

orasajAuthor Commented:
Hi everybody,

Now I can insert the record with the same statement by use enterprise manager.
But I still don't know what happen!

Thank you everybody,
Orasa J.

maybe you got a timeout specified in the connection you use.
I think default value is something like 10 or 15 (s). And if the operation takes longer, as in your sample because of missing PK, than the timeout
Try finding out what is the value for "timeout" in the connection u are using and increase it or set it to 0. 0 means, that the connection will stay open as long as the operation takes.


Aneesh RetnakaranDatabase AdministratorCommented:
When you insert a value from the EM, these two things will happen
1. An 'INSERT INTO ... '  statement is run first -- This wont give the timeout error
2. After the above statement, it will run a 'SELECT * FROM urTable' -- I think the problem is here
Since it has to return more than 700000, sometimes it may give an error

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now