cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1134
Views
0
Helpful
1
Replies

Error when increasing tempdb size UCCE 7.5

jasonkelley
Level 1
Level 1

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 Reply 1

jasonkelley
Level 1
Level 1

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