sql server reporting services: TempDB full -- sql server reporting services

Re: TempDB full

Wayne Snyder
8/9/2004 8:33:04 AM

sql server reporting services:

RUN SQL Enterprise Manager, and open your server, -> databases -> tempdb ->
properties-> log

Make sure there is disk space available wherever the log file is, and that
you have maxsize appropriately set, and autogrow maybe set to 10%.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Re: TempDB full

Scott Allen
8/9/2004 8:45:36 AM

Hi Atul:

Right-click on tempdb in enterprise manager, select properties, and
inspect the data files / transaction logs tabs to see if you have hit
any restrictions in file growth.

HTH,

--
Scott
http://www.OdeToCode.com

On Mon, 9 Aug 2004 15:56:36 +0530, "Atul" <atul.anjankar@approva.net>
[quoted text, click to view]

TempDB full

Atul
8/9/2004 3:56:36 PM

Hello,
I have written a stored proceudre where i declare @temptable table, and
store the intermediate values therein. Also there are lots of calculations
involved inside a stored proc. When i try to execute the stored proc i get
an error message saying,"tempdb log file full". I have enough disk space but
tempDB log files does not seem to be using that. How do i cope up with the
situation??

Thanks,
Atul

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.