sp_checknames

Description

Checks the current database for names that contain characters not in the 7-bit ASCII set.

Syntax

sp_checknames

Parameters

None.

Examples

Example 1

sp_checknames

Looking for non 7-bit ASCII characters in the system tables 
of database: 
"master"

===============================================================
Table.Column name: "syslogins.password"
 
The following logins have passwords that contain non 7-bit
ASCII characters.  If you wish to change them use "sp_password";
Remember, only the sa and the login itself may examine or change
the syslogins.password column:
 
 suid   name
 ------ ------------------------------ 
      1 sa
      2 probe
      3 bogususer 

Usage

Permissions

Any user can execute sp_checknames.

See also

Commands update

System procedures sp_password, sp_rename, sp_renamedb