System and catalog stored procedures
974
This procedure is equivalent to calling the VALIDATE TABLE statement
for each table in the database.
$ For information, see "VALIDATE TABLE statement" on page 644.
tbl-name Validate only the specified table. When NULL (the default),
validate all tables.
owner_name Validate only the tables owned by the specified user. When
NULL (the default), validate tables for all users.
check_type When NULL (the default), each table is checked using a
VALIDATE TABLE statement with no additional checks. The check_type
value can be one of the following:
♦
data Validate tables using WITH DATA CHECK.
♦
index Validate tables using WITH INDEX CHECK.
♦
full Validate tables using WITH FULL CHECK.
All of the values for the
tbl_name
,
owner_name
, and
check_type
arguments
are strings and they must be enclosed in quotes.
The procedure returns a single column, named
msg
. If all tables are valid, the
column contains
No errors detected.
sp_login_environment system procedure
Sets connection options when users log in.
sp_login_environment
None
None
"LOGIN_PROCEDURE option" on page 196.
Sp_login_environment is the default procedure called by the
LOGIN_PROCEDURE database option.
It is recommended that you not edit this procedure. Instead, to change the
login environment, set the LOGIN_PROCEDURE option to point to a
different procedure.
Here is the text of the sp_login_environment procedure:
CREATE PROCEDURE dbo.sp_login_environment()
BEGIN
IF connection_property(’CommProtocol’)=’TDS’ THEN
Description
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...