Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1513928615, index ID 0: Page (3:33709) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1513928615, index ID 0, page (3:33709), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 95 and 30.
DBCC results for 'Result'.
There are 41589306 rows in 660667 pages for object 'Result'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Result' (object ID 1513928615).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (LASAR2.dbo.Result ).
I have had several database errors (reported in event log) on our main database this morning. I assume this is due to faulty hardware etc (that's 'usually' the case, right?). Anyway, I have a maintenance plan in place that runs the 'DBCC CHECKDB ([ourdatabase])' command. However, this command constantly reported no problems with the database (0 errors).
1) Is the 'DBCC CHECKDB' command 'comprehensive' enough to find ANY/ALL errors in databases? 2) How do you run a repair on a suspected corrupted DB? (I have tried the REBUILD_REPAIR command but it fails...saying something about incorrect syntax (as if it's not a recognised command in QA) 3) I currently use Veritas Backup Exec's 'SQL Agent' to backup our SQL DB - I also run a maintenance job (via EM) to backup the DB throughout the day) 4) I have never restored our database from the 'file' backup that is created via the maintenance plan - How is this done? Note: I have tried restoring our DB backup from Veritas and it works fine, would just like to know how to do it from the file backup that is created via our maintenance plan? 5) Once a DB is restored, how do you replay the latest transaction log files etc?..
Notes: We are running SQL Server 2000 Std Ed and our database is only around 250MB
All; I have 14 errors in one of my tables and I know that all of you would recomend to restore form back-up. But i dont know when this table was corrupted and also loosing even days work is not an option. Below is what i received from DBCC CHECKDB ------ I dont mind loosing some data as far as i know what they are. Any way to know what will be lost?? Or any other way to restore rather than form the backup.... =================================================================== DBCC results for 'Call_Events'. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341561), slot 21, text ID 120642207744 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341564), slot 53, text ID 120686379008 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 23, text ID 120684609536 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 27, text ID 120684806144 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 28, text ID 120684937216 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341869), slot 0, text ID 120729305088 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342598), slot 45, text ID 120850743296 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342677), slot 58, text ID 120895897600 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:359535), slot 26, text ID 125433413632 is not referenced. There are 1108430 rows in 91674 pages for object 'Call_Events'. CHECKDB found 0 allocation errors and 14 consistency errors in table 'Call_Events' (object ID 2073058421).
I wrote a stored procedure that executes a dbcc sqlperf(logspace) statement many times. Therefore, I would like to suppress the output, "DBCC execution completed...". Can this be done? I have checked Books Online for a trace flag or set command to no avail.
I want to automate the dbcc checkdb process. I create a temp table called #CheckDbTbl and run the following command:
INSERT INTO #CheckDBTbl dbcc checkdb(MyDbName) with tableresults
I plan to send myself an email if any problems are found.
Does anyone know what Error numbers or Levels or anything else I should look for in the #CheckDBTbl that will tell me a problem exists? Right now I'm only checking for: Level >= 16.
When running the DBCC sqlperf (LRUSTATS) command I get an extremely high value for the Avg Free Page Scan. Typically, this value was between 1 and 2 for our SQL 6.0 Server, but in upgrading to SQL 6.5, it has jumped to about 200. Recently, I noticed another value looks suspect. The Max Free Page Scan is equal to 1, obviously not the *Max* value if the average is 200.
I know that others have seen this same behavior both in this group and in the microsoft newsgroups. It seems as though these values have been reversed or since every example I've seen posted by others has a 1.0 value for the Max, this parameter is not working at all.
An example of the output follows:
Statistic Value -------------------------------- ------------------------ Cache Hit Ratio 98.8573 Cache Flushes 4588.0 Free Page Scan (Avg) 184.768 Free Page Scan (Max) 1.0 Min Free Buffers 2048.0 Cache Size 24883.0 Free Buffers 2174.0
If anyone has information on this, or knows where I can go to get more information, it would be appreciated. Thanks, - Craig
I have a database with a corrupt table and no matter what I do (dbcc's and rebuilding indexes), there are row fetch errors still occurring daily. My solution now is just to drop the table and recreate it. Is it as simple as copying the data out of the original table, dropping the original table, and recreating the original table? What about the pointers to other pages? Referential integrety? Please give me a good reference for this subject or let me know. Thank you?
I get the following errors when I ran dbcc checkdb..
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13015). The PageId in the page header = (0:0). [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13039). The PageId in the page header = (0:0). [Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 18099105, index ID 0: Page (1:13015) could not be processed. See other errors for details. [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 18099105, index ID 1. Page (1:12777) is missing a reference from previous page (1:12567). Possible chain linkage problem.
and
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 562101043, index ID 2. The high key value on page (1:1779) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:13072).
What does it mean and how can i resolve them.... Database went into suspect mode , is this the likely cause..
I have a table in my database called Users:CREATE TABLE [Users] ([UserID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Users_UserID]DEFAULT (newid()),[UserName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[password] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[EmailAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_ASNOT NULL ,[ValidFrom] [datetime] NOT NULL ,[ValidTo] [datetime] NULL ,[passwordSalt] [bigint] NOT NULL ,[FullName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[CreatorUserID] [uniqueidentifier] NOT NULL ,[DeletorUserID] [uniqueidentifier] NULL ,CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED([UserID],[]) ON [PRIMARY] ,CONSTRAINT [UX_Users_UserName] UNIQUE NONCLUSTERED([UserName]) ON [PRIMARY] ,CONSTRAINT [FK_Users_UsersCreator] FOREIGN KEY([CreatorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [FK_Users_UsersDeletor] FOREIGN KEY([DeletorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [CK_Users_Finished] CHECK ([ValidTo] is null and[DeletorUserID] is null or ((not([ValidTo] is null))) and((not([DeletorUserID] is null)))),CONSTRAINT [CK_Users_ValidDates] CHECK ([ValidFrom] <= [ValidTo])) ON [PRIMARY]GOIf you're looking at the Primary Key constraint above, you can probablyalready see the problem (this script was produced by Query Analyzer).If I try to get query analyzer to just script the PK, I get thefollowing error message:[SQL-DMO]The name '' is not a valid object identifier, or is not avalid format for this property or method.I've googled for this phrase, and cannot locate it. If I drop all ofthe constraints in my database, and reapply the constraints to Usersusing the following script:alter table Users add constraintDF_Users_UserID DEFAULT NEWID() FOR UserIDgoalter table Users add constraintPK_Users PRIMARY KEY(UserID) on [PRIMARY]goalter table Users add constraintUX_Users_UserName UNIQUE(UserName)goalter table Users add constraintCK_Users_ValidDates CHECK(ValidFrom <= ValidTo)goalter table Users add constraintCK_Users_Finished CHECK((ValidTo is null andDeletorUserID is null)or(not ValidTo is null andnot DeletorUserID is null))goalter table Users add constraintFK_Users_UsersCreator FOREIGN KEY(CreatorUserID)REFERENCES Users(UserID)goalter table Users add constraintFK_Users_UsersDeletor FOREIGN KEY(DeletorUserID)REFERENCES Users(UserID)goI *still* have this wierd PK. I've checked through both theINFORMATION_SCHEMA views and directly through the system tables, and sofar as they are concerned there is only a single column (UserID) actingas part of the PK.So, any ideas? It appears to be preventing us from setting upreplication. Thankfully, it also occurs in a restored backup of the DB,so I'll be able to reproduce/attempt fixes to my hearts content.Thanks,Damien
Hi, I use SQL Server 2000 as a backend database for my Access Front end. It has been working fine for months with no problems. This morning I arrived in work to find a problem with a table called "TimeSheets". If I try to access the table through Access I get an ODBC timeout error. Likewise, if I open the table in Enterprise manager, it opens fine, but any sorts or if I try to go to the last record, it returns the following error: "[Microsoft][ODBC SQL Server Driver] Timout expired".
So I tried to query the table in SQL Query Analyzer. Everytime it freezes on record 15,936. The table holds 17,643 records.
I tried running DBCC CHECKTABLE ('Timesheets'), and get the following message:
DBCC results for 'Timesheet - Item'. There are 17643 rows in 401 pages for object 'Timesheet - Item'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I can't see any error messages, but by now I'm reaching the limit of my knowledge of SQL Server.
So, can anybody please help me with this? Any suggestions why my table has apparently become corrupted? Any suggestions how I might fix it?
Dear group,we are running a SQL-Server Database which is about 30 GB large. Thepurpose of this database is to contain periodic data from automaticdevices which insert values into some tables.Unfortunately most of these tables don't have a key (and a key can onlybe introduced when the application programmers have changed theirsoftware). Tables have this structuredeviceno timestamp datawhere we expect for every device and timestamp one row of data.In the ongoing operation it happens that the index of this large tablegets corrupted and a select from this table yields 2 rows for somedevices.In fact a select "SELECT DEVICENO, TIMESTAMP, COUNT(*) FROM TABLE GROUPBY DEVICENO, TIMESTAMP HAVING COUNT(*) > 1" returns lots of data.After rebuild of the indexes the table is "clean" again.What could cause the index corruption ?Missing key?Faulty application program ?a combination of both ?How can i prevent this from happening again, as long as there is noupdated database / application ?I'd be grateful for any useful commentRegardsUli
I have an old application running on SQL Server 6.5 (6.50.416) that has a number of internal issues - inability to dump the transaction logs (would dump 9gb out of a 10gb datbase everytime regardless of truncating the logs), transaction log size of 0 even though 700mb allocated, very long DBCC's (though they complete properly).
I am trying to salvage the database by using DTS to copy out the schema, data, sp's, etc. into a new database.
I have the conversion running without error. Data usage goes from almost 10gb down to under 3gb and the transaction logs are now working.
However, when I use DBCC checkdb on the new database, I get the following (just a small sample):
Checking 524528902 Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25930 row#=10); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25930 row#=10 computed row length=551 row length on page=550 Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25941 row#=2); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25941 row#=2 computed row length=527 row length on page=526 Msg 2596, Level 16, State 1 Page pointer = 0x1b20a800, pageno = 25941, status = 0xD, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1794. The offset should be 1384. Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25967 row#=2); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25967 row#=2 computed row length=527 row length on page=526 Msg 2596, Level 16, State 1 Page pointer = 0x22ab9000, pageno = 25967, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1667. The offset should be 1345. Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26146 row#=0); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26146 row#=0 computed row length=551 row length on page=550 Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26151 row#=5); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26151 row#=5 computed row length=521 row length on page=520 Msg 2506, Level 16, State 3 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26163 row#=0); check adjust table in this row Msg 2524, Level 16, State 1 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26163 row#=0 computed row length=546 row length on page=545 Msg 2596, Level 16, State 1 Page pointer = 0x218ba800, pageno = 26163, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1387. The offset should be 577. etc...
The errors occur only on 3 specific user tables, and are consistent each time I try the conversion. Same exact page numbers and offsets (page pointers are of course different). I do not get any DBCC errors on the original DB at all. I can do select's on the tables without issue, and they seem to have the correct amount of data (did row counts and sums of various columns)
Any insight into what might be causing this or what the actual error is would be welcome.
I have Lookup task to determine if source data should be updated to or insert to the customer table. After Lookup task, the Error Output pipeline will redirect to insert new data to the table and the Output pipeline will update customer table. But these two tasks will be processing at the same time which causes stall on the process. Never end.....
The job is similiart to what Slow Changing Dimention does but it won't update the table at the same time.
I am playing with DBCC command to check the contsrainst on a perticular table (DBCC CHECKCONSTRAINTS ('myTable') WITH ALL_CONSTRAINTS), it always gives the following result:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I am facing a rather peculiar issue where I am getting a floating point exception error while rebuilding index for a particular table.
-------- Error Number : 3628
Message :
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled.
[Microsoft][ODBC SQL Server ------------ This seems to be a rare issue ( as acknowledged by microsoft ) and they seem to suggest that it happens with SQL Server 2000 SP3 . I migrated my database into an SQL Server 2000 SP4 and started the rebuild again .. .. But it still failed with the same error ..
Am just hoping the microsoft guys are wrong and many of you have actually faced this stuff before.. Please let me know.
Does anyone know if there is a simple way to get the results of a DBCCINPUTBUFFER() request into a table? I have a process for monitoringactivity that will give me the results of sp_who2 into a temp table,and want to scroll through the active connections and get the inputbuffers into another table for review:Insert into #TmpWhoexec sp_who2 'active'Something like that with the dbcc command.I am using SQL 2000 SP4.Thanks,Tom
Hi all, I want to save DBCC's result into a table to execute my statement but I don't know how to, exmple for DBCC OPENTRAN (my database) - how can I put SPID & UID to my variable from this statement? Thanks in advance Happy New Year PTH
I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:
Server: Msg 8966, Level 16, State 1, Line 1 Could not read and latch page (1:18645) with latch type SH. sysindexes failed. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.
Can someone please help me interpret this result set below and suggeston way I can speed up my table? What changes should I make?DBCC SHOWCONTIG scanning 'tblListing' table...Table: 'tblListing' (1092914965); index ID: 1, database ID: 13TABLE level scan performed.- Pages Scanned................................: 97044- Extents Scanned..............................: 12177- Extent Switches..............................: 13452- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 90.17% [12131:13453]- Logical Scan Fragmentation ..................: 0.86%- Extent Scan Fragmentation ...................: 2.68%- Avg. Bytes Free per Page.....................: 1415.8- Avg. Page Density (full).....................: 82.51%DBCC execution completed. If DBCC printed error messages, contact yoursystem administrator.Thank you.
how could I load "DBCC showcontig (@TableName) with tableResults" to a table? I created a table and let insert to it via above "DBCC...." but problem is the results with "DBCC execution completed. If DBCC printed error messages, contact your system administrator.", or how could I mute this output line for each table ? thanks David --========================================= DBCC execution completed. If DBCC printed error messages, contact your system administrator. ObjectName ObjectId IndexName IndexId Level Pages Rows MinimumRecordSize MaximumRecordSize AverageRecordSize ForwardedRecords Extents ExtentSwitches AverageFreeBytes AveragePageDensity ScanDensity BestCount ActualCount LogicalFragmentation ExtentFragmentation -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- -------------------- -------------------- ----------------- ----------------- ---------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- ---------------------- -------------------- -------------------- ---------------------- ---------------------- sysproxylogin 37575172 clust 1 0 0 0 0 0 0 0 0 0 0 0 100 0 0 0 0
I have a database that has had a full text index at some point in it's history - but no longer does. The database is currently at SQL 2012 compatibility, but it was created on SQL2000. It still appears to have a row in the internal table sys.sysftinds - but some of the column values are NULL, and NULLs are not allowed. The database fails DBCC checks because of this.
Msg 8970, Level 16, State 1, Line 2 Row error: Object ID 25, index ID 1, partition ID xxxx, alloc unit ID xxxx (type In-row data), page ID (1:xxxx), row ID 0. Column 'sensitivity' was created NOT NULL, but is NULL in the row. DBCC results for 'sys.sysftinds'.
There are 1 rows in 1 pages for object "sys.sysftinds".
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sys.sysftinds' (object ID 25).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (xxxx.sys.sysftinds).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Running DBCC with repair_allow_data_loss has not worked.
1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad
2) No queries, even queries that would return only 1 record complete execution against that table
3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.
4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.
5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.
6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table
Hi everyone, While creating a stored prodecure, I now that it is possible to use an output parameter which is a table. However, I do not know how to do it ?? In other words, I would like to return a table but as an output parameter, so how can this happen ?
First some background info. SQL Express Visual Studio 2005
VB.Net
Data.SQLClient Namespace
Well I was using the OUTPUT option in my program and it was great, i was returning my PrimaryKey from the newly inserted row. (I am using paramaters in my program and running a sqlCommand.ExecuteScalar)
I added trigger to the tblInfo, that after a Insert,Update, Delete it would perform a audit on the table saving the old info that was overritten, type of action taken (insert, update or delete), and who did it.
Well my OUTPUT didn't like that says, it can't do a OUTPUT on a table with a trigger.
--Error msg Msg 334, Level 16, State 1, Line 1 The target table 'tblInfo' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
So what am i supose to do? I want the audit to occur, but I walso want the primarykey without doing a select (maxID) which could potentially get the wrong id (multiuser).
I used the oTable.Script method to output the DDL for a Sql Server 2000 user defined table. The result is DDL with an error. I don't think the problem is with DMO itself so I posted this here. Note the 'TEXTIMAGE_ON ' clause. The table does not have a text column, and the DDL will not execute.
CREATE TABLE [MyTable] ( [FilterID] [int] IDENTITY (1, 1) NOT NULL , [LoanAgentID] [int] NOT NULL , [Key] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [IsActive] [int] NOT NULL , [tStamp] [timestamp] NOT NULL , [Formula] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [_AuditAddDt] [datetime] NOT NULL , [_AuditUpdateDt] [datetime] NOT NULL , CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED ( [FilterID] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
Server: Msg 1709, Level 16, State 1, Line 1 Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns.
I run a SQL query to select a few colums of data using a select statement, I want the output to be stored in the new table which can be defined in the SQL statement how can I do it?
I've been looking into using the ability to select the table of an OLEDB destination task based on a package variable but would like to know if this could be utilised in the following example.
I have a CSV file (potentially there are many) with a number of rows. The rows do not necessarily contain the same number of elements. Each row has an EventID and this is used to determine the database table that the row is to be inserted in.
Initially i thought about using a conditional split to send each row down the path relating to its event ID. There would be multiple destinations depending on the table. With the possibility of 60 to 70 different event ID's this is very quickly going to get out of hand in the designer. I'd like to know if it would be possible to set up a case statement (or similar) in a script component and specify the table name as a variable depending on the event ID. I'd then use this table variable to set the destination task's table property.
Does this sound like a possibility or do i have to go down the route of multiple paths?
The MS SQL Server SQLMaint Utility returned this error:
[4] Check System Data...
The following errors were found:
Database Corrupt: The last checkpoint in Sysdatabases is incorrect. Syslogs recorded a different checkpoint ** Execution Time: 0 hrs, 0 mins, 1 secs **
I've read that this is no big deal, that a row in the sysdatabases table hasn't been updated to reflect the latest checkpoint, and that rebooting the server would clear this. However, rebooting did not clear it. Any ideas? W.
