database file has incorrect modified date

Hello all,
I have a very critical data file currently in use showing a modified date of
5/13/06, and the file is modified very often by an invoice application. When
I attempt to do a restore the file has the right date, I don't understand wh
y
the modified date is incorrect.
Should the file modified date not be very current, although if query for
invoices with date greater than 6/2 it return several. am I missreading the
modified date?
Please help.ITDUDE27 wrote on Mon, 5 Jun 2006 09:05:01 -0700:

> Hello all,
> I have a very critical data file currently in use showing a modified date
> of 5/13/06, and the file is modified very often by an invoice application.
> When I attempt to do a restore the file has the right date, I don't
> understand why the modified date is incorrect.
> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
> the modified date?
> Please help.
You can't go by the last modified date of the mdf/ldf files on the hard
disk, as these dates are only normally updated when SQL Server feels the
need to. I have a database on my main server right now that processes all
the transactions for the company and has a last modified date of 25th May
2006, and a matching LDF with last modified of 15th September 2005.
Actually, most of the files in there are dated 15th Sept 2005, which is the
day this server had them all restored to it when it went live.
Dan|||"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:1A118DF6-E57A-428A-935D-AE676D8BEF83@.microsoft.com...
> Hello all,
> I have a very critical data file currently in use showing a modified date
of
> 5/13/06, and the file is modified very often by an invoice application.
When
> I attempt to do a restore the file has the right date, I don't understand
why
> the modified date is incorrect.
>
The last modified date will only change when the file size is changed or the
database is open or closed.
Unless you have autoclose enabled (you should NOT normally) the only time
the database will normally close is when you stop or start the server.
If your server is up for a year, it's not unheard of to have a last modified
date of a year ago.

> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
the
> modified date?
> Please help.

database file has incorrect modified date

Hello all,
I have a very critical data file currently in use showing a modified date of
5/13/06, and the file is modified very often by an invoice application. When
I attempt to do a restore the file has the right date, I don't understand why
the modified date is incorrect.
Should the file modified date not be very current, although if query for
invoices with date greater than 6/2 it return several. am I missreading the
modified date?
Please help.ITDUDE27 wrote on Mon, 5 Jun 2006 09:05:01 -0700:
> Hello all,
> I have a very critical data file currently in use showing a modified date
> of 5/13/06, and the file is modified very often by an invoice application.
> When I attempt to do a restore the file has the right date, I don't
> understand why the modified date is incorrect.
> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
> the modified date?
> Please help.
You can't go by the last modified date of the mdf/ldf files on the hard
disk, as these dates are only normally updated when SQL Server feels the
need to. I have a database on my main server right now that processes all
the transactions for the company and has a last modified date of 25th May
2006, and a matching LDF with last modified of 15th September 2005.
Actually, most of the files in there are dated 15th Sept 2005, which is the
day this server had them all restored to it when it went live.
Dan|||"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:1A118DF6-E57A-428A-935D-AE676D8BEF83@.microsoft.com...
> Hello all,
> I have a very critical data file currently in use showing a modified date
of
> 5/13/06, and the file is modified very often by an invoice application.
When
> I attempt to do a restore the file has the right date, I don't understand
why
> the modified date is incorrect.
>
The last modified date will only change when the file size is changed or the
database is open or closed.
Unless you have autoclose enabled (you should NOT normally) the only time
the database will normally close is when you stop or start the server.
If your server is up for a year, it's not unheard of to have a last modified
date of a year ago.
> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
the
> modified date?
> Please help.

Database Corruption (Please help!)

Hi,
I created a nonclustered index on sysobjects table. After that, when I
create a new object and sysobjects is modified, the database does not work
properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
object is created, again database get corrupted (CHECKDB reports error). I
cannot drop this index with DROP INDEX command.
I'm wondered if an index on system table cannot be dropped, why it can be
created? If it is allowed to create index, why it corrupts the database?
Any help would be greatly appreciated.
Leila
Leila
First of all , go to the ERROR.LOG and see what is going on?
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I created a nonclustered index on sysobjects table. After that, when I
> create a new object and sysobjects is modified, the database does not work
> properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
> object is created, again database get corrupted (CHECKDB reports error). I
> cannot drop this index with DROP INDEX command.
> I'm wondered if an index on system table cannot be dropped, why it can be
> created? If it is allowed to create index, why it corrupts the database?
> Any help would be greatly appreciated.
> Leila
>
|||I found this link but I don't know how to drop the index!
http://support.microsoft.com/kb/106122
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Leila
> First of all , go to the ERROR.LOG and see what is going on?
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>
|||Leila
There are pretty good examples telling how to do that
"Leila" <Leilas@.hotpop.com> wrote in message
news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>I found this link but I don't know how to drop the index!
> http://support.microsoft.com/kb/106122
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>
|||But I didn't find any example about dropping an index in this article
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Leila
> There are pretty good examples telling how to do that
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>
|||It does not drop the index, it fixes the index ( perhaps by droping it)
:-)))) Do you have a good backup of the database?
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
> But I didn't find any example about dropping an index in this article
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
>
|||We discovered this problem a little late. This exists in the database since
10 days ago. If we restore the backup before the corruption, 10 days of
users work will lost!
That article mentions that you can drop the index of system tables but I
couldn't find anything!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eDZm7edIHHA.3424@.TK2MSFTNGP02.phx.gbl...
> It does not drop the index, it fixes the index ( perhaps by droping it)
> :-)))) Do you have a good backup of the database?
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
>
|||This option does not help
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EandTgIHHA.3268@.TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> You might be able to do it if you sp_configure 'allow updates'. Not sure,
> though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
|||Leila (Leilas@.hotpop.com) writes:
> I created a nonclustered index on sysobjects table.
Uh-uh, never do that again, promise? :-)

