SQL server issue.

novice78 · #1 February 14th, 2007, 04:23 PM

Hi All,

Anyone has any idea what i should do when I get the following:

"SQL server stating that it cannot create new pages in the temp database."

Thanks

jdc2000 · #2 February 14th, 2007, 05:35 PM

It could be a permissions issue, or a database problem. More details on when this occurs and exactly what you are trying to do when it happens might be helpful.

novice78 · #3 February 14th, 2007, 07:27 PM

I was trying to do a squeeze on the tempdb the 12th. We had a snow day yesterday the 13th and now the system is complaining that it can't create anymore pages in the tempdb.

jdc2000 · #4 February 15th, 2007, 07:50 PM

It could a an SQL Server limit of some sort, or you may be low on disk space on the system drive or a storage drive.