Error repair DB with dbcc checkdb

Hi,
I try to repair DB that is in state Emergency Mode, but=20
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la p=E1gina=20
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error,=20
consulte al
administrador del sistema.
How do i for repair the DB?
Than'k
From Google translation page:
A latch in the page (1:177) with the type of latch SH. Error in sysindexes
cannot be read and be established.
(Pretty good translation actually)
One of the pages in the leaf level of the sysindexes clustered index is
corrupt. This error cannot be repaired so you'll have to revert to your
disaster recovery strategy. I recommend you call Product Support to help you
out. (http://support.microsoft.com)
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan Alexander Laverde" <anonymous@.discussions.microsoft.com> wrote in
message news:104c001c43f4c$d6aaaaf0$a101280a@.phx.gbl...
Hi,
I try to repair DB that is in state Emergency Mode, but
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la pgina
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecucin de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'k

Error repair DB with dbcc checkdb

Hi,
I try to repair DB that is in state Emergency Mode, but execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la p=E1gina (1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error, consulte al
administrador del sistema.
How do i for repair the DB?
Than'kFrom Google translation page:
A latch in the page (1:177) with the type of latch SH. Error in sysindexes
cannot be read and be established.
(Pretty good translation actually)
One of the pages in the leaf level of the sysindexes clustered index is
corrupt. This error cannot be repaired so you'll have to revert to your
disaster recovery strategy. I recommend you call Product Support to help you
out. (http://support.microsoft.com)
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan Alexander Laverde" <anonymous@.discussions.microsoft.com> wrote in
message news:104c001c43f4c$d6aaaaf0$a101280a@.phx.gbl...
Hi,
I try to repair DB that is in state Emergency Mode, but
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la página
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecución de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'k

Error repair DB with dbcc checkdb

Hi,
I try to repair DB that is in state Emergency Mode, but=20
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la p=E1gina=20
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error,=20
consulte al
administrador del sistema.
How do i for repair the DB?
Than'kFrom Google translation page:
A latch in the page (1:177) with the type of latch SH. Error in sysindexes
cannot be read and be established.
(Pretty good translation actually)
One of the pages in the leaf level of the sysindexes clustered index is
corrupt. This error cannot be repaired so you'll have to revert to your
disaster recovery strategy. I recommend you call Product Support to help you
out. (http://support.microsoft.com)
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan Alexander Laverde" <anonymous@.discussions.microsoft.com> wrote in
message news:104c001c43f4c$d6aaaaf0$a101280a@.phx
.gbl...
Hi,
I try to repair DB that is in state Emergency Mode, but
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la pgina
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecucin de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'ksql

Error Message: Transaction cannot start while in firehose mode

Hi,
I am dealing with an application where the back-end is SqlServer2000. There
is a master table where one filed is empty that needs to be filled in with
correct value. As I am trying to add the value to this field on a particular
row, I am getting the following message: Transaction cannot start while in
firehose mode. Now I am planning to send a update command to the particular
row to fill in the blank value for the field concerned. However, before I do
that I just want to know, why I am getting the above error. Any help is
appreciated. Thanks.> As I am trying to add the value to this field on a particular row
How are you "trying to add the value"? An update statement, a stored
procedure call, pasting into Enterprise Manager's "Open Table" view, ...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||I was trying to add the blank field value from Enterprise Manager, by right
clicking and opening the table and choosing all row option and then going to
the right record and the blank field to fill it up. At this point, I got the
above message. I would like to know why I am getting such message and is it
safe to run a update query to update the blank field in one record via Query
Analyzer. Thanks
"Aaron [SQL Server MVP]" wrote:
> > As I am trying to add the value to this field on a particular row
> How are you "trying to add the value"? An update statement, a stored
> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||If your table has a primary key (or a unique way to identify a single row),
then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
Manager has its purposes, but data manipulation is not one of them. Please
have a look through this article: http://www.aspfaq.com/2455
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> I was trying to add the blank field value from Enterprise Manager, by
right
> clicking and opening the table and choosing all row option and then going
to
> the right record and the blank field to fill it up. At this point, I got
the
> above message. I would like to know why I am getting such message and is
it
> safe to run a update query to update the blank field in one record via
Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
> > > As I am trying to add the value to this field on a particular row
> >
> > How are you "trying to add the value"? An update statement, a stored
> > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >|||Thanks for the help Aaron. I appreciate it.
"Aaron [SQL Server MVP]" wrote:
> If your table has a primary key (or a unique way to identify a single row),
> then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
> Manager has its purposes, but data manipulation is not one of them. Please
> have a look through this article: http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> > I was trying to add the blank field value from Enterprise Manager, by
> right
> > clicking and opening the table and choosing all row option and then going
> to
> > the right record and the blank field to fill it up. At this point, I got
> the
> > above message. I would like to know why I am getting such message and is
> it
> > safe to run a update query to update the blank field in one record via
> Query
> > Analyzer. Thanks
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > > As I am trying to add the value to this field on a particular row
> > >
> > > How are you "trying to add the value"? An update statement, a stored
> > > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
>
>|||Chances are the table does not have a valid PK and is causing the error.
--
Andrew J. Kelly SQL MVP
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
>I was trying to add the blank field value from Enterprise Manager, by right
> clicking and opening the table and choosing all row option and then going
> to
> the right record and the blank field to fill it up. At this point, I got
> the
> above message. I would like to know why I am getting such message and is
> it
> safe to run a update query to update the blank field in one record via
> Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
>> > As I am trying to add the value to this field on a particular row
>> How are you "trying to add the value"? An update statement, a stored
>> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>

Error message of #Error

I'm using WinForms ReportViewer in local mode.
Some textboxes in my report display #Error
How to get exact error message for this error or any other information about
error in expression ?
Andrus.On Mar 28, 11:45 am, "Andrus" <kobrule...@.hot.ee> wrote:
> I'm using WinForms ReportViewer in local mode.
> Some textboxes in my report display #Error
> How to get exact error message for this error or any other information about
> error in expression ?
> Andrus.
This error is relatively common, but usually refers to an error in an
expression. If you have the BIDS (Business Intelligence) environment,
I would suggest opening the report up separately there and when you
preview the report, you might get a better description in the Output
window. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Error message about SQL Server is displayed

I have a website that works OK on my local machine when I test it within Microsoft Visual Studio's debugging mode. However now that I have copied it over to a remote server it is failing with an error message of:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

As far as I'm aware I have never used SQL Server with my webpage. All connections to databases are to Oracle with connection strings and providers set up in the webconfig file. The website does however use a login control to recognise authorised users. Does this mean I've unknowingly been using SQL Server (to support the login control) and I therefore need to install this on the remote machine? Or is it something simpler? Wondered if anybody had seen this error message before?

Hi,

The website does however use a login control to recognize authorized users.

As you mentioned in your post, you are using login controls to recognize authorized users. In ASP.NET, such controls like logins, createuserwizard and etc are parts of .Net Membership provider mechanism.

In your local side, I think the SQLExpress has been shipped in your Visual Studio, so it can support the membership to work. But after you deployed your application to your server, the membership still tries to find the database to support. Unfortunately, the database does exist on your server, so the error occurs.

Thanks.

|||

Hi Nai-Dong, thanks for replying. I agree with your suggestion that the membership is tying and failing to read the database. The database MDF file is present and in the correct location. The permissions are set on this file as according to other forum posts I've read. I also installed SQLServer Express on the remote machine. I suspect that the membership is not picking up the SQLServerExpress install but I am not sure how to fix this. It's such a shame because the ASP.NET login controls and .Net membership provider are really neat and simple to use. Due to time restraints it's looking like I'm going to have to use my Oracle database to contain the login information and write code myself to enable authentication.

|||

Hi,

Well, i just want to provide you some materials on membership which maybe helpful to you when you are going to use Membership in your next project.

About Membership Providershttp://msdn2.microsoft.com/en-us/library/aa478949.aspx

Membership introductionhttp://msdn2.microsoft.com/en-us/library/yh26yfzy.aspx

Settings on using Membershiphttp://msdn2.microsoft.com/en-us/library/ms731049.aspx

Besides, you can export all the datatables with schemas in ASPNETDB into your Oracle database, and change the membership provider, you also can use membership with a Oracle back-end database.

Hope that helps. Thanks.

|||

Thanks Michael - greatly appreciated. I will certainly read through them. I like the idea of Oracle providing membership since I can connect to me Oracle db without any problems.