Error 8646! URGENT! HELP!

Hello ALL!
I got strage problem. While perfoming long update i got error 8646 (The inde
x entry for row ID was not found in index ID 2, of table 641098466, in data
base 'MyBase').
At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a DELETE
or UPDATE Against a Table That Contains a Unicode Column with a Latin1_Gene
ral_BIN Collation'
But my collation is SQL_Latin1_general_CP1251_CI_AS and that table 64109846
6 have not Unicode Columns.
What is wrong?What does DBCC CHECKDB and DBCC CHECKCTALOG say? Any errors? You might just
have some database corruption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||All DBCC comand say nothing. After this error i run
dbcc checktable & dbcc dbreindex
After this all work fine until next ocurency of this error|||In addition to Tibor's suggestion,
Be watchful of potential hardware error which may be causing this... AND
since the index ID is = 2, this is a non-clustered index... You might try to
drop and re-create the non-clustered index...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||Yes its non-clustered index and i done drop and re-create...
Hardware problem...i do not think so. I shrink base, defragment, recreating
and so on. I think real place of this index derfert after this operations a
nd problem occured only in one table. This table at the and of transaction a
nd data move to it via trig
ger.

Error 823,17903,17951 server 7 sp2- UPDATE

Regarding the above errors, I decided to apply sp4. A copy of the database was made and placed on a test server and now we cannot start the SQL Server. I have checked the registration and all seems fine. Any ideas ?Check the contents of the ERRORLOG file in LOGS directory as well as Application and System errorlog in Event Viewer and let us know what you see there.|||You need to identify what the base cause of this problem is. The first step to doing that is reviewing all errors on the machine in question.|||The above problem is now okay. DBAs from another Department came over and assisted with the problem. Because we had problems moving the data to another location, we decided to make a copy of the database and run DBCC repair on the production database. This fixed the problem and only a few records were lost.
Thanks to all for your assistance.

error 8152 in sql update statement

hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.
Please post your DDL plus the statement that is giving you trouble.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"KristinaY" <KristinaY@.discussions.microsoft.com> wrote in message
news:56B41165-C240-4111-9914-04672C4FA8BF@.microsoft.com...
hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.

error 8152 in sql update statement

hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.Please post your DDL plus the statement that is giving you trouble.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"KristinaY" <KristinaY@.discussions.microsoft.com> wrote in message
news:56B41165-C240-4111-9914-04672C4FA8BF@.microsoft.com...
hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.sql

error 8152 in sql update statement

hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.Please post your DDL plus the statement that is giving you trouble.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"KristinaY" <KristinaY@.discussions.microsoft.com> wrote in message
news:56B41165-C240-4111-9914-04672C4FA8BF@.microsoft.com...
hi all.
I am doing a simple sql update and getting below error:
Error Messages:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
I verified that the values specified are within the column length limits of
the table. I tried to searche for troubleshooting guidelines and couldnt
find any.
Please assist. Thanks.

Error 8102:cannot update identity column

I set up replication on my DB between two server. The Publisher will not update tables on the Subscriber that use an identity column and I get an error"8102:cannot update identity column". I have looked around and can't seem to locate any solid fixes. If I remove the identity column from the subscribers tables the package works, but I am not able to use the DB on the subscriber because I need the Identity columns for my app to function properly. My Publisher and Subscriber are both running SQL Server 2000 Standard Edition SP3.

Thanks.Check out this MSDN Article:Replication: Managing Identity Values.

Terri|||Thanks for the reply, I already read this article and it solves the problem but creates another. The article does describe how to increment the Identity column on the subscriber, but it will not match the value on the publisher because you must set the ID column ranges in seperate blocks. Server P 1-1000 Server S 1001-2000 When 1 is used on P, it insert 1001 on S.

Here's what I'm doing and maybe there is another way to do it.

I have two servers running my application, 1 exposed to the Internet for client access and one for my Intranet. I need an exact replica of my database on the Internet server that is being updated periodically from my Intranet server. I am installing clustered servers soon but I need to have an interim solution in place until then. The publically exposed server is also to act as a backup in the event that my Intranet server goes down.

The database is currently being replicated between the servers, but the Identity columns on the subscriber are not set, so if we had to switch to it I would have to define the ID columns in my tables for my application to work properly.

