Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RobMarsh
Starting Member
28 Posts |
 Posted - 2002-03-19 : 13:16:47
|
| When going through the upgrade wizard from 6.5 to 7.0 between two machines, the following error is displayed in the inconsistency report for the 6.5 Server:=============================================The following syscomments entries are invalid on your 6.x SQL Server. It is recommended that you fix these problems before you continue.=============================================********************************master********************************Inconsistency Report For Database: master.dbo.sp_marksuspectProcedure[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.dbo.sp_resetstatusProcedure[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.---------------------------Of course, I have no idea of how to allow these ad-hoc updates.Any ideas?Rob |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-19 : 13:23:29
|
| i don't know if you really want to do this, but you can run sp_configure and modify the 'allow updates' property ...setBasedIsTheTruepath<O> |
 |
|
|
RobMarsh
Starting Member
28 Posts |
Posted - 2002-03-19 : 14:01:28
|
| Marvellous, worked like a charm..Thanks very much!Rob |
|
|
|
|
|
|
Problems upgrading from 6.5 to 70...