Error when increasing tempdb size UCCE 7.5

Unanswered Question
Feb 2nd, 2012
User Badges:

I am receiving the following error when attempting to increase the size of the Tempdb on our Historical Data Server.

Expanding database tempdb

Creating database device tempdbD112121455 for TempDb

SQL Msg: (102 0r 0x66) Incorrect syntax near 'NAME'.

Error querying database.

Any help would be greatly appreciated.

Jason K

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
jasonkelley Thu, 02/02/2012 - 13:10
User Badges:

This appears to be an issue with case sensitivity.

Creating database device tempdbD112121455 for TempDb.

I was able to increase the size through the SQL Managment Tool and my Webview reports started working again. Is there a way to correct this without having to reinstall SQL (2005)?


This Discussion

Related Content