Re: Temporary table disappears
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/01/04
- Next message: Elie Grouchko: "Re: Problem connecting from Enterprise Manager"
- Previous message: Rand Boyd [MSFT]: "RE: multiple sessions when using ADO"
- In reply to: John Bell: "Re: Temporary table disappears"
- Messages sorted by: [ date ] [ thread ]
Date: 1 Jun 2004 13:24:58 -0700
After 2.5 hours I cancelled them!!!!
John
"John Bell" <jbellnewsposts@hotmail.com> wrote in message news:<Ja_uc.1134$xb.10805319@news-text.cableinet.net>...
> Hi
>
> My 14 sessions have all been working for over 22 minutes without a problem!
> You don't give the version of SQL server, but at a guess you are seeing some
> form of contention on tempdb that is making a statement timeout. You may
> want to check the error status from your statements
>
> Che
>
> John
>
> "steve" <anonymous@discussions.microsoft.com> wrote in message
> news:1662501c447bc$e48ee410$a001280a@phx.gbl...
> > I have some more details about the problem I am
> > experiencing. I decided to start up ten Query Analyser
> > queries and run the following SQL code:
> >
> > set nocount on
> > if object_id('tempdb..#tmp') is null create table #tmp
> > (spid int, ecid int, status varchar(50), loginame varchar
> > (50), hostname varchar(50), blk int, dbname varchar(50),
> > cmd varchar(50))
> > declare @flag int
> > select @flag=0
> > select 'Started at ', GetDate()
> > while @flag=0
> > begin
> > if object_id('tempdb..#tmp') is null
> > begin
> > select '#tmp has gone!!!', GetDate()
> > select @flag=1
> > end
> > else
> > begin
> > truncate table #tmp
> > insert #tmp exec sp_who
> > waitfor delay '00:00:03'
> > end
> > end
> >
> >
> > So I leave these ten queries running until something
> > happens. After a few minutes, I got an error on one of the
> > query windows:
> >
> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]
> > ConnectionRead (recv()).
> > Server: Msg 11, Level 16, State 1, Line 0
> > General network error. Check your network documentation.
> >
> > Connection Broken"
> >
> > The process ID in the status bar says 61. I check
> > Enterprise Manager/Current Activity/Process Info, and
> > process 61 is NOT in the list. The connection has
> > disappeared. Nothing in the SQL log or NT Event log
> > indicates any problem. And all other nine queries are
> > running fine, so it is highly unlikely to be a network
> > problem from my computer to the server.
> >
> > Any ideas about how to troubleshoot further would be
> > appreciated.
> >
> > Steve
> >
> >
> >
> > >-----Original Message-----
> > >I am most interested in your question, since something
> > similar happens to me while I am coding, but I never
> > thought it possible that this could happen in Query
> > Analyser! I thought that the spid changed on me due to the
> > fact that I was executing several async queries
> > simultaneously.
> > >
> > >I suppose you know, but just to mention it, the temp
> > table is not visible to the new connection, only the old
> > connection, that is the old spid. Is the temp table still
> > visible to you as an object in tempdb..sysobjects?
> > >
> > >
> > >.
> > >
- Next message: Elie Grouchko: "Re: Problem connecting from Enterprise Manager"
- Previous message: Rand Boyd [MSFT]: "RE: multiple sessions when using ADO"
- In reply to: John Bell: "Re: Temporary table disappears"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
