Showing posts with label tempdb. Show all posts
Showing posts with label tempdb. Show all posts

sp_helpdb @dbname=N''tempdb'' tempdb Arithmetic overflow error converting expression to data type int

If you get the following error from tempdb database:

sp_helpdb @dbname=N''tempdb'' tempdb Arithmetic overflow error converting expression to data type int

The solution is to set max size (using ALTER DATABASE command because tempdb properties is inaccessible)

.