469,579 Members | 1,181 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Time Out Problem

Hi,

I have a web service that takes in a record to be added to a database
table, simple right?

Well one field stores a .wav file converted to a bit array and is of
the field type Text.

If the field gets large, the record gets inserted just fine, but then
any attempt to run an update or delete on that record just times out.
Even in enterprise manager or query analyzer, and without updating the
actual text field itself.

It is seeming to lock the record somehow whenever the record is
inserted with a large string in the text field. (works fine with a
smaller value)

The only way I have found to get the record editable again is to detach
and reattach.

Any help would be greatly appreciated.

Thanks,

Brian

Jul 23 '05 #1
1 1182
(Th******@gmail.com) writes:
I have a web service that takes in a record to be added to a database
table, simple right?

Well one field stores a .wav file converted to a bit array and is of
the field type Text.

If the field gets large, the record gets inserted just fine, but then
any attempt to run an update or delete on that record just times out.
Even in enterprise manager or query analyzer, and without updating the
actual text field itself.

It is seeming to lock the record somehow whenever the record is
inserted with a large string in the text field. (works fine with a
smaller value)

The only way I have found to get the record editable again is to detach
and reattach.


It appears that you are editing the data through Open Table facility.
The normal way to update data in SQL Server is through INSERT, UPDATE
and DELETE statements. The Open Table function is a convenience function
for quick changes, but is not meant to be a replacement for an application.
It's not even to be compared to what you can do in Excel or Access.
Open Table has several shortcomings, and this is apparently one of them.

While the syntax for INSERT, UPDATE and DELETE maybe be cumbersome to
begin with, it's impossible to work with a relational database without
them. As a piece of data: I type INSERT, UPDATE and DELETE statements
daily. I never use Open Table.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by David Graham | last post: by
10 posts views Thread by Bart Goeman | last post: by
38 posts views Thread by vashwath | last post: by
3 posts views Thread by Servé Lau | last post: by
80 posts views Thread by Charles Law | last post: by
3 posts views Thread by Satish Itty | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.