Would it be okay to point my Internet servers WEB.CONFIG data connection string to the Intranet server and just allow the replication to continue as is, and if I do have an outage direct my Intranet traffic to the Internet server, change the conn string in the WEB.CONFIG and define the ID columns?

Thanks in advance.|||Is your Internet server then serving as a warm standby? Is it then basically a read-only version of the database on your Intranet server??

If so, I can telll you that we usetransaction log shipping to keep a warm standby of our database on a different server.

Otherwise, I'm sorry, replication is out of my league. We had used replication for a short while until we found out that it did not meet our needs (due in part to the IDENTITY column situation). With some research and effort we might have gotten replication to work, but log shipping was exactly right for us.

Terri
PS, if you haven't seen it, you might consider this article:Architecting Replication with Identity Columns
|||Transaction logs would work if I had the Enterprise version of SQL, but I won't have it for a few more months, at which point I am installing clustered servers. I think for the time being I am going to go with allowing it to replicate with no ID columns set on the subscriber. I only have 5, so if there was a problem I could just set the ID columns on the subscriber and then change my DB Connection in my WEB.CONFIG to point to it. This is however a temporary solution.

Thanks, I found your info most helpful.

error 8102:cannot update identity column

HI

I have 2 SQL Servers 2000 enterprise version. I setup a transactional replication between them. There is a table using identity feature and set to not for replication. On the server A as publication, B as Subscriber. I created table in B manually and set the name conflict in article default to keep existing data. When it replicates at the first time, everything is fine, but if there is some data added to the table in Server A, the replication fails, saying cannot update indentity column.

I read about something on add Set Identity on/off thing. But I dont know which SP I should add this to. Please help. As detail as possible. Thanks.There is a bug in the Managed Range Identity system. In Merge Replication I have found that while creating a publication using range identities it will work only the first time. Changing settings such as Publisher range or subscriber range does not have an effect. Also, deleting the subscriptions and publications DOES NOT remove the constraints from the affected subscriber tables. Also, the entry for the database in the replication distribution DB table MSrepl_identity_range does not get deleted and therefore the next time the publication is run it will not take the correct settings. In order to successfully recreate the subscription you must delete the row(s) from the afore mentioned table and remove all constraints manually. Only then will it work. If the constraints are not removed the subscriber will show the identity range as used up and will demand a re-sync, and the re-sync will have no effect.

Applies to SQL Server 2000 All SPs

You MUST delete all publications on the affected database and subscriptions first, then run SP_RemoveDBReplication DBName on the publisher and subscribers first then follow the steps above. You can sp_help to see what constraints are on the tables.|||I am sorry, if I undertsand you correctly what you are saying is that I cannot have a replication set up for identity enabled table?|||Originally posted by cobraeyez
I am sorry, if I undertsand you correctly what you are saying is that I cannot have a replication set up for identity enabled table?

no, you can set it up. Just keep in mind that there is a bug in SQL Server relating to the identitiy managing subsystem. What you want to do is delete the pub, subscriptions, drop the Check Constraints on all the subscription tables, find the Identity_Range table in the Replication Distribution database and delete all entries for the database that you are working on. Then recreate the publication and subcription and you will be fine.|||hey. thanks that SP_RemoveDBReplication thing works. :)|||ok, maybe I speak too quick, I think the insert works, but the update doesn't . If I modify a record in the publisher the replication failed again.

And what I did for fix the insert record is remove the publications and subscriptions and ran that RemoveReplication command on the DBs, there is no records in MSrepl_indentity_range table for me to delete.|||ok. The article containing the identitiy field is not set to range identitiy. When you set up the publication you need to click the "..." button to the right of the article name, then click the "Identity Range" tab. Enter your values and click OK to start the Identitiy Ranging.|||thanks, you mean the table article property button (...) right? In there, there is no Identity Range Tab. There are 3 tabs in it. General, Command, Snapshot.|||You will only have that tab on articles that have an identitiy column. Are you sure the article has an Identitiy?|||yes, and I am using sql 2000, identity is enabled and set not for replication|||You've got much of suggestions to the question, but I hope this MSDN Link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01d4.asp) also gives you much insight to resolve.

HTH|||I had a similar problem and it was because I had triggers and DRI on the same table

Error 8102: Cannot Update Identity Column

Hi,

I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.

However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.

I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".

Any idea?

