ソースを表示

[http://www.sqlsolutions.com 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.