I am running SQL Server 2008 Upgrade Advisor tool on a SQL Server 2000 DB, and the final report shows an error:

Database Server,"PreUpgrade",
"After upgrade, new reserved keywords cannot be used as identifiers",
"Upgrade Advisor detected an idetifier with name Merge",
"Source Type: Database","Database: Domus","Object Name: crosstab","Object Type: P ",
"Key Word: pivot"

The message is a bit ambiguos for me.... Using the following script, I have searched the keyword 'pivot' and 'Merge' in all tables, however there are no results.

Should I ignore this error?

  • 2
    The error message already calls out that you have the keyword pivot in stored procedure crosstab. Just view the source for that procedure and search for pivot. The script you referenced searches for data in tables, not object definitions. – Dan Guzman Jun 6 '19 at 11:47
  • I will choose this as best answer if you reply. And of course, thanks! – Riccardo Jun 6 '19 at 12:00
  • 1
    The script you pointed at is looking for strings in columns, which is just user data and wouldn't cause a problem for any upgrade advisor. You need to look at the definition of that procedure, e.g. USE Domus; SELECT OBJECT_DEFINITION(OBJECT_ID(N'dbo.crosstab')); – Aaron Bertrand Jun 6 '19 at 13:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.