An unexpected error happened during this operation

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

An unexpected error happened during this operation

Author

Topic

peter_dtm
Starting Member

7 Posts

Posted - 2010-08-03 : 09:30:30

SQL 2000 SP4 Standard Edition

Dell 2850 W2K SP4 4GB

Recently the PDC was upgraded to a w2k3 DC. Following that move the following problems occur :

1) Try to open a table in Server Enterprise Manager gives this error :
An unexpected error happened during this operation, [MS Visual Database Tools] - Not enough storage is available top complete this operation

2) A previoullsy running SP now throws an error complaining that a cursor read from a table pvalue varchar(255) to @pvalue varchar(255) gives an error this is the actual error :
Server: Msg 245, Level 16, State 1, Procedure afReportSprayDryer, Line 138
Syntax error converting the varchar value '1.01' to a column of data type int.

code extract of line around 138

FOR READ ONLY

OPEN curFillEmpty

set @Error = 0

>>>>line 138>>>>>>>> FETCH NEXT FROM curFillEmpty INTO @lclTime, @Descript, @PValue

IF @@FETCH_STATUS <> 0
BEGIN
SET @TransferStart = @RBK_PhaseStart
set @ErrorMsg = 'Could not find report SPT_REPORT1' + '...'
set @Error = 1
END
ELSE SET @TransferStart = @lcltime -- define start for search for fines return

IF @RBK_Unit = 'H1E01' SET @Dstunit = 'L1D01'
IF @RBK_Unit = 'H2E01' SET @Dstunit = 'L2D01'

-- Find the powder tranport batches, that have cooperated with this batch
WHILE @@FETCH_STATUS = 0

3) If I try and open the SQL erro logs from SQL Server Ent Mnager I just get an egg timer - nor can I find ...\MICROSOFT SQL Server\ any sign of the logs (either under ..\80\ or ...\MSSQL

any help would be gratefully apreciated

Pete
-not everything digital is better ! -

peter_dtm
Starting Member

7 Posts

Posted - 2010-08-03 : 10:19:36

found the log files - hiding on D - current log file is some 48MB in size

Pete
-not everything digital is better ! -

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources