Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-07 : 09:06:06
|
| Michelle writes "SQL Server 7 sp 3Windows NT 4.0 (1381)Transaction Log Backup runs every 15 minutes and intermittently fails with: Msg 0, Sev 0: Unknown token received from SQL Server [SQLSTATE HY000]It rarely fails more than twice in a row.Numerous servers are running same stored procedure with no problems. The only KB article that I can find that comes even close to explaining this relates to cursors on version 6.5.Here's part of the SQL:DECLARE cDB CURSOR FOR SELECT [name] FROM sysdatabases WHERE [name] NOT IN('tempdb', 'Northwind', 'pubs', 'SQLPROFILE') ORDER BY [name], crdateOPEN cDBFETCH NEXT FROM cDB INTO @logWHILE (@@FETCH_STATUS=0) BEGINThanks,Michelle" |
|
|
|
|
|
Unknown Token Received