Thanks.Originally posted by da_i256
Hi,

I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.

However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.

I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".

Any idea?

Thanks.

check this thread:
http://dbforums.com/arch/7/2003/5/779346|||thanks, harshal_in...

then link did provide some insights into the matter.

anyone else got any idea?

thanks.|||Have you gone thru the MSDN link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01d4.asp) referred in the above post, it must have resolved with the workaround mentioned.|||Thanks guys...

the problem solved... :>sql

Error 8102, Cannot update identity

Hi,
I have setup unidirectional transaction replication between two SQL2k
servers. On the subscription database I have set the PK as (Indentity not
for Replication).
I can insert and delete records on the publisher and they get replicated
without any errors, but on the updates I get an error.
The issue I belieive is with the generated sp_MSupd stored procedure. For
some reason it is tring to execute the first block even if the logic is
false.
Can someone please advise how to get around this issue.
Thanks
This problem is caused by updating the PK. You have to look at exactly what
the application which is modifying the data on the publisher is doing.
For some applications (including ones using the .net DataGrid component),
any update of any column in a table results in the update of all columns.
This is translated as a delete followed by an insert.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mm" <postto@.news.com> wrote in message
news:%23lUTk14mEHA.1296@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have setup unidirectional transaction replication between two SQL2k
> servers. On the subscription database I have set the PK as (Indentity not
> for Replication).
> I can insert and delete records on the publisher and they get replicated
> without any errors, but on the updates I get an error.
> The issue I belieive is with the generated sp_MSupd stored procedure. For
> some reason it is tring to execute the first block even if the logic is
> false.
> Can someone please advise how to get around this issue.
> Thanks
>
>

Error 7306 when trying to do an update on a linked server

