Microsoft KB Archive/70266

{|
 * width="100%"|

INF: SQL Server Truncates Program Name and Host Name

 * }

Q70266

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.2

-

You cannot specify a host name longer than 10 characters or an application name longer than 16 characters using dbsetlhost and dbsetlapp. While these DB-Library macros do allow host names and program names to be 30 characters long, the sysprocesses table defines these columns as:

  hostname  char 10    /* dblib will accept 30 */ program_name char 16   /* dblib will accept 30 */

SQL Server truncates the strings to fit into these columns without any warning or error messages. Pages 130 and 131 of the &quot;Microsoft SQL Server Programmer's Reference for C&quot; indicate that this is legal. Microsoft is aware of this problem and will be updating the &quot;Microsoft SQL Server Programmer's Reference for C&quot; to reflect this additional information.

NOTE: The column definitions can be seen by performing an sp_help on the sysprocesses table in the master database.

NOTE: This is fixed in the latest PTK documentation.

Additional query words: DB-Library DB-Lib dblib Windows NT

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420