Re: Can Select but Can't Update or Insert in Tables
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/27/04
- Next message: Stephen Dybing [MSFT]: "Re: April Security Patches and SQL Server"
- Previous message: Eddie Leung: "Can Select but Can't Update or Insert in Tables"
- In reply to: Eddie Leung: "Can Select but Can't Update or Insert in Tables"
- Next in thread: Eddie Leung: "Re: Can Select but Can't Update or Insert in Tables"
- Reply: Eddie Leung: "Re: Can Select but Can't Update or Insert in Tables"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 18:02:16 +0200
It could be blocking problems, or that the operations takes so long time because lots of data and lack of
indexes.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Eddie Leung" <eddielg@image.com.hk> wrote in message news:eEHu9CHLEHA.3664@TK2MSFTNGP10.phx.gbl... > I have a problem in the SQL 2000 Server. In one my database, I found that I > can retrieve the records from every table in the database (by "select"), but > when I wanted to update or insert the record in each table, It failed and > return error "timeout expired". What is the problem? What should I do to get > rid of this problem? > > Thanks. > > Eddie > >
- Next message: Stephen Dybing [MSFT]: "Re: April Security Patches and SQL Server"
- Previous message: Eddie Leung: "Can Select but Can't Update or Insert in Tables"
- In reply to: Eddie Leung: "Can Select but Can't Update or Insert in Tables"
- Next in thread: Eddie Leung: "Re: Can Select but Can't Update or Insert in Tables"
- Reply: Eddie Leung: "Re: Can Select but Can't Update or Insert in Tables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
