GuinevereConn502

出典: くみこみックス

sql deadlock System Saved Processes

System Stored Procedures System kept processes tend to be grouped together with SQL Machine. Several processes are employed to give SQL Machine, however some are utilities that can be profitablly used by developers. They may be worldwide, and may end up being called through the data source program with out their particular fully qualified identify. (All of them are belonging to dbo.) . They all are saved in the actual database, and have the prefix sp_. It is a reason it is regarded as unwise to mention neighborhood stored processes using the sp_ prefix. They can be study by watching their particular qualities within the Issue Analyzer.

The actual system-stored processes are grouped in to these classes.

Group Outline

Active Index Processes Utilized to register instances of SQL Host and SQL Machine databases within Ms Windows? The year 2000 Active Directory?.

Directory Procedures Accessories ODBC info dictionary functions and isolates ODBC programs through adjustments in order to root system tables.

Cursor Methods Implements cursor varied features.

Data source Upkeep Plan Methods Utilized to setup primary upkeep jobs essential to ensure database overall performance.

Sent out Questions Methods Accustomed to apply and manage Dispersed Questions.

Full-Text Research Processes Accustomed to apply and issue full-text spiders.

Log Delivery Methods Used to arrange and handle log delivery.

OLE Automation Procedures Allows normal OLE automation things to be used within a regular Transact-SQL set.

Replication Processes Accustomed to control replication.

Safety Procedures Accustomed to control security.

SQL Email Procedures Used to perform e-mail procedures from the inside SQL Machine.

SQL Profiler Processes Employed by SQL Profiler to observe overall performance and activity.

SQL Server Broker Processes Employed by SQL Host Broker to control slated and event-driven actions.

Program Procedures Used for common repair off SQL Host.

Internet Helper Methods Utilized by the internet Helper.

XML Procedures Useful for Extensible Markup Language (XML) textual content administration.