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)
Loading.
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)?

Actions

This Discussion

Related Content