an unexpected error occured during this operation

Hi

when i right click table and click design table then error occured
(an unexpected error occured during this operation)
If any one knows please let let me know your help would be appreciated .

thanks
pardhi

--
Message posted via http://www.sqlmonster.comRight click using what tool? I am guessing EM, if so, then try closing
EM and getting back in. I have run into a couple of problems that went
away when I re-started EM.

Knowing what you had done just prior to this might also be helpful as
would the database version: 7, 2000.

HTH -- Mark D Powell --

An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?

An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?

An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?

An error occurred while performing this operation.

Hullo Team,

I kindly request for your help so that I could be able to start reporting services.

The main services are running but reporting services is not running.

It actually gives me the following error

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerServiceUnavailable&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) (Microsoft.ReportingServices.Diagnostics)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerServiceUnavailable&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

BUTTONS:

OK

Any help will be highly appreciated.

Ronald

Hullo,

I have solved this problem. I had to change the local service account and reporting services restarted..

But when i try to access Reporting Services from MS SQL SEVER Management Studio, it prompt the following error message.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsRPCError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) (Microsoft.ReportingServices.Diagnostics)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsRPCError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()

Bad Data. (Exception from HRESULT: 0x80090005) ()

BUTTONS:

OK

Could someone help me out.

|||

Use the configuration tool to change windows service accounts. It will prompt you to backup and restore report server key.

Since you have already manually changed account, try one of the following:

1. Change back to the original account, then use the config tool.

2. Change the key from config tool.