> After that, when I create a new object and sysobjects is modified, the
> database does not work properly. I used DBCC CHECKDB to repair it. It
> works but as soon as a new object is created, again database get
> corrupted (CHECKDB reports error). I cannot drop this index with DROP
> INDEX command. I'm wondered if an index on system table cannot be
> dropped, why it can be created? If it is allowed to create index, why it
> corrupts the database?
It seems that you need to enable "Allow updates" to create an index on a
system table. With this setting all bets are off anyway.
I would recommend that you create a new database from scripts and bulk
data over.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Perfect Match Finder
http://www.max-online.biz/idevaffiliate/idevaffiliate.php?id=804
Online Web Promotion
http://www.max-online.biz/idevaffiliate/idevaffiliate.php?id=804
For further details email me at maxonline.sunil@.gmail.com

Database Corruption (Please help!)

Hi,
I created a nonclustered index on sysobjects table. After that, when I
create a new object and sysobjects is modified, the database does not work
properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
object is created, again database get corrupted (CHECKDB reports error). I
cannot drop this index with DROP INDEX command.
I'm wondered if an index on system table cannot be dropped, why it can be
created? If it is allowed to create index, why it corrupts the database?
Any help would be greatly appreciated.
LeilaLeila
First of all , go to the ERROR.LOG and see what is going on?
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I created a nonclustered index on sysobjects table. After that, when I
> create a new object and sysobjects is modified, the database does not work
> properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
> object is created, again database get corrupted (CHECKDB reports error). I
> cannot drop this index with DROP INDEX command.
> I'm wondered if an index on system table cannot be dropped, why it can be
> created? If it is allowed to create index, why it corrupts the database?
> Any help would be greatly appreciated.
> Leila
>|||I found this link but I don't know how to drop the index!
http://support.microsoft.com/kb/106122
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Leila
> First of all , go to the ERROR.LOG and see what is going on?
> http://www.karaszi.com/SQLServer/in..._suspect_db.asp
>
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>|||Leila
There are pretty good examples telling how to do that
"Leila" <Leilas@.hotpop.com> wrote in message
news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>I found this link but I don't know how to drop the index!
> http://support.microsoft.com/kb/106122
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>|||But I didn't find any example about dropping an index in this article
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Leila
> There are pretty good examples telling how to do that
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>|||It does not drop the index, it fixes the index ( perhaps by droping it)
:-)))) Do you have a good backup of the database?
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
> But I didn't find any example about dropping an index in this article
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
>|||We discovered this problem a little late. This exists in the database since
10 days ago. If we restore the backup before the corruption, 10 days of
users work will lost!
That article mentions that you can drop the index of system tables but I
couldn't find anything!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eDZm7edIHHA.3424@.TK2MSFTNGP02.phx.gbl...
> It does not drop the index, it fixes the index ( perhaps by droping it)
> :-)))) Do you have a good backup of the database?
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
>|||You might be able to do it if you sp_configure 'allow updates'. Not sure, th
ough.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leila" <Leilas@.hotpop.com> wrote in message news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...

> Hi,
> I created a nonclustered index on sysobjects table. After that, when I
> create a new object and sysobjects is modified, the database does not work
> properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
> object is created, again database get corrupted (CHECKDB reports error). I
> cannot drop this index with DROP INDEX command.
> I'm wondered if an index on system table cannot be dropped, why it can be
> created? If it is allowed to create index, why it corrupts the database?
> Any help would be greatly appreciated.
> Leila
>|||This option does not help
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EandTgIHHA.3268@.TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> You might be able to do it if you sp_configure 'allow updates'. Not sure,
> though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...|||Leila (Leilas@.hotpop.com) writes:
> I created a nonclustered index on sysobjects table.
Uh-uh, never do that again, promise? :-)

