Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Checks for valid Microsoft® SQL Server™ identifier names. All nonbinary and nonzero data, including Unicode data that can be stored by using the nchar, nvarchar, or ntext data types, are accepted as valid characters for identifier names.


sp_validname [@name =] 'name'
    [, [@raise_error =] raise_error]


[@name =] 'name'

Is the name of the identifier for which to check validity. name is sysname, with no default. name cannot be NULL, cannot be an empty string, and cannot contain a binary-zero character.

[@raise_error =] raise_error

Specifies whether to raise an error. raise_error is bit, with a default of 1, which means that errors should appear. 0 causes no error messages to appear.

Return Code Values

0 (success) or 1 (failure)


Execute permissions default to the public role.

See Also

Data Types


nchar and nvarchar

ntext, text, and image

System Stored Procedures

Using Identifiers

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft