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)

.

No comments: