We help IT Professionals succeed at work.

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

Medium Priority
335 Views
Last Modified: 2013-12-03
Hi.

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,
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
>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
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Hi orasaj,
Are you trying it from a workstation...

Ved Prakash AgrawalSenior Manager, Database Engineering

Commented:
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..

Author

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.
Hi,

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
happens.
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.

hth

Andy
Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.