Error when increasing tempdb size UCCE 7.5

Unanswered Question
Feb 2nd, 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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Average Rating: 0 (0 ratings)
jasonkelley Thu, 02/02/2012 - 13:10

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

Login or Register to take actions

This Discussion

Posted February 2, 2012 at 12:58 PM
Stats:
Replies:1 Avg. Rating:
Views:544 Votes:0
Shares:0

Related Content

Discussions Leaderboard