|
|
|
|
|
SQL Server 7.0 Extended Stored Procedure Reference 1 2 3 4 5 6 7 8 9 10 11 12 xp_fileexistTests for the existence of a file xp_fixeddrives Lists all of the fixed drives and the space available on them xp_get_tape_devices Lists all attached tape devices xp_getfiledetails Retrieves the details of a specified file such as name, size, dates, attributes, etc. This comes in extremely handy when running jobs that bulk load periodically downloaded files. xp_getnetname Returns the network name of a connection xp_grantlogin Grants access to SQL Server to an NT group or user. You can either add a user or group to the sysadmin role or as a regular user. xp_initcolvs xp_intersectbitmaps xp_loginconfig Lists the login configuration of the SQL Server xp_logevent Logs a message in both the SQL Server error log and the NT event log
SQL Server 7.0 Extended Stored Procedure Reference 1 2 3 4 5 6 7 8 9 10 11 12 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.