CHECKDB Error Documentation
Mar 7, 2007
Hi,
I have a question for Paul Randal. I was perusing the forums earlier and I came across a post where you mentioned that you had documented what each of the errors that CHECKDB returns means, but you did not link to this documentation. Perhaps I am just stupid, but I was unable to find this anywhere. Could you point me in the direction for this when you get a chance? I'd be interested in both the 2000 documentation and the 2005 documentation if you have it updated yet. Thanks.
Larry Taylor
Database Administrator
SchooleOne
View 2 Replies
ADVERTISEMENT
Dec 24, 2007
I am getting "General network error. Check your documentation."
I am using .net 1.1 to connect sql server 2005 database at remote place.
.net code is running on windows xp and database(Dev database) is running on windows 2003 server.
below is my code.
conn = new SqlConnection("Persist Security Info=False; User ID=xxx; Password=pwd; database=WBWT; server=machinename; Connect Timeout=300; Max Pool Size=10");
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure ;
cmd.CommandText = "TestForCollation";
SqlParameter param1 = new SqlParameter("@MESSAGE",SqlDbType.NVarChar, 100);
param1.Value= "Dhanaji";
param1.Direction = ParameterDirection.Input;
cmd.Parameters.Add( param1 );
SqlParameter param2 = new SqlParameter("@CATEGORY",SqlDbType.Char, 10);
param1.Value= "Patil";
param1.Direction = ParameterDirection.Input;
cmd.Parameters.Add( param2 );
adapter = new SqlDataAdapter((SqlCommand)cmd);
adapter.Fill(ds); // here it throws exception
When i use VARCHAR data type or Output parameter in stored procedure it gives this error.
For the stored procedure which has not any parameter or only input int parameter is executed sucessfully,
Same SP is excuted sucessfully on local machine. I need urgent help
Also same code works on another database at remote place(QA database)
Thanks
--Dhanaji
View 4 Replies
View Related
Feb 1, 2007
The javadoc for statement.setMaxRows(maxROWS) reads:
"Sets the limit for the maximum number of rows that any ResultSet
object can contain to the given number. If the limit is exceeded, the excess
rows are silently dropped."
In fact, it seems that the driver calls set rowcount MAXROWS on the connection.
While this superficially will work, if your query manipulates records sets that exceed MAXROWS, the subqueries will also be limited in their size. And this is not what you expect. The javadocs suggest that it is only the result that is truncated. Silently.
It seems that setFetchSize is more appropriate.
I am using a relatively recent jar (248KB).
I hope that somebody finds this useful and that the development team will adjust the javadocs or the behavior.
Other than that, thanks for a great driver! ;-)
View 1 Replies
View Related
May 7, 2007
Hi, I'm hoping somebody can help with an error received when actions are performed on any record. The error is received in a front end program that we cannot get support for. I'm not too familiar with SQL Server but can get by, does anybody have suggestions? Thanks
S1000:[Microsoft]pODBC SQL Server DRiver][SQL Server]Could not find the index entry for RID '16565ba0100' in index page [1:66796], index ID 0, database 'db1'.
The results found from checkdb are:
DBCC results for 'DB1'.
DBCC results for 'sysobjects'.
There are 155 rows in 3 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 300 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1327 rows in 24 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 127 rows in 15 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 49 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 309 rows in 1 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 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 'F_Company'.
There are 0 rows in 0 pages for object 'F_Company'.
DBCC results for 'F_Cr_Detail'.
There are 222 rows in 21 pages for object 'F_Cr_Detail'.
DBCC results for 'F_Department'.
There are 6 rows in 1 pages for object 'F_Department'.
DBCC results for 'F_Document'.
There are 0 rows in 0 pages for object 'F_Document'.
DBCC results for 'F_Entry'.
There are 231241 rows in 2387 pages for object 'F_Entry'.
DBCC results for 'F_GL_Asset'.
There are 0 rows in 0 pages for object 'F_GL_Asset'.
DBCC results for 'F_GL_Body'.
There are 2 rows in 1 pages for object 'F_GL_Body'.
DBCC results for 'F_Letter'.
There are 100 rows in 2 pages for object 'F_Letter'.
DBCC results for 'F_Pm_Allocate'.
There are 0 rows in 0 pages for object 'F_Pm_Allocate'.
DBCC results for 'F_Pm_Auto_Entry'.
There are 3 rows in 1 pages for object 'F_Pm_Auto_Entry'.
DBCC results for 'F_Pm_Expense'.
There are 13 rows in 1 pages for object 'F_Pm_Expense'.
DBCC results for 'F_Pm_Job_Type'.
There are 0 rows in 0 pages for object 'F_Pm_Job_Type'.
DBCC results for 'F_Pm_Key'.
There are 2408 rows in 15 pages for object 'F_Pm_Key'.
DBCC results for 'F_Pm_Landlord'.
There are 1560 rows in 84 pages for object 'F_Pm_Landlord'.
DBCC results for 'F_Preferences'.
There are 0 rows in 0 pages for object 'F_Preferences'.
DBCC results for 'F_Printer'.
There are 0 rows in 0 pages for object 'F_Printer'.
DBCC results for 'F_Reports'.
There are 1 rows in 1 pages for object 'F_Reports'.
DBCC results for 'F_Suburb'.
There are 18 rows in 1 pages for object 'F_Suburb'.
DBCC results for 'F_System'.
There are 1 rows in 1 pages for object 'F_System'.
DBCC results for 'F_TaskType'.
There are 2 rows in 1 pages for object 'F_TaskType'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1205579333, index ID 0: Page (1:66796) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1205579333, index ID 0, page (1:66796). Test (m_freeCnt == freeCnt) failed. Values are 8 and 251.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1205579333, index ID 0, page (1:66796). Test (emptySlotCnt == 0) failed. Values are 1 and 0.
DBCC results for 'F_Terminal'.
There are 8 rows in 1 pages for object 'F_Terminal'.
DBCC results for 'F_Type'.
There are 7 rows in 1 pages for object 'F_Type'.
DBCC results for 'F_User'.
There are 1 rows in 1 pages for object 'F_User'.
DBCC results for 'F_GL_Reconcile'.
There are 2908 rows in 12 pages for object 'F_GL_Reconcile'.
DBCC results for 'F_Pm_La_Pay'.
There are 0 rows in 0 pages for object 'F_Pm_La_Pay'.
DBCC results for 'F_Pm_Property'.
There are 2293 rows in 121 pages for object 'F_Pm_Property'.
DBCC results for 'F_Cr_Entry'.
There are 3 rows in 1 pages for object 'F_Cr_Entry'.
DBCC results for 'F_Cr_Type'.
There are 0 rows in 0 pages for object 'F_Cr_Type'.
DBCC results for 'F_GL_Entry'.
There are 1190 rows in 11 pages for object 'F_GL_Entry'.
DBCC results for 'F_Pm_P_Analysis'.
There are 0 rows in 0 pages for object 'F_Pm_P_Analysis'.
DBCC results for 'F_Pm_Tenant'.
There are 4927 rows in 354 pages for object 'F_Pm_Tenant'.
DBCC results for 'F_Task'.
There are 847 rows in 17 pages for object 'F_Task'.
DBCC results for 'F_Item'.
There are 439788 rows in 5531 pages for object 'F_Item'.
DBCC results for 'F_Pm_Auto_Item'.
There are 2 rows in 1 pages for object 'F_Pm_Auto_Item'.
DBCC results for 'F_Pm_Diary'.
There are 5732 rows in 78 pages for object 'F_Pm_Diary'.
DBCC results for 'F_Pm_Entry'.
There are 671566 rows in 22181 pages for object 'F_Pm_Entry'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'F_Pm_Entry' (object ID 1205579333).
DBCC results for 'F_Pm_Job'.
There are 4169 rows in 128 pages for object 'F_Pm_Job'.
DBCC results for 'F_Pm_Job_Entry'.
There are 0 rows in 0 pages for object 'F_Pm_Job_Entry'.
DBCC results for 'F_Ftp_Listings'.
There are 0 rows in 0 pages for object 'F_Ftp_Listings'.
DBCC results for 'F_Ftp_System'.
There are 0 rows in 0 pages for object 'F_Ftp_System'.
DBCC results for 'F_RealEnz2'.
There are 0 rows in 0 pages for object 'F_RealEnz2'.
DBCC results for 'F_Security'.
There are 4 rows in 1 pages for object 'F_Security'.
DBCC results for 'F_Auto_Entry'.
There are 0 rows in 0 pages for object 'F_Auto_Entry'.
DBCC results for 'F_Au_Item'.
There are 0 rows in 0 pages for object 'F_Au_Item'.
DBCC results for 'F_Log'.
There are 0 rows in 0 pages for object 'F_Log'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'F_Account'.
There are 229 rows in 3 pages for object 'F_Account'.
DBCC results for 'F_Analysis'.
There are 0 rows in 0 pages for object 'F_Analysis'.
DBCC results for 'F_Auto_Banking'.
There are 0 rows in 1 pages for object 'F_Auto_Banking'.
DBCC results for 'F_Branch'.
There are 3 rows in 1 pages for object 'F_Branch'.
DBCC results for 'F_Change'.
There are 5 rows in 1 pages for object 'F_Change'.
DBCC results for 'F_Clauses'.
There are 91 rows in 1 pages for object 'F_Clauses'.
CHECKDB found 0 allocation errors and 3 consistency errors in database 'rpm'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (db1 ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 19 Replies
View Related
May 15, 2006
Gurus
when i run checkdb i get this error
"Database 'master' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing."
What can be the cause?Can i fix this with repair option of check db?
Please advice
Regards
Nitin
View 20 Replies
View Related
Dec 4, 2006
Simon writes "There are error messages in our DBCC CheckDB job. It happens in two of tables. (See below for the sample error messages.)
I have found two postings in the forum; but it seems that they are not applicable to my situation:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65913
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55021
The errors happen to two of the user tables.
So my questions are:
1. How to fix these errors?
2. Are the records in the DB still good?
3. How to prevent this happening again?
The database server is running Windows 2000 sp4 and SQL 2000 sp3. It's running on the RAID5 in MS Cluster environment.
I really appreciate your assistance. Thank you.
The error message samples are:
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 27, text ID 25207869603840 is pointed to by page (1:1392667), slot 2 and by page (1:1210230), slot 10. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:130912), slot 30, text ID 25199404974080 does not match its reference from page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 30, text ID 25254380437504 is pointed to by page (1:1392667), slot 4 and by page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:134162), slot 23, text ID 25204615217152 is not referenced. [SQLSTATE 42000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 211 consistency errors in table 'TABLE_ONE' (object ID 837578022). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'TABLE_TWO'. [SQLSTATE 01000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 38, text ID 25496001314816 is pointed to by page (1:239021), slot 101 and by page (1:487008), slot 100. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:129320), slot 39, text ID 25199327903744 does not match its reference from page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 39, text ID 25496001642496 is pointed to by page (1:239021), slot 102 and by page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 1, text ID 25031875559424 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 2, text ID 25031875887104 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136603), slot 2, text ID 25031875231744 is not referenced. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 853578079, index ID 255: Page (1:137476) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 853578079, index ID 255, page (1:137476). Test (m_freeCnt == freeCnt) failed. Values are 357 and 525. [SQLSTATE 42000]
Msg 2593, Sev 16: There are 1972569 rows in 14051 pages for object 'TABLE_TWO'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 166 consistency errors in table 'TABLE_TWO' (object ID 853578079). [SQLSTATE 01000]"
View 2 Replies
View Related
Jan 29, 2001
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.
Many thanks for your responses!
-bh
View 1 Replies
View Related
Jan 28, 2005
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8999: [Microsoft][ODBC SQL Server Driver][SQL Server]Database tempdb allocation errors prevent further CHECKDB processing.
I get this error above when running a Checkdb on tempDB I haven't found out any fixes yet. I bounced the server service and the job runs, but after 2 days it fails again. Any ideas?
Thanks for your time.
View 1 Replies
View Related
Dec 12, 2005
When running DBCC CHECKDB with Repair_Rebuild option in sigle use mode I get 16 consistency error. the error message is always on object ID 2. Can someone tell what is Object ID 2 and what can be done to re-reference what is not referenced? The log follow!
Thanks!
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 8, text ID 37039898624 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 10, text ID 37039964160 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 12, text ID 37040029696 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 13, text ID 37040095232 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 6, text ID 35910909952 is not referenced. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'Datawarehouse'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1377 rows in 30 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 8, text ID 35910975488 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 10, text ID 35911041024 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 11, text ID 35911106560 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 12, text ID 35911172096 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 14, text ID 35911237632 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 1, text ID 37040160768 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 3, text ID 37040226304 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 1, text ID 37040291840 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 2, text ID 37040357376 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7699783), slot 1, text ID 35911303168 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7792736), slot 2, text ID 35911368704 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 3487 rows in 218 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 16 consistency errors in table 'sysindexes' (object ID 2). [SQLSTATE 01000]
View 1 Replies
View Related
Mar 26, 2007
Hi,
We are running 2005, 9.00.2047.00, and getting a consistency error on sys.sysschobjs. The system is running fine as far as I can tell. I don't see any documentation on how to repair the object, nor can I access it directly. Any suggestions/procedures on how fix it? If I leave it the way it is will what are the ramifications later on? Please find more detail on the CHECKDB error below.
Thanks for the help.
Rick
======================================================================
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Msg 2570, Sev 16, State 3, Line 17 : Page (1:1103587), slot 24 in object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type "In-row data"). Column "modified" value is out of range for data type "datetime". Update column to a legal value. [SQLSTATE 42000] Msg 8990, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysschobjs' (object ID 34). [SQLSTATE 01000] Msg 8989, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in database 'DV1'. [SQLSTATE 01000]
Job 'Check Database DV1 [20060816141231-0-030000]' : Step 1, 'Step1' : Began Executing 2006-08-18 03:00:00
DBCC CHECKDB (DV1) started at Aug 18 2006 3:00AM with Logfile: F:Program FilesMicrosoft SQL ServerMSSQL.1
View 9 Replies
View Related
Jun 1, 2006
When I run either "DBCC CHECKDB WITH NO_INFOMSGS" or using "check database integrity" in maintenance plan, I always got an error below:
The In-row data RSVD page count for object "tablename", index ID 0, partition ID 76911687696384, alloc unit ID 76911687696384 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'tablename' (object ID 1173579219).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'dbname'.
Can anyone help me please?
Regards,
View 10 Replies
View Related
Aug 16, 2005
Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
View 2 Replies
View Related
Dec 5, 2007
During the night I run a checkdb that reported a error in tempdb, log down in post for more info.
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.
If run a checkdb know it€™s not finding any problem. I€™m bit confused what to do restart the server to get new tempdb? I check with for SQL Server 2005 Books Online for the €śMSSQLSERVER_8974€? error, it tells me to look after a €śLook for Hardware Failure€?. In the sql server log its stands that its have found 82 errors
DBCC CHECKDB (tempdb) executed by AIR5MSSQLService found 82 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 3 seconds.
Directly after this a stackdump are generated. Somewhere in the middle of my dbcc script.
After the i get the result of the next databases.
DBCC CHECKDB (model) executed by AIR5MSSQLService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
This is compress version of the log of dbcc job
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "FLEFSE".
Maintenance Plan: UnderhĂĄll
Duration: 00:12:55
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity (FLEFSE)
Execute TSQL on Local server connection
Execution time out: 1800
Task start: 2007-12-05T02:00:01.
Task end: 2007-12-05T02:12:57.
Failed-1073548784) Executing the query "DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc='ONLINE'
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'CHECKING DATABASE ' + @DBNameVar
SET @Statement = N'USE ' + @DBNameVar + CHAR(13)
+ N'DBCC CHECKDB (' + @DBNameVar + N')'
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
" failed with the following error: "Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 1, text ID 296853897216 is not referenced.
... to ...
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 81, text ID 296871985152 is not referenced.
CHECKING DATABASE master
DBCC results for 'master'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.
DBCC results for 'mssqlsystemresource'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE tempdb
DBCC results for 'tempdb'.
.... removed lines ...
CHECKDB found 0 allocation errors and 82 consistency errors in table '#4225BEF1' (object ID 1109769969).
.... removed lines ...
CHECKDB found 0 allocation errors and 82 consistency errors in database 'tempdb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE model
DBCC results for 'model'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'model'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE msdb
DBCC results for 'msdb'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ReportServer
DBCC results for 'ReportServer'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServer'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ReportServerTempDB
DBCC results for 'ReportServerTempDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServerTempDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE caisqlp
DBCC results for 'caisqlp'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'caisqlp'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BKALKYL
DBCC results for 'BKALKYL'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BKALKYL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE distribution
DBCC results for 'distribution'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'distribution'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE DMVstatsDB
DBCC results for 'DMVstatsDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DMVstatsDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BALDATA
DBCC results for 'BALDATA'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BALDATA'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE VirtualCenterDB
DBCC results for 'VirtualCenterDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'VirtualCenterDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BINGE01
DBCC results for 'BINGE01'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BINGE01'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BMATINK
DBCC results for 'BMATINK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BMATINK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BORDE01
DBCC results for 'BORDE01'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BORDE01'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BSTATISTIK
DBCC results for 'BSTATISTIK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BSTATISTIK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE MPSmartDB
DBCC results for 'MPSmartDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MPSmartDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE SmarTeamPilot
DBCC results for 'SmarTeamPilot'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'SmarTeamPilot'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE STATISTIK
DBCC results for 'STATISTIK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'STATISTIK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE VBAS
DBCC results for 'VBAS'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'VBAS'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE MDataMM_0F
DBCC results for 'MDataMM_0F'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MDataMM_0F'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE DLDB
DBCC results for 'DLDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DLDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ILDB
DBCC results for 'ILDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ILDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE master;
GO
SET NOCOUNT ON;
GO
DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc=''ONLINE''
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N''CHECKING DATABASE '' + @DBNameVar
SET @Statement = N''USE '' + @DBNameVar + CHAR(13)
+ N''DBCC CHECKDB ('' + @DBNameVar + N'')''
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
GO
SET NOCOUNT OFF;
GO
This is the top of the stack-dump
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.3042.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Current time is 02:00:08 12/05/07.
8 Unknown CPU 9., 2333 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory
MemoryLoad = 98%
Total Physical = 8189 MB
Available Physical = 163 MB
Total Page File = 9795 MB
Available Page File = 1527 MB
Total Virtual = 8388607 MB
Available Virtual = 8373732 MB
DBCC RESULTS
--------------------
... lines removed ....
**Dump thread - spid = 107, PSS = 0x00000000EE497BC0, EC = 0x00000000EE497BD0
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0009.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/05/07 02:00:08 spid 107
*
* DBCC database corruption
*
* Input Buffer 510 bytes -
* DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
* SELECT name FROM sys.databases WHERE state_desc='ONLINE' OPEN AllDatab
* ases DECLARE @DBNameVar NVARCHAR(128) DECLARE @Statement NVARCHAR(30
* 0) FETCH NEXT FROM AllDatabases INTO @DBNameVar WHILE (@@FETCH_STATU
* S = 0) BEGIN PRINT N'CHECKING DATABASE ' + @DBNameVar SET @Stat
* ement = N'USE ' + @DBNameVar + CHAR(13) + N'DBCC CHECKDB (' + @DB
* NameVar + N')' EXEC sp_executesql @Statement PRINT CHAR(13) + C
* HAR(13) FETCH NEXT FROM AllDatabases INTO @DBNameVar END CLOSE A
* llDatabases DEALLOCATE AllDatabases
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
PSS @0x00000000EE497BC0
-----------------------
My DBCC script looks like this
USE master;
GO
SET NOCOUNT ON;
GO
DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc='ONLINE'
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'CHECKING DATABASE ' + @DBNameVar
SET @Statement = N'USE ' + @DBNameVar + CHAR(13)
+ N'DBCC CHECKDB (' + @DBNameVar + N')'
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
GO
SET NOCOUNT OFF;
GO
View 2 Replies
View Related
Apr 13, 2007
Hi all,
we've been having this ancient database with old accounting data running in suspect mode since as long as I can remember (I started working here a year ago), and finally I had some time on my hands so I thought I'd try to get it online again. However I'm running in to problems:
DBCC CHECKDB (myDBName) gives this error:
Msg 926, Level 14, State 1, Line 1
Database 'myDBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Running sp_helpdb only does not display the suspect database and sp_helpdb 'myDBName' gives this error even though I'm a system administrator:
No permission to access database 'myDBName'.
It's possible that I might be able to dig up a backup but that would be quite tedious. Is it possible to bring the database to a state where I'm able to do a CHECKDB at least...?
--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
View 5 Replies
View Related
Nov 27, 2007
every few days i'm getting an error in the application log , eventID 824, saying 'SQL Server detected a logical consistency-based i/o error; incorrect checksum. it then recommends completing a full database consistency check (dbcc checkdb).
i have run the dbcc checkdb ('databasename') and it is returning an error msg of:
Msg 8697, Level 16, State 215, Line 1
An internal error occurred in DBCC which prevented further processing
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors
i have oodles of disk space left. any ideas on where to go from here.
thank you for any help,
-Mark
View 3 Replies
View Related
Aug 22, 2013
We recently migrated our production server from SQL 2005 (Standard) on Win2003(32-bit) to SQL2012 (Standard; v11.0.3000) on Win2008-R2(64bit). Single-server Dell R510 with 1.2TB storage. Everything went smoothly; the only nagging issue remaining is failure of our maintenance jobs. I tracked the issue down to failure of DBCC CHECKDB. Specifically, the error is:Executed as user: NT SERVICESQLSERVERAGENT. The database could not be exclusively locked to perform the operation. [SQLSTATE 42000] (Error 5030) Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be lockedI have Googled this issue and read extensively. For instance, informative blogs (albeit dated) such as these by Paul Randal (Managing
CheckDB by default takes an internal DB snapshot to get the consistent, point-in-time view of the DB that it needs. If that snapshot creation fails, then it will try to get an exclusive database lock before proceeding (same as if you had executed DBCC CHECKDB WITH TABLOCK). The root problem is not that the lock could not be obtained, it's that the internal database snapshot could not be created. msdn.microsoft.com/en-us/library/ms188796.aspx details the specific situations when an internal database snapshot is not created and table locking is attempted.Â
 I have verified the SQLSERVERAGENT service account has full permissions on the SQLDATA directory where the databases reside and has full permissions on each database within the directory. Just for giggles, I created a job (run as SQLSERVERAGENT) that creates and then deletes a text file in the SQLDATA directory. It runs fine.
Also testedI get the snapshot creation error when manually running DBCC CHECKDB against any of our databases and when executing under a variety of administrator accounts that are members of the SQL sysadmin role and the Domain Admins security group (the Domain Admins is a member of the local Administrators group that has full permissions on all SQL directories/folders).
Additionally, the databases in question are small (200MB to 6GB) and the disk has plenty of elbow room (978GB free on 1.22TB RAID5 array) to create the internal database snapshots. CHECKDB doesn't surface an error message that is detailed enough to determine the precise cause of the error. Any example successfully running DBCC CHECKDB on the SQL2012 (Standard) on a Win2008 R2 (64-bit) server.
View 22 Replies
View Related
Oct 4, 2007
Hi Every one,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
View 3 Replies
View Related
May 26, 2007
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
View 2 Replies
View Related
Oct 4, 2007
Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
View 2 Replies
View Related
Feb 8, 2004
When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub
Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please Help!
Thank you,
dlouanis
View 2 Replies
View Related
Jan 9, 2006
I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.
I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.
I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.
I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.
The pocketPC is connected via activesync to the desktop, and I connect to the database with:
Integrated Security=false;
user id=sa
password=admin.
Any help with this strange error would be greatly appreciated.
Wil
View 5 Replies
View Related
Oct 11, 2006
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
View 1 Replies
View Related
Apr 14, 2015
I need to print in RED if there's atleast 1 or more consistency error and need a heading color of the table (Caption) how to do it.
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<H1>DB Corruption Report:</H1>' +
N'<table border="1">' +
N'<tr><th>DBName</th><th>MessageText</th>' +
[code]....
View 1 Replies
View Related
Jul 28, 2004
What information should I be documenting about a server (SQL) and about the databases found on that server. I was task with this job. Please help.
Thanks
Lystra
View 2 Replies
View Related
Nov 13, 2004
I'd like to go through and document the databases I'm responsible for...it's probably a good practice and I'm sure there a several approaches to doing so.
Anybody have comments, recommendations, or possibly a nice word template that links everything up?
Thanks for the input.
Alex
View 1 Replies
View Related
Mar 9, 2004
hello everyone,
I have to document about four databases, has anyone got any specific format or tool for documenting a database?
Any inputs would be very helpful
regards,
Harshal.
View 13 Replies
View Related
Jul 26, 2007
Will there ever be xml code documentation support inside of Sql Server projects?
View 1 Replies
View Related
May 5, 2008
Hi all
Could anyone tell me from where i can find complete Documentation for SQLDMO Object and how can i initialize
and use it in my programms?
Kind Regards.
View 1 Replies
View Related
Dec 3, 2005
Does anyone knows a good FREE tool for documenting a DB?
so far i'm with ApexSQL but its not free, wondering if anyone knows a free tool.
Thanks,
View 1 Replies
View Related
Nov 9, 2004
Hi guys,
Can any one tell me about any Database Documentation Tool for SQL server.
Please reply asap.
Junaid
View 5 Replies
View Related
Oct 16, 1998
I am looking for good utilities that document MS SQL table schema, indexes, layouts etc. I am currently looking at SQL auditor, but this product does not give me table schema or any kind of device revisions. I recently was given several SQL servers that have not been documented in any way.
thanks
ps SQL auditor gets a B+ in my book. Let me know what you think
View 2 Replies
View Related
Sep 20, 2005
Hallo !
Right now I am looking for the query-code to delete a table (not only the rows, but all of it). Somebody could give me the code?
In general I am always looking for a place on the web, where all sql-server 2005 (express) query-functions are explained. Somebody knows the right place?
Thank you very much!
Regards,
Fabain
View 6 Replies
View Related
Jun 13, 2007
Can anyone advise me on what they regard as the best SQL Server documentation tool. I am currently looking at Redgate and ApexSQL products. Do any of you have experience with these or others? I need one that will document 2000 and 2005 databases.
Thanks.
View 15 Replies
View Related
