How To Write Error Logs In Notepad
Nov 27, 2013how to write a error logs in notepad in sql server 2008
View 3 Replies
ADVERTISEMENT
DB Engine :: Write Logs To Windows Event Logs?
Aug 6, 2015OS: Windows 2012 Enterprise
SQL Server: 2012 Enterprise
I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log.
Cannot Write To Logs?
Jun 20, 2007Hello guys and gals.
Firstly apologies for my limited knowledge on SQL2005. I have inherited a problem with a database!
All the information I have been given from a 3rd party is as follows:
"The error is that the logs can not be written to. Is there a problem with their file system? Looks like the database is on some form of SAN??" The SAN part can be ignored I think!
I have also been given this by the changepoint administrator.
"the components that failed are `Import Data into fact tables` and `Task ForwardView Time Entry Failed"
My first question is:
"What is the first thing I can do to troubleshoot this?"
Secondly:
"How can I fix it!"
Once again, apologies for the lack of information but any help you can give me would be much appreciated.
R
Error When Importing Text File - Saving In Notepad First Works
Mar 16, 2007I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message
Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067
However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.
The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.
The column has datatype DT_STR with a width of 500.
I use Locale Swedish and when I save in Notepad it is saved in ANSI,
I use Windows XP Swedish version.
SQL Server Logs (error Logs)
Aug 28, 2001When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.
QUESTION 1: Can I set the max size for an error log file? If so, how?
QUESTION 2: If not, is there a workaround?
Thanks
SQL Server To C++ Or Notepad
Jun 9, 2005Basically I'm working on a Web page in ASP.NET, we the nhave our SQL server database, and inside we have C++ which needs to be able to go through incoming files and perform some operations, as well as enter it into the SQL database, and retrieve information from it. But we haven't the foggiest as how to go about doing thing, our C++ programmer doesn't know how to set up a connection from SQL to his code. IS there A) a program that will convert the SQL data into a text file for him to read from with C++. B) A GOOD book that he can pick up that will help bridge the gap between his knowledge and the knowledge required. So far google hasn't represented much luck. Any advice pertaining to some way to allow our C++ guy to learn/or enable him to read data and insert data into a SQL server would be GREATLY appreciated.
View 7 Replies View RelatedOutput In Notepad
Mar 25, 2008hi friends,
Can any one tell how to save the O/P to notepad.@tmp variable output need to be stored in notepad
Create procedure testing
as
begin
set nocount on
--open cursor
print @tmp
--close cursor
set nocount off
How Can I Prevent That All Data Can Be Seen With Notepad?
Jan 10, 2007Hello,
is there a way to say to SQL Server to make the data not readable?
Regards
Markus
SQL Server 2012 :: How To Put Data To Notepad
Jun 18, 2015How to put data from sql SERVER to notepad using t-sql
I want to run select * from t1 and result i want in Notepad saved in some location. how to do this.
Creating Notepad File Through SQL Server 2005
Oct 29, 2007Hi friends, Is there any way to create a text file or word file through sql server 2005.If you have any source please suggest me.. P.Kumaran
View 3 Replies View RelatedHow To Link Mssql Data (tables) In Notepad (HTML)
Nov 29, 2006menardo writes "Hi there!
I'm a very newbie in SQL programming. Can anybody help me how do I start to learn scriptings.
Can you give me the process or scripts on how to export it??
Thanks in advance.
-menardo"
DTS Error Logs.
Mar 9, 2000I am currently trying to export from SQL to notes via NotesSQL.I have set up the necessary ODBC data sources & DTS job. I am encountering errors when I attempt to execute the DTS package . I.e "job failed"
- How do I drill down to aquire more detailed error logging on the package to find out exactly what's wrong with DTS?
Thanks
Paul
Error Logs
Oct 3, 2000When I'm in EM, there is one log that when I click on it to view it hangs my EM. All other logs (current and others) I can click and view just fine. I'm on my way out to the server to see the log in the file directory but what could cause this?
Thanks..
SQL Error Logs
Apr 18, 2000Is there another way to restart the SQL Error Log without shutting down and restarting the MSSQLserver service?
View 2 Replies View RelatedError Logs For JOB
May 25, 2008Hi ,
How can i create an error log txt file for the jobs at the sql2005? the same like it was in the 2000.
many thanks
Error Logs
Mar 14, 2007I created a package in SSIS, and used the SQL Server Agent to run the package. I get an error 'Package Execution Failed' everytime I run it throught the SQL Server Agent.I don't get an error if I run the package from SSIS.
I right-clicked in 'Control Flow' and clicked Logging to add a new log. After I re-run this again in the SQL Server Agent, where do I go to find the error log?
Out Of Control Error Logs
Jan 2, 2001I have recently uncovered a problem we are experiencing with SQL Server 6.5 Service Pack 4 (Don't ask) and wonder if anyone has seen this before, and maybe has a solution.
When viewing an errorlog either current or historic, via either enterprise manager of xp_readerrlog, occassionaly the network connection is dropped and the process runs out of control. The process is unkillable, as it is in a 'Critical Section' and does not respond to kill. The real problem is that the process is logging millions of errors of the form "...cannot send results to the front end..." at a rate of around 1GB / hour.
Any help would be much appreciated.
Cheers
BP
So Confused Need Help Regarding Error Logs And SQL
Jan 14, 2008I was under the impression or i always got following entries in SQL Agent error log when server restart and there are some entries in sql error log as well which confirms that server restarted. but today when i was checking error log i saw same entreis in SQL agent error log but there were no entries in server error log. now i got really confused whether my server is restarted or not........... because if it is restarted then there must be some messages in server error log.....
can some one please let me know when and why following messages appear in SQL Agent Error Log
Information,[171] There are 9 alert(s) in the alert cache
Warning,[425] delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (8) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (7) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (6) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (5) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (4) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (3) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (1) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (2) is less than poll interval for this alert (20 sec)
Information,[170] Populating alert cache...
Information,[168] There are 3 job(s) [0 disabled] in the job cache
Information,[297] SQLServer Message: 0<c/> SQLServerAgent Monitor started successfully. [SQLSTATE 01000]
Information,[133] Support engine started
Information,[167] Populating job cache...
Information,[110] Starting SQLServerAgent Monitor using '' as the notification recipient...
Information,[193] Alert engine started (using Eventlog Events)
Information,[146] Request servicer engine started
Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Information,[174] Job scheduler engine started (maximum worker threads: 800)
Information,[129] SQLAgent$XYZ starting under Windows NT service control
Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
Information,[124] Subsystem 'ANALYSISCOMMAND' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'ANALYSISQUERY' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'QueueReader' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'Merge' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'Distribution' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'LogReader' successfully loaded (maximum concurrency: 200)
Information,[124] Subsystem 'Snapshot' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'CmdExec' successfully loaded (maximum concurrency: 80)
Information,[124] Subsystem 'ActiveScripting' successfully loaded (maximum concurrency: 80)
Information,[124] Subsystem 'TSQL' successfully loaded (maximum concurrency: 160)
Information,[432] There are 10 subsystems in the subsystems cache
Information,[431] Populating subsystems cache...
Information,[339] Local computer is ABC running Windows NT 5.2 (3790) Service Pack 1
Information,[310] ** processor(s) and **** MB RAM detected
Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is ServerName
Information,[102] SQL Server ODBC driver version 9.00.2047
Information,[101] SQL Server ABC version 9.00.2047 (0 connection limit)
Information,[100] Microsoft SQLServerAgent version 9.00.2047.00 (x86 unicode retail build) : Process ID 8100
Error,[298] SQLServer Error: 2812<c/> Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)
SSIS Error Logs
Apr 1, 2008
Hi Everyone,
I am very new to Integration Services and need some help on how to capture any errors generated in the SSIS package when executed. Any idea how I can accomplish this?
Thank You
-Sam
SQL 2000 Reovery Fails Sometimes. Error Code (Error 3136). How To Make Database Write Mode?
Jan 7, 2008Hello,
I am applying hourly differential backup to the backup server from production with the following command. This command makes the database on standby server into read only mode.
RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'
Now I want to run a command which will put the database in write mode. I have created a job which would make the datbase Write mode. This job runs successfully sometimes and fails sometimes. I need to ensure that the job always succeeds. When it fails, how do I troubleshoot and what is the possible fix?
Thanks in advance.
The error message is
Cannot apply the backup on device 'E:SQL backup from productionSQL daily diff back up' to database 'ARSYSTEM'. [SQLSTATE 42000] (Error 3136) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The steps for the job are as follows with the failing step highlighted in bold.
copy /y "\172.31.9.12Remedy BackupackupSQL backupsql_full_backup" "E:SQL backup from productionsql_full_backup"
copy /y "\172.31.9.12Remedy BackupackupSQL backupSQL daily diff back up" "E:SQL backup from productionSQL daily diff back up"
xp_cmdshell 'net stop "bmc remedy action request system server"'
exec rp_kill_db_processes 'ARSYSTEM'
RESTORE DATABASE ARSYSTEM
FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH
MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
NORECOVERY
Failing step
RESTORE DATABASE ARSYSTEM
FROM DISK = 'E:SQL backup from productionSQL daily diff back up'
WITH
MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
RECOVERY
xp_cmdshell 'del /f "E:SQL backup from productionsql_full_backup"'
xp_cmdshell 'del /f "E:SQL backup from productionsql daily diff back up"'
xp_cmdshell 'net start "bmc remedy action request system server"'
I have scheduled the following hourly diffential restore job too which never fails.
RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'
EXEC MASTER..XP_CMDSHELL 'del /f "E:SQL backup from productionSQL daily diff back up"'
Permission To View Error Logs
Jan 4, 2001How can a person view the error logs without being an sa?
View 1 Replies View RelatedExecutive Error Logs---very Urgent
Jul 21, 2000Hi,
I want to see my sql executive error log but it grown like anything.
How i have to trucate my error log. I cannot stop my server now.
i am getting following message. and also suggest me what i have to do not to grow like this means 56.01 mb size.
The sql executive error log is 56.01 mb in size and loading it will consume considerble memory and may take several minutes to complete.
Now i want to see my executive error log , pls tell me what i have to do.
--rk
SQLServer2000 - Error Logs Change Loc
Jun 14, 2004The SqlServer2000 error logs go to Program FilesMicrosoft SQL ServerMssqlLog directory by default.
How can I change their location. I could change SqlServerAgent logs but did not find any help or way to change the location of these. Would anyone please help?
Thanks
Vinnie
SSIS Logs Vs Custom Logs Components
Feb 12, 2007Hi,
In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.
Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.
Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.
Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.
What do you think? Kindly advise.
Thanks in advance for your help and time.
Regards,
$wapnil
Trace Logs And Finding Error Source
Apr 19, 2006Hi All! Looking for some help with SQL errors.
We are using SQL 2005. Our server has been failing (service just stops responding) several times a week. We don't have a DB admin, just me, the developer, so please be patient.
I can view all the errors in the existing trace through the Profiler, but not sure how to follow error to query source.
How do you use the trace logs to find the problem query?
I have two significant errors in my logs. One is Hash Warning and the other is Missing Join Operand. I'm not interested in the general causes of these types of errors, that info has been easy to find.
I don't know how to link or otherwise associate a particular instance of an error in the trace logs to the query that caused it to determine the query that is causing the trouble.
The traces are already on the server. I've never created a new trace. I believe they are generated automatically by the server...
Can someone shed some light on how these existing traces are being generated and how I can modify them to include the data I need? When I open an existing trace on the server and view the properties, events tab, there appears to be no way to select the column "TextData" (no checkboxes) for the two errors we are seeing (listed above).
If the TextData column for the errors will allow me to see the offending query, can someone please tell me how to enable that column in my traces that are currently being generated on the server?
Thank you!
Drew
Setup Failed For Error Logs And Cnfgsvr.out
Feb 22, 2001I am trying to install the SQL7 server, at the end of the installation before
rebooting the server I got the following error:
"Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information". I have not seen that error before. I cannot install the SQL7 because I always get the same message. Your help would be very appreciate helping me to solve this problem.
Thanks.
Timestamp Error While Restoring Transaction Logs
Feb 10, 2000I have scheduled a database backup at 9 pm and 5 Transaction Log backups. The transaction Log backups happen at 11 am, 1 pm, 3 pm and 5 pm (device does not get initialized) and one at 11 pm where i initialize the backup device. now i have another server with the same database on it. I restore these backups on to this server by simple copying the files and then doing Restore ...From Device...Add file...option. I am able to restore the DB backup but when i try to restore the log backups it get the error msg -
'Specified file 'G:...' is out of sequence. current time stamp is Feb 9 2000 3:54 pm while dump was from Feb 9 2000 3 pm.'
When i am restoring the logs i start from the 1st backup buyt still i get this error. Can someone pls let me know what the problem is and how to resolve it. Thanks.
Default Number Of Error Logs=6 - What Is Best Practice?
May 8, 2007What is best practise for what this number should be?
I have seen guidance saying set to a number greater than 25000, but not from any source I particularly know or trust. (I checked SANS, NIST-CIS and the NSA, but I couldn't find anything.
SQL Server 2005 Error Logs Grow Exponentially
Dec 12, 2007I have seen a couple of cases where an error occurs on a server running SQL Server 2005, and very quickly the log folder at MSSQL.1MSSQLLOG starts filling up with files, and does not stop until the entire hard drive is full (at which time the server stops responding). Is there any way to limit the number of .dmp files that are written?
View 7 Replies View RelatedLocked Process Hang Ups Not In Error Logs?? Memory Usage Too??
Jul 20, 2005Details:MS SQL 2000 dual Intel 1.2 GHz processors.1 GB RAM2.1 GB dBDynamic Memory Managment.No other apps running on this server.First question:Since I have Dynamic Memory Managment setup, Is it usuall that thesqlsrv.exe process on the server steadily climbs and is in the 800 to900 MB range. There is only about 20 MB free. In theory this is howDMM can work, but do people really see it work this way.Second question:I had users complaining about lockups in the app I have to supportthat connects to this dB. At first I thought it was the large use ofmemory, but once I was able to see in Enterprise Manager that therewas process blocking several other processes. EM then locked up and Icouldn't get to the details of what the exact process was that wasdoing the blocking. After restarting SQL services things were fine.When I checked the logs there was nothing there about a hung process.The logs seemed very sparse. Why would there not be anything in thelogs about it. The logs actually seem very thin on any information.Thanks,T.
View 1 Replies View RelatedDB Write Error
Aug 10, 2005Hi, Any info will be greatly appreciated to fix this issue.
I am getting the following errors in my event log.
Error: 823, Severity: 24, State: 2
I/O error 2(The system cannot find the file specified.) detected during read at offset 0x00000004f7e000 in file 'F:Program FilesMicrosoft SQL ServerMSSQLDataPENANGwiptrack_targetpng_data2.ndf'.
I am getting these error when I run DBCC:
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:9944) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9945) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9946) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9947) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9948) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9949) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9950) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9951) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10168) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10169) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10170) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10171) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10173) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10174) with latch type UP. 2(The system cannot find the file specified.) failed.
DBCC results for 'PNG_TARGET'.
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:10175) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10176) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10177) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10178) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10179) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10180) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10181) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10182) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10183) with latch type UP. 2(The system cannot find the file specified.) failed.
CHECKDB found 0 allocation errors and 23 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 215 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 220 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1390 rows in 78 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 187 rows in 64 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 4 rows in 1 pages for object 'sysfiles1'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:87967) is missing a reference from previous page (3:10176). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:88969) is missing a reference from previous page (3:10183). Possible chain linkage problem.
DBCC results for 'syspermissions'.
There are 221 rows in 4 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 255 rows in 4 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 570 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'TblReject'.
There are 396620 rows in 10949 pages for object 'TblReject'.
DBCC results for 'TblBoxGroup'.
There are 22669 rows in 380 pages for object 'TblBoxGroup'.
DBCC results for 'TblCustShipment'.
There are 4425 rows in 83 pages for object 'TblCustShipment'.
DBCC results for 'TblFlowDetail'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10176) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 10 refers to child page (3:10176) and previous child (3:10177), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10177) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10177) was not seen in the scan although its parent (1:90702) and previous (1:87966) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10178) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 13 refers to child page (3:10178) and previous child (3:10179), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10179) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10179) was not seen in the scan although its parent (1:90702) and previous (1:87967) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10180) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 14 refers to child page (3:10180) and previous child (3:10178), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10181) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 15 refers to child page (3:10181) and previous child (3:10180), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10182) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 16 refers to child page (3:10182) and previous child (3:10181), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10183) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 17 refers to child page (3:10183) and previous child (3:10182), but they were not encountered.
There are 523629 rows in 9233 pages for object 'TblFlowDetail'.
CHECKDB found 0 allocation errors and 18 consistency errors in table 'TblFlowDetail' (object ID 421576540).
DBCC results for 'TblJob'.
There are 18895 rows in 623 pages for object 'TblJob'.
DBCC results for 'TblRejectDetailCross'.
There are 0 rows in 0 pages for object 'TblRejectDetailCross'.
DBCC results for 'TblStationChkPoint'.
There are 298610 rows in 6273 pages for object 'TblStationChkPoint'.
DBCC results for 'ci_control_TblBoxGroup'.
There are 0 rows in 1 pages for object 'ci_control_TblBoxGroup'.
DBCC results for 'ci_control_TblCustomer'.
There are 0 rows in 0 pages for object 'ci_control_TblCustomer'.
DBCC results for 'TblLine'.
There are 7 rows in 1 pages for object 'TblLine'.
DBCC results for 'ci_control_TblCustShipment'.
There are 0 rows in 1 pages for object 'ci_control_TblCustShipment'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:65650) is missing a reference from previous page (3:9950). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:80141) is missing a reference from previous page (3:9949). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:81931) is missing a reference from previous page (3:9948). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:88745) is missing a reference from previous page (3:9944). Possible chain linkage problem.
DBCC results for 'ci_control_TblDefect'.
There are 0 rows in 1 pages for object 'ci_control_TblDefect'.
DBCC results for 'ci_control_TblFlowDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblFlowDetail'.
DBCC results for 'TblStationQty'.
There are 487814 rows in 8946 pages for object 'TblStationQty'.
DBCC results for 'TblMachine'.
There are 5 rows in 1 pages for object 'TblMachine'.
DBCC results for 'ci_control_TblJob'.
There are 0 rows in 1 pages for object 'ci_control_TblJob'.
DBCC results for 'ci_control_TblJobDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblJobDetail'.
DBCC results for 'TblOperator'.
There are 470 rows in 7 pages for object 'TblOperator'.
DBCC results for 'ci_control_TblLine'.
There are 0 rows in 0 pages for object 'ci_control_TblLine'.
DBCC results for 'TblOperatorGroup'.
There are 22 rows in 1 pages for object 'TblOperatorGroup'.
DBCC results for 'TblTransaction'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:91159) is missing a reference from previous page (3:9945). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:95791) is missing a reference from previous page (3:9951). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:857249) is missing a reference from previous page (3:9946). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9630) is missing a reference from previous page (3:9947). Possible chain linkage problem.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9944) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9944) was not seen in the scan although its parent (1:86516) and previous (3:10996) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9945) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9945) was not seen in the scan although its parent (1:862260) and previous (1:81719) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9946) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9946) was not seen in the scan although its parent (1:2888) and previous (1:39804) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9947) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9947) was not seen in the scan although its parent (1:858889) and previous (1:84220) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9948) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9948) was not seen in the scan although its parent (1:51120) and previous (1:81279) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9949) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9949) was not seen in the scan although its parent (1:81180) and previous (1:79351) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9950) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9950) was not seen in the scan although its parent (1:51120) and previous (1:65448) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9951) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9951) was not seen in the scan although its parent (1:60668) and previous (1:87177) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:921) is missing a reference from previous page (3:10169). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:17475) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:55333) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:58600) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:66724) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73049) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73183) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:77526) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:80853) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:82680) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:83104) is missing a reference from previous page (3:10170). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:83310) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:85752) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:87603) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:91416) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:91418) is missing a reference from previous page (3:10173). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:92037) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:92278) is missing references from parent (unknown) and previous (page (3:10168)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:94476) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:98109) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:99231) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:100289) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:103626) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:104154) is missing a reference from previous page (3:10175). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:104303) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:107339) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:110106) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:985785) is missing a reference from previous page (3:10174). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989636) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989637) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989638) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989639) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989640) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989641) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989642) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989643) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989644) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989645) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989646) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989647) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989648) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989652) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989653) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989654) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989655) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989656) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989657) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989658) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989659) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989660) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989661) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989662) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989663) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989664) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989665) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989666) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989667) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989668) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989669) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989670) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989671) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989672) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989673) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989674) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989675) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989677) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:990949) is missing a reference from previous page (3:10171). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:4460) was not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10168) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. The next pointer of (1:83310) refers to page (3:10168). Neither (3:10168) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10169) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10169) was not seen in the scan although its parent (1:9152) and previous (1:989626) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10170) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10170) was not seen in the scan although its parent (1:76565) and previous (1:83980) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10171) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10171) was not seen in the scan although its parent (1:925) and previous (1:34912) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10173) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10173) was not seen in the scan although its parent (1:76565) and previous (1:78785) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10174) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10174) was not seen in the scan although its parent (1:985742) and previous (1:80575) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10175) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10175) was not seen in the scan although its parent (1:88169) and previous (1:83978) refer to it. Check any previous errors.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:10339) was not encountered.
There are 4277643 rows in 97804 pages for object 'TblTransaction'.
CHECKDB found 0 allocation errors and 111 consistency errors in table 'TblTransaction' (object ID 768057822).
DBCC results for 'ci_control_TblLot'.
There are 0 rows in 1 pages for object 'ci_control_TblLot'.
DBCC results for 'ci_control_TblMachine'.
There are 0 rows in 0 pages for object 'ci_control_TblMachine'.
DBCC results for 'ci_control_TblOperator'.
There are 0 rows in 1 pages for object 'ci_control_TblOperator'.
DBCC results for 'ci_control_TblOperatorGroup'.
There are 0 rows in 0 pages for object 'ci_control_TblOperatorGroup'.
DBCC results for 'TtmpTransaction'.
There are 0 rows in 0 pages for object 'TtmpTransaction'.
DBCC results for 'TblCPQWeekNbr'.
There are 53 rows in 1 pages for object 'TblCPQWeekNbr'.
DBCC results for 'ci_control_TblPartDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblPartDetail'.
DBCC results for 'TblCPQYearNbr'.
There are 180 rows in 1 pages for object 'TblCPQYearNbr'.
DBCC results for 'TblKitModSNRship'.
There are 472666 rows in 5462 pages for object 'TblKitModSNRship'.
DBCC results for 'ci_control_TblPartSupplier'.
There are 0 rows in 0 pages for object 'ci_control_TblPartSupplier'.
DBCC results for 'TblShift'.
There are 3 rows in 1 pages for object 'TblShift'.
DBCC results for 'ci_control_TblReject'.
There are 0 rows in 1 pages for object 'ci_control_TblReject'.
DBCC results for 'ci_control_TblRejectDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblRejectDetail'.
DBCC results for 'ci_control_TblShift'.
There are 0 rows in 0 pages for object 'ci_control_TblShift'.
DBCC results for 'ci_control_TblStation'.
There are 0 rows in 1 pages for object 'ci_control_TblStation'.
DBCC results for 'ci_control_TblStationChkPoint'.
There are 0 rows in 1 pages for object 'ci_control_TblStationChkPoint'.
DBCC results for 'ci_control_TblStationQty'.
There are 3 rows in 1 pages for object 'ci_control_TblStationQty'.
DBCC results for 'ci_control_TblTester'.
There are 0 rows in 0 pages for object 'ci_control_TblTester'.
DBCC results for 'ci_control_TblTransaction'.
There are 0 rows in 1 pages for object 'ci_control_TblTransaction'.
DBCC results for 'TblCustomer'.
There are 7 rows in 1 pages for object 'TblCustomer'.
DBCC results for 'TblTester'.
There are 16 rows in 1 pages for object 'TblTester'.
DBCC results for 'ci_control_TblKitModSNRship'.
There are 0 rows in 1 pages for object 'ci_control_TblKitModSNRship'.
DBCC results for 'ci_control_TblSystemBuild'.
There are 1 rows in 1 pages for object 'ci_control_TblSystemBuild'.
DBCC results for 'TblRejectDetail'.
There are 104402 rows in 2403 pages for object 'TblRejectDetail'.
DBCC results for 'TblJobDetail'.
There are 1107946 rows in 23608 pages for object 'TblJobDetail'.
DBCC results for 'TblPartSupplier'.
There are 79 rows in 1 pages for object 'TblPartSupplier'.
DBCC results for 'TblDefect'.
There are 21113 rows in 337 pages for object 'TblDefect'.
DBCC results for 'png_ci_TblRowCount'.
There are 24 rows in 1 pages for object 'png_ci_TblRowCount'.
DBCC results for 'TblTbSetup'.
There are 1 rows in 1 pages for object 'TblTbSetup'.
DBCC results for 'TblStationQty1'.
There are 61755 rows in 974 pages for object 'TblStationQty1'.
DBCC results for 'TtmpStationProdLoad'.
There are 57 rows in 1 pages for object 'TtmpStationProdLoad'.
DBCC results for 'TblPartDetail'.
There are 3053 rows in 93 pages for object 'TblPartDetail'.
DBCC results for 'TblLot'.
There are 515677 rows in 11268 pages for object 'TblLot'.
DBCC results for 'TblStation'.
There are 474 rows in 11 pages for object 'TblStation'.
DBCC results for 'TblSystemBuild'.
There are 128623 rows in 2362 pages for object 'TblSystemBuild'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'TblEqMaster'.
There are 0 rows in 1 pages for object 'TblEqMaster'.
DBCC results for 'TblEqMasterSNRShip'.
There are 0 rows in 1 pages for object 'TblEqMasterSNRShip'.
CHECKDB found 0 allocation errors and 152 consistency errors in database 'PNG_TARGET'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PNG_TARGET ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Error/Failure Audit In Event Logs (SQL 2005 Express) [Advanced Services]
Aug 9, 2007Q1: Any way to control which db loads when, and perhaps stop this error from happening? Again- when all is said and done, the report server functions, and I am able to access just fine.
Q2: What kind of recovery is being referred to? Given the message type- I assume it's nothing of concern- probably more to do with a system that doesn't run all the time.
Okay- so I get these two event messages each time I boot.
Below are two error message I see daily with each system boot- the services mentioned do "actually" function, and are running- as not 10 seconds after these messages are logged, the successfully loaded messages appear. It's almost as if report services tries to connect before the databases are up and running.
Basically the sequence (today) was:
1. 05:49:01 Failure Audit (MSSQL$SQLEXPRESS)
2. 05:49:01 Error (Report Server Windows Service (SQLEXPRESS)
3. 05:49:02 Recovery is complete. (EventID 3408 MSSQL$SQLEXPRESS)
4. 05:49:06 Starting up database 'ReportServer'
5. 05:49:09 Server Resumed execution (MSSQL$SQLEXPRESS)
I'm assuming based on the events that Report Server Service attempts to connect to the ReportServer database before it's actually started. Doesn't really explain the failure audit-
1. Failure Audit:
Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 8/9/2007
Time: 05:49:01
User: <MACHINENAME><LOCALUSER>
Computer: <MACHINENAME>
Description:
Login failed for user '<MACHINENAME><LOCALUSER>'.
[CLIENT: <local machine>]
This is almost immediately followed by this (which I consider a no-brainer, considering the above):
2. Error:
Event Type: Error
Event Source: Report Server Windows Service (SQLEXPRESS)
Event Category: Management
Event ID: 107
Date: 8/9/2007
Time: 05:49:01
User: N/A
Computer: <MACHINENAME>
Description:
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.
Error Trying To Write File
Aug 3, 2004I don't have direct access to the SQL server. I have to write/read through a class I recieved from the IT department. The class also had an example in it but I can't get it to work correctly.
I get an error: Object reference not set to an instance of an object. Line 35
Dim clsWDD As New WebDevDB.WebDevDB
Dim intLeng As Int32
Dim intLock As Int32
Dim strAppl As String = "MyApplication"
Dim strData As String = "This is my text data!"
Dim strFile As String = "MyFile"
intLock = clsWDD.LockTextFile(strAppl, strFile) 'line 35
intLeng = clsWDD.WriteTextFile(strAppl, strFile, strData, WriteAction.Create)
intLock = clsWDD.UnlockTextFile(intLock)