Here is my query run on one server against a Linked server:
UPDATE [Linked-Name].dbname.dbo.[Table name]
SET TimeStamp = '1900-01-01 00:00:00'
WHERE ISDATE(TimeStamp) = 0
I get the following error message:
Could not open table '"dbname"."dbo"."Table name"' from OLE DB provider
'SQLOLEDB'. The provider could not support a row lookup position. The
provider indicates that conflicts occurred with other properties or
requirements.
[OLE/DB provider returned message: Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work
was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset
returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True
STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT
VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID
VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate
VALUE=True STATUS=DBPROPSTATUS_CONFLICTING],
[PROPID=DBPROP_IRowsetChange VA...
Please help!
Thanks.What platform is the linked server?
<ryan_willow@.hotmail.com> wrote in message
news:1150831576.021477.128570@.p79g2000cwp.googlegroups.com...
> Here is my query run on one server against a Linked server:
> UPDATE [Linked-Name].dbname.dbo.[Table name]
> SET TimeStamp = '1900-01-01 00:00:00'
> WHERE ISDATE(TimeStamp) = 0
> I get the following error message:
> Could not open table '"dbname"."dbo"."Table name"' from OLE DB provider
> 'SQLOLEDB'. The provider could not support a row lookup position. The
> provider indicates that conflicts occurred with other properties or
> requirements.
> [OLE/DB provider returned message: Multiple-step OLE DB operation
> generated errors. Check each OLE DB status value, if available. No work
> was done.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset
> returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True
> STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT
> VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID
> VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate
> VALUE=True STATUS=DBPROPSTATUS_CONFLICTING],
> [PROPID=DBPROP_IRowsetChange VA...
> Please help!
> Thanks.
>|||SQL Server 2000.
I believe that this is the problem:
http://msdn.microsoft.com/library/d...serr_2_4gqh.asp
i.e. UPDATE, and DELETE statements are not supported on the remote
table if the table does not have a unique index defined on it.
So now I'm here:
I've done DELETEs remotely and had no problem, only errors on UPDATE.
I don't want to modify this established database by defining unique
indices.
How can I get around this?
Mike C# wrote:
> What platform is the linked server?
> <ryan_willow@.hotmail.com> wrote in message
> news:1150831576.021477.128570@.p79g2000cwp.googlegroups.com...|||ryan_willow@.hotmail.com wrote:
> SQL Server 2000.
> I believe that this is the problem:
> http://msdn.microsoft.com/library/d...serr_2_4gqh.asp
> i.e. UPDATE, and DELETE statements are not supported on the remote
> table if the table does not have a unique index defined on it.
> So now I'm here:
> I've done DELETEs remotely and had no problem, only errors on UPDATE.
> I don't want to modify this established database by defining unique
> indices.
> How can I get around this?
> Mike C# wrote:
What is version of MDAC?
and Service Pack?
We have also a problem like this and after updating to latest version
problem was solved
Regards
Amish Shah

Error 7105

I have a vb program and database in sql server. the program run fine all the
while but today start i always hit 1 error when i do update. the error is
"Fatal Error 7105"... i have search in microsoft site and their explanation
is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
I suspect this is a message from sql server. i check the sql server, looks
like ok... then i try to shrink the database. Error 7105 come out again when
half shrink the database. the error message is "Error 7105: Page(1:136654),
slot 6 fot text, ntext, or image node does not exist."
so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
message : "Server: Msg 7995, Level 16, State 1, Line 1
Database 'WEBLOS' consistency errors in sysobjects, sysindexes, syscolumns,
or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator."
i really don't understant what is these error means. can somebody help me on
this?
thanx... thanx... thanx...Hi
Seems to me that your data is corrupted. Do you have a last backup of the
database?
"wlho" <wlho@.discussions.microsoft.com> wrote in message
news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> I have a vb program and database in sql server. the program run fine all
the
> while but today start i always hit 1 error when i do update. the error is
> "Fatal Error 7105"... i have search in microsoft site and their
explanation
> is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
> I suspect this is a message from sql server. i check the sql server, looks
> like ok... then i try to shrink the database. Error 7105 come out again
when
> half shrink the database. the error message is "Error 7105:
Page(1:136654),
> slot 6 fot text, ntext, or image node does not exist."
> so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
> message : "Server: Msg 7995, Level 16, State 1, Line 1
> Database 'WEBLOS' consistency errors in sysobjects, sysindexes,
syscolumns,
> or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator."
> i really don't understant what is these error means. can somebody help me
on
> this?
> thanx... thanx... thanx...|||because this is the development server, we didn't do backup for it. is there
any way to fix this problem?
"Uri Dimant" wrote:
> Hi
> Seems to me that your data is corrupted. Do you have a last backup of the
> database?
>
> "wlho" <wlho@.discussions.microsoft.com> wrote in message
> news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> > I have a vb program and database in sql server. the program run fine all
> the
> > while but today start i always hit 1 error when i do update. the error is
> > "Fatal Error 7105"... i have search in microsoft site and their
> explanation
> > is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
> >
> > I suspect this is a message from sql server. i check the sql server, looks
> > like ok... then i try to shrink the database. Error 7105 come out again
> when
> > half shrink the database. the error message is "Error 7105:
> Page(1:136654),
> > slot 6 fot text, ntext, or image node does not exist."
> >
> > so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
> > message : "Server: Msg 7995, Level 16, State 1, Line 1
> > Database 'WEBLOS' consistency errors in sysobjects, sysindexes,
> syscolumns,
> > or systypes prevent further CHECKDB processing.
> > DBCC execution completed. If DBCC printed error messages, contact your
> > system administrator."
> >
> > i really don't understant what is these error means. can somebody help me
> on
> > this?
> >
> > thanx... thanx... thanx...
>
>

Error 7105

I have a vb program and database in sql server. the program run fine all the
while but today start i always hit 1 error when i do update. the error is
"Fatal Error 7105"... i have search in microsoft site and their explanation
is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
I suspect this is a message from sql server. i check the sql server, looks
like ok... then i try to shrink the database. Error 7105 come out again when
half shrink the database. the error message is "Error 7105: Page(1:136654),
slot 6 fot text, ntext, or image node does not exist."
so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
message : "Server: Msg 7995, Level 16, State 1, Line 1
Database 'WEBLOS' consistency errors in sysobjects, sysindexes, syscolumns,
or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator."
i really don't understant what is these error means. can somebody help me on
this?
thanx... thanx... thanx...Hi
Seems to me that your data is corrupted. Do you have a last backup of the
database?
"wlho" <wlho@.discussions.microsoft.com> wrote in message
news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> I have a vb program and database in sql server. the program run fine all
the
> while but today start i always hit 1 error when i do update. the error is
> "Fatal Error 7105"... i have search in microsoft site and their
explanation
> is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
> I suspect this is a message from sql server. i check the sql server, looks
> like ok... then i try to shrink the database. Error 7105 come out again
when
> half shrink the database. the error message is "Error 7105:
Page(1:136654),
> slot 6 fot text, ntext, or image node does not exist."
> so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
> message : "Server: Msg 7995, Level 16, State 1, Line 1
> Database 'WEBLOS' consistency errors in sysobjects, sysindexes,
syscolumns,
> or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator."
> i really don't understant what is these error means. can somebody help me
on
> this?
> thanx... thanx... thanx...|||because this is the development server, we didn't do backup for it. is there
any way to fix this problem?
"Uri Dimant" wrote:

> Hi
> Seems to me that your data is corrupted. Do you have a last backup of the
> database?
>
> "wlho" <wlho@.discussions.microsoft.com> wrote in message
> news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> the
> explanation
> when
> Page(1:136654),
> syscolumns,
> on
>
>

Error 7105

I have a vb program and database in sql server. the program run fine all the
while but today start i always hit 1 error when i do update. the error is
"Fatal Error 7105"... i have search in microsoft site and their explanation
is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
I suspect this is a message from sql server. i check the sql server, looks
like ok... then i try to shrink the database. Error 7105 come out again when
half shrink the database. the error message is "Error 7105: Page(1:136654),
slot 6 fot text, ntext, or image node does not exist."
so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
message : "Server: Msg 7995, Level 16, State 1, Line 1
Database 'WEBLOS' consistency errors in sysobjects, sysindexes, syscolumns,
or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator."
i really don't understant what is these error means. can somebody help me on
this?
thanx... thanx... thanx...
Hi
Seems to me that your data is corrupted. Do you have a last backup of the
database?
"wlho" <wlho@.discussions.microsoft.com> wrote in message
news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> I have a vb program and database in sql server. the program run fine all
the
> while but today start i always hit 1 error when i do update. the error is
> "Fatal Error 7105"... i have search in microsoft site and their
explanation
> is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
> I suspect this is a message from sql server. i check the sql server, looks
> like ok... then i try to shrink the database. Error 7105 come out again
when
> half shrink the database. the error message is "Error 7105:
Page(1:136654),
> slot 6 fot text, ntext, or image node does not exist."
> so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
> message : "Server: Msg 7995, Level 16, State 1, Line 1
> Database 'WEBLOS' consistency errors in sysobjects, sysindexes,
syscolumns,
> or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator."
> i really don't understant what is these error means. can somebody help me
on
> this?
> thanx... thanx... thanx...
|||because this is the development server, we didn't do backup for it. is there
any way to fix this problem?
"Uri Dimant" wrote:

> Hi
> Seems to me that your data is corrupted. Do you have a last backup of the
> database?
>
> "wlho" <wlho@.discussions.microsoft.com> wrote in message
> news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> the
> explanation
> when
> Page(1:136654),
> syscolumns,
> on
>
>

ERROR 3027: CAN'T UPDATE

I IMPORTED A DATABASE FROM AN SQL SERVER 7.0 TO AN SQL
SERVER 2000. I CAN UPDATE THE TABLES DIRECTLY ON THE
SERVER, BUT WHEN I TRY TO DO IT WITH THE PROGRAM THAT USES
THE DATABASE, IT GIVES ME ERROR 3027: CAN'T UPDATE,
DATABASE OR OBJECT IS READ-ONLY. I HAVE GIVEN ALL THE
USERS THEIR RESPECTIVE RIGHTS ON THE NEW SERVER AND IN THE
DATABASE. I HAVE AN ".INI" FILE WHERE I CAN SET THE
SERVERNAME. DOES SOMEONE KNOW HOW TO SOLVE THIS.
Where are you getting the error and what is the full error
message? What is the programming language, API used to
access the database? Are you getting a 'Run-time error
'3027'? In that case, try adding a LockEdits property to the
OpenRecordset method if that's what the application is
using. Make sure you have primary keys or unique constraints
defined for the tables.
-Sue
On Fri, 6 Aug 2004 09:06:36 -0700, "SJURIC"
<SJURIC.STATIE@.AN.XACO.XEROX.COM> wrote:

>I IMPORTED A DATABASE FROM AN SQL SERVER 7.0 TO AN SQL
>SERVER 2000. I CAN UPDATE THE TABLES DIRECTLY ON THE
>SERVER, BUT WHEN I TRY TO DO IT WITH THE PROGRAM THAT USES
>THE DATABASE, IT GIVES ME ERROR 3027: CAN'T UPDATE,
>DATABASE OR OBJECT IS READ-ONLY. I HAVE GIVEN ALL THE
>USERS THEIR RESPECTIVE RIGHTS ON THE NEW SERVER AND IN THE
>DATABASE. I HAVE AN ".INI" FILE WHERE I CAN SET THE
>SERVERNAME. DOES SOMEONE KNOW HOW TO SOLVE THIS.
|||Thank you Sue. I discovered it was the Primary Keys that were not
transported along with the database when I wasn't logged on as the
administrator. My login has administrative rights, but it seems like
it's not the same as login in as the administrator. I couldn't thank you
earlier, because we were disconnected waiting on the new shields and
antivirus to arrive. Thanks again!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

ERROR 3027: CAN'T UPDATE

I IMPORTED A DATABASE FROM AN SQL SERVER 7.0 TO AN SQL
SERVER 2000. I CAN UPDATE THE TABLES DIRECTLY ON THE
SERVER, BUT WHEN I TRY TO DO IT WITH THE PROGRAM THAT USES
THE DATABASE, IT GIVES ME ERROR 3027: CAN'T UPDATE,
DATABASE OR OBJECT IS READ-ONLY. I HAVE GIVEN ALL THE
USERS THEIR RESPECTIVE RIGHTS ON THE NEW SERVER AND IN THE
DATABASE. I HAVE AN ".INI" FILE WHERE I CAN SET THE
SERVERNAME. DOES SOMEONE KNOW HOW TO SOLVE THIS.Where are you getting the error and what is the full error
message? What is the programming language, API used to
access the database? Are you getting a 'Run-time error
'3027'? In that case, try adding a LockEdits property to the
OpenRecordset method if that's what the application is
using. Make sure you have primary keys or unique constraints
defined for the tables.
-Sue
On Fri, 6 Aug 2004 09:06:36 -0700, "SJURIC"
<SJURIC.STATIE@.AN.XACO.XEROX.COM> wrote:

>I IMPORTED A DATABASE FROM AN SQL SERVER 7.0 TO AN SQL
>SERVER 2000. I CAN UPDATE THE TABLES DIRECTLY ON THE
>SERVER, BUT WHEN I TRY TO DO IT WITH THE PROGRAM THAT USES
>THE DATABASE, IT GIVES ME ERROR 3027: CAN'T UPDATE,
>DATABASE OR OBJECT IS READ-ONLY. I HAVE GIVEN ALL THE
>USERS THEIR RESPECTIVE RIGHTS ON THE NEW SERVER AND IN THE
>DATABASE. I HAVE AN ".INI" FILE WHERE I CAN SET THE
>SERVERNAME. DOES SOMEONE KNOW HOW TO SOLVE THIS.|||Thank you Sue. I discovered it was the Primary Keys that were not
transported along with the database when I wasn't logged on as the
administrator. My login has administrative rights, but it seems like
it's not the same as login in as the administrator. I couldn't thank you
earlier, because we were disconnected waiting on the new shields and
antivirus to arrive. Thanks again!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Error -2147467259 in Open Method

We have a SQL Server 2000 in a Windows 2003 Server, and we were working very well with the VB 6.0, but after an update in the Windows 2003, the Open method in ADO results in an error -2147467259 sometimes, but if we try the same code in a computer with another domain there are not any problem, some advice?I'd be inclined to suggest KB #168336 (http://support.microsoft.com/default.aspx?scid=kb;en-us;168336) as a first guess. Note that it is very important to retrieve ALL of the error objects returned, not just the first one!

-PatP

Error 208 when updating any Stored Procedure

Hey all,
I can't update any stored procedure in my database, even as an
admin. I get:
Error 208: Invalid object name 'storedprocedurename'
Any suggestions? I've done a search on the MS knowledgebase and
google but no luck. The user can't do it and myself as an admin can't
either.
The workaround right now is to drop the proc and re-create it with the
changes.who is the owner of the sp?
"Dave" <shoad316@.hotmail.com> wrote in message
news:78cf0572.0401131336.5d46a539@.posting.google.com...
> Hey all,
> I can't update any stored procedure in my database, even as an
> admin. I get:
> Error 208: Invalid object name 'storedprocedurename'
> Any suggestions? I've done a search on the MS knowledgebase and
> google but no luck. The user can't do it and myself as an admin can't
> either.
> The workaround right now is to drop the proc and re-create it with the
> changes.|||A user is the db_owner and its the same account trying to do the update.
Thanks
--
--
david.best@.sympatico.ca
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world. Those who understand binary,
and those who don't."
"NEW NAME, OLD GUY" <PLEASE!> wrote in message
news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...
> who is the owner of the sp?
> "Dave" <shoad316@.hotmail.com> wrote in message
> news:78cf0572.0401131336.5d46a539@.posting.google.com...
> > Hey all,
> >
> > I can't update any stored procedure in my database, even as an
> > admin. I get:
> >
> > Error 208: Invalid object name 'storedprocedurename'
> >
> > Any suggestions? I've done a search on the MS knowledgebase and
> > google but no luck. The user can't do it and myself as an admin can't
> > either.
> >
> > The workaround right now is to drop the proc and re-create it with the
> > changes.
>|||probably this should help
ALTER PROC owner_name.PROC_NAME
................
replace owner_name with the correct owner name.
"Dave Best" <david.bestNOSPAM@.sympatico.ca> wrote in message
news:RT0Nb.10886$881.1646973@.news20.bellglobal.com...
> A user is the db_owner and its the same account trying to do the update.
> Thanks
> --
> --
> david.best@.sympatico.ca
> "Thanks to the remote control I have the attention span of a gerbil!"
> "There are 10 types of people in the world. Those who understand binary,
> and those who don't."
> "NEW NAME, OLD GUY" <PLEASE!> wrote in message
> news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...
> > who is the owner of the sp?
> >
> > "Dave" <shoad316@.hotmail.com> wrote in message
> > news:78cf0572.0401131336.5d46a539@.posting.google.com...
> > > Hey all,
> > >
> > > I can't update any stored procedure in my database, even as an
> > > admin. I get:
> > >
> > > Error 208: Invalid object name 'storedprocedurename'
> > >
> > > Any suggestions? I've done a search on the MS knowledgebase and
> > > google but no luck. The user can't do it and myself as an admin can't
> > > either.
> > >
> > > The workaround right now is to drop the proc and re-create it with the
> > > changes.
> >
> >
>

Error 208 when updating any Stored Procedure

Hey all,
I can't update any stored procedure in my database, even as an
admin. I get:
Error 208: Invalid object name 'storedprocedurename'
Any suggestions? I've done a search on the MS knowledgebase and
google but no luck. The user can't do it and myself as an admin can't
either.
The workaround right now is to drop the proc and re-create it with the
changes.who is the owner of the sp?
"Dave" <shoad316@.hotmail.com> wrote in message
news:78cf0572.0401131336.5d46a539@.posting.google.com...

quote:

---

> Hey all,
> I can't update any stored procedure in my database, even as an
> admin. I get:
> Error 208: Invalid object name 'storedprocedurename'
> Any suggestions? I've done a search on the MS knowledgebase and
> google but no luck. The user can't do it and myself as an admin can't
> either.
> The workaround right now is to drop the proc and re-create it with the
> changes.

---

|||A user is the db_owner and its the same account trying to do the update.
Thanks
--
david.best@.sympatico.ca
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world. Those who understand binary,
and those who don't."
"NEW NAME, OLD GUY" <PLEASE!> wrote in message
news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...

quote:

---

> who is the owner of the sp?
> "Dave" <shoad316@.hotmail.com> wrote in message
> news:78cf0572.0401131336.5d46a539@.posting.google.com...
>

---

|||probably this should help
ALTER PROC owner_name.PROC_NAME
................
replace owner_name with the correct owner name.
"Dave Best" <david.bestNOSPAM@.sympatico.ca> wrote in message
news:RT0Nb.10886$881.1646973@.news20.bellglobal.com...

quote:

---

> A user is the db_owner and its the same account trying to do the update.
> Thanks
> --
> --
> david.best@.sympatico.ca
> "Thanks to the remote control I have the attention span of a gerbil!"
> "There are 10 types of people in the world. Those who understand binary,
> and those who don't."
> "NEW NAME, OLD GUY" <PLEASE!> wrote in message
> news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...
>

---