O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Grouped by Function

The system stored procedures listed in Table 25-1 are used to run and set up SQL Server/MSDE.

Table 25-1. General Procedures
sp_addmessage sp_detach_db sp_helpserver
sp_addtype sp_dropdevice sp_helpsort
sp_addumpdevice sp_dropmessage sp_helptext
sp_attach_db sp_droptype sp_helptrigger
sp_bindefault sp_executesql sp_monitor
sp_bindrule sp_help sp_recompile
sp_configure sp_helpconstraint sp_rename
sp_datatype_info sp_helpdb sp_renamedb
sp_dbcmptlevel sp_helpdevice sp_unbindefault
sp_dboption sp_helpfile sp_unbindrule
sp_dbremove sp_helpfilegroup sp_validname
sp_depends sp_helpindex sp_who

With catalog procedures, listed in Table 25-2, you can get data about databases, tables, and other elements ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required