> After that, when I create a new object and sysobjects is modified, the
> database does not work properly. I used DBCC CHECKDB to repair it. It
> works but as soon as a new object is created, again database get
> corrupted (CHECKDB reports error). I cannot drop this index with DROP
> INDEX command. I'm wondered if an index on system table cannot be
> dropped, why it can be created? If it is allowed to create index, why it
> corrupts the database?
It seems that you need to enable "Allow updates" to create an index on a
system table. With this setting all bets are off anyway.
I would recommend that you create a new database from scripts and bulk
data over.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Database Corruption (Please help!)

Hi,
I created a nonclustered index on sysobjects table. After that, when I
create a new object and sysobjects is modified, the database does not work
properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
object is created, again database get corrupted (CHECKDB reports error). I
cannot drop this index with DROP INDEX command.
I'm wondered if an index on system table cannot be dropped, why it can be
created? If it is allowed to create index, why it corrupts the database?
I found this link:
http://support.microsoft.com/kb/106122
Although it mentions SP_FixIndex can drop such indexes but there are no description about it.
Any help would be greatly appreciated.
LeilaToday's lesson: "Don't f*** with system tables."|||Any solution?!..|||You may be able to drop the index if you run the SET OPTION command to allow changed to system objects.
Make sure you execute the command to disallow changes when you are done!|||It doesn't allow to drop index from system tables|||Did you try the SET OPTION command?
Otherwise, create a new blank database and copy your production tables to it, and then drop the old database with its corrupted system table.

Database Corruption (Please help!)

