Error when increasing tempdb size UCCE 7.5

jasonkelley · ‎02-02-2012

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

jasonkelley · ‎02-02-2012

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