Re: Changing stored procedure Freezes Crystal
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 22 Aug 2006 21:51:52 +0000 (UTC)
soulkitchen (esoulkitchen@xxxxxxxxx) writes:
I hope someone can answer this question.... The problem above was
happening, and I did not do anything to fix it, but the next day the
problem went away. I can't imagine what could have happened over night
to fix my problem. I do transaction log backups on the hour, and a full
database backup once a week, but no last night.
To answer what happened in an office building far far away is kind of
difficult, but I will have to guess that you restarted something.
A possibility is also that there was a blocking issue. With the situation
gone all we can do is guess.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Changing stored procedure Freezes Crystal
- From: soulkitchen
- Re: Changing stored procedure Freezes Crystal
- From: Erland Sommarskog
- Re: Changing stored procedure Freezes Crystal
- From: soulkitchen
- Re: Changing stored procedure Freezes Crystal
- From: soulkitchen
- Re: Changing stored procedure Freezes Crystal
- From: soulkitchen
- Changing stored procedure Freezes Crystal
- Prev by Date: Re: SQL query dilemma
- Next by Date: Re: User authentication
- Previous by thread: Re: Changing stored procedure Freezes Crystal
- Next by thread: Move Databases on SQL 2000 Machines
- Index(es):
Relevant Pages
|
Loading