Hi,
I created a nonclustered index on sysobjects table. After that, when I
create a new object and sysobjects is modified, the database does not work
properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
object is created, again database get corrupted (CHECKDB reports error). I
cannot drop this index with DROP INDEX command.
I'm wondered if an index on system table cannot be dropped, why it can be
created? If it is allowed to create index, why it corrupts the database?
Any help would be greatly appreciated.
LeilaLeila
First of all , go to the ERROR.LOG and see what is going on?
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I created a nonclustered index on sysobjects table. After that, when I
> create a new object and sysobjects is modified, the database does not work
> properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
> object is created, again database get corrupted (CHECKDB reports error). I
> cannot drop this index with DROP INDEX command.
> I'm wondered if an index on system table cannot be dropped, why it can be
> created? If it is allowed to create index, why it corrupts the database?
> Any help would be greatly appreciated.
> Leila
>|||I found this link but I don't know how to drop the index!
http://support.microsoft.com/kb/106122
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Leila
> First of all , go to the ERROR.LOG and see what is going on?
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when I
>> create a new object and sysobjects is modified, the database does not
>> work properly. I used DBCC CHECKDB to repair it. It works but as soon as
>> a new object is created, again database get corrupted (CHECKDB reports
>> error). I cannot drop this index with DROP INDEX command.
>> I'm wondered if an index on system table cannot be dropped, why it can be
>> created? If it is allowed to create index, why it corrupts the database?
>> Any help would be greatly appreciated.
>> Leila
>|||Leila
There are pretty good examples telling how to do that
"Leila" <Leilas@.hotpop.com> wrote in message
news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>I found this link but I don't know how to drop the index!
> http://support.microsoft.com/kb/106122
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> First of all , go to the ERROR.LOG and see what is going on?
>> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>>
>>
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when I
>> create a new object and sysobjects is modified, the database does not
>> work properly. I used DBCC CHECKDB to repair it. It works but as soon as
>> a new object is created, again database get corrupted (CHECKDB reports
>> error). I cannot drop this index with DROP INDEX command.
>> I'm wondered if an index on system table cannot be dropped, why it can
>> be created? If it is allowed to create index, why it corrupts the
>> database?
>> Any help would be greatly appreciated.
>> Leila
>>
>|||But I didn't find any example about dropping an index in this article
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Leila
> There are pretty good examples telling how to do that
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>>I found this link but I don't know how to drop the index!
>> http://support.microsoft.com/kb/106122
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> First of all , go to the ERROR.LOG and see what is going on?
>> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>>
>>
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when I
>> create a new object and sysobjects is modified, the database does not
>> work properly. I used DBCC CHECKDB to repair it. It works but as soon
>> as a new object is created, again database get corrupted (CHECKDB
>> reports error). I cannot drop this index with DROP INDEX command.
>> I'm wondered if an index on system table cannot be dropped, why it can
>> be created? If it is allowed to create index, why it corrupts the
>> database?
>> Any help would be greatly appreciated.
>> Leila
>>
>>
>|||It does not drop the index, it fixes the index ( perhaps by droping it)
:-)))) Do you have a good backup of the database?
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
> But I didn't find any example about dropping an index in this article
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> There are pretty good examples telling how to do that
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>>I found this link but I don't know how to drop the index!
>> http://support.microsoft.com/kb/106122
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> First of all , go to the ERROR.LOG and see what is going on?
>> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>>
>>
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when I
>> create a new object and sysobjects is modified, the database does not
>> work properly. I used DBCC CHECKDB to repair it. It works but as soon
>> as a new object is created, again database get corrupted (CHECKDB
>> reports error). I cannot drop this index with DROP INDEX command.
>> I'm wondered if an index on system table cannot be dropped, why it can
>> be created? If it is allowed to create index, why it corrupts the
>> database?
>> Any help would be greatly appreciated.
>> Leila
>>
>>
>>
>|||We discovered this problem a little late. This exists in the database since
10 days ago. If we restore the backup before the corruption, 10 days of
users work will lost!
That article mentions that you can drop the index of system tables but I
couldn't find anything!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eDZm7edIHHA.3424@.TK2MSFTNGP02.phx.gbl...
> It does not drop the index, it fixes the index ( perhaps by droping it)
> :-)))) Do you have a good backup of the database?
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23GS$VYdIHHA.536@.TK2MSFTNGP02.phx.gbl...
>> But I didn't find any example about dropping an index in this article
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:uZQr3VdIHHA.2456@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> There are pretty good examples telling how to do that
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%238EDYTdIHHA.1468@.TK2MSFTNGP04.phx.gbl...
>>I found this link but I don't know how to drop the index!
>> http://support.microsoft.com/kb/106122
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eAUl4QdIHHA.3872@.TK2MSFTNGP06.phx.gbl...
>> Leila
>> First of all , go to the ERROR.LOG and see what is going on?
>> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>>
>>
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when
>> I create a new object and sysobjects is modified, the database does
>> not work properly. I used DBCC CHECKDB to repair it. It works but as
>> soon as a new object is created, again database get corrupted
>> (CHECKDB reports error). I cannot drop this index with DROP INDEX
>> command.
>> I'm wondered if an index on system table cannot be dropped, why it
>> can be created? If it is allowed to create index, why it corrupts the
>> database?
>> Any help would be greatly appreciated.
>> Leila
>>
>>
>>
>>
>|||You might be able to do it if you sp_configure 'allow updates'. Not sure, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leila" <Leilas@.hotpop.com> wrote in message news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I created a nonclustered index on sysobjects table. After that, when I
> create a new object and sysobjects is modified, the database does not work
> properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
> object is created, again database get corrupted (CHECKDB reports error). I
> cannot drop this index with DROP INDEX command.
> I'm wondered if an index on system table cannot be dropped, why it can be
> created? If it is allowed to create index, why it corrupts the database?
> Any help would be greatly appreciated.
> Leila
>|||This option does not help :(
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EandTgIHHA.3268@.TK2MSFTNGP04.phx.gbl...
> You might be able to do it if you sp_configure 'allow updates'. Not sure,
> though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23z2JEMdIHHA.1248@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I created a nonclustered index on sysobjects table. After that, when I
>> create a new object and sysobjects is modified, the database does not
>> work properly. I used DBCC CHECKDB to repair it. It works but as soon as
>> a new object is created, again database get corrupted (CHECKDB reports
>> error). I cannot drop this index with DROP INDEX command.
>> I'm wondered if an index on system table cannot be dropped, why it can be
>> created? If it is allowed to create index, why it corrupts the database?
>> Any help would be greatly appreciated.
>> Leila|||Leila (Leilas@.hotpop.com) writes:
> I created a nonclustered index on sysobjects table.
Uh-uh, never do that again, promise? :-)
> After that, when I create a new object and sysobjects is modified, the
> database does not work properly. I used DBCC CHECKDB to repair it. It
> works but as soon as a new object is created, again database get
> corrupted (CHECKDB reports error). I cannot drop this index with DROP
> INDEX command. I'm wondered if an index on system table cannot be
> dropped, why it can be created? If it is allowed to create index, why it
> corrupts the database?
It seems that you need to enable "Allow updates" to create an index on a
system table. With this setting all bets are off anyway.
I would recommend that you create a new database from scripts and bulk
data over.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Perfect Match Finder
http://www.max-online.biz/idevaffiliate/idevaffiliate.php?id=804
Online Web Promotion
http://www.max-online.biz/idevaffiliate/idevaffiliate.php?id=804
For further details email me at maxonline.sunil@.gmail.com