Showing posts with label proper. Show all posts
Showing posts with label proper. Show all posts

Tuesday, March 20, 2012

Replace 120 version with proper version

I have now received my CD with the correct version of reporting services on
it.
I have been running the 120 Day trial version.
What is the best way to update/replace the 120 version with the proper
version?You should be able to simply run setup and upgrade to the licensed version.
Back up your database and encryption key beforehand, just to be safe.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
news:eIlZmWsWEHA.2844@.TK2MSFTNGP12.phx.gbl...
>I have now received my CD with the correct version of reporting services on
> it.
> I have been running the 120 Day trial version.
> What is the best way to update/replace the 120 version with the proper
> version?
>

Wednesday, March 7, 2012

Repairing indexes in a table but getting errors

Hi ALL,

Somehow one of tables in my database with clustered index got tempered and the pageid are not in proper order. I tried the checkdb command with repair_rebuild option but it is giving the following error.

Table error: Object ID 1984530649, index ID 1. Page (1:254682) is missing a reference from previous page (1:254681). Possible chain linkage problem.

Server: Msg 8936, Level 16, State 1, Line 1

Table error: Object ID 1984530649, index ID 1. B-tree chain linkage mismatch. (1:254680)->next = (1:256198), but (1:256198)->Prev = (1:256197).

Not able to reindex the index of table. I can not even export the data to any other table with same structure.

Please help me.........

Thanks,
PracheerPls take a look at
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6046

:)|||Thanks for the help. I will try all the scenarios. Hope that will solve my problem.

:)