Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 911851 - Last Review: November 2, 2007 - Revision: 1.2
Error message when you run the sp_helpfile stored procedure in SQL Server 2005 or in SQL Server 2000: "Arithmetic overflow error converting expression to data type int"
Bug #: 412400 (SQLBUDT)
SYMPTOMS
Consider the following scenario. You are running Microsoft SQL Server 2005 or Microsoft SQL Server 2000. You run the
sp_helpfile stored
procedure on a data file or on a log file. In this scenario, you may receive the
following error message:
Msg 8115, Level 16,
State 2, Procedure sp_helpfile, Line 31
Arithmetic overflow error
converting expression to data type int
CAUSE
This problem occurs when the
max_size value
of the file multiplied by 8 is greater than the maximum
int size (2,147,483,647).
Note max_size is a field of the system
sys.database_files view. The
max_size field indicates the
maximum file size in 8-KB pages.
WORKAROUND
To work around this problem, run the following query:
SELECT name, physical_name, FILEGROUP_NAME(data_space_id) AS filegroup,
CONVERT(nvarchar(15), size * 8) + N' KB' AS 'size',
CASE max_size
WHEN -1
THEN N'Unlimited'
ELSE
CONVERT(nvarchar(15), CONVERT(bigint, max_size) * 8) + N' KB'
END AS 'maxsize',
CASE is_percent_growth
WHEN 1
THEN CONVERT(nvarchar(3), growth) + N'%'
WHEN 0
THEN CONVERT(nvarchar(15), growth * 8) + N' KB'
END AS 'growth',
CASE type
WHEN 0 THEN 'data only'
WHEN 1 THEN 'log only'
END AS 'usage'
FROM SYS.DATABASE_FILES
WHERE file_id = FILE_ID('FileName') represents the database file name.
STATUS
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
APPLIES TO
- Microsoft SQL Server 2000 Personal Edition
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 2000 Developer Edition
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
| kbexpertiseadvanced kbtshoot KB911851 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please