http://lame.dei.uc.pt/api.php?action=feedcontributions&feedformat=atom&user=FitzwaterLampe698Lame - User contributions [en]2026-09-24T18:46:29ZUser contributionsMediaWiki 1.18.0http://lame.dei.uc.pt/index.php/FitzwaterLampe698FitzwaterLampe6982012-05-11T21:21:24Z<p>FitzwaterLampe698: Created page with "[http://www.sqlsolutions.com sql server performance] Program Saved Procedures Program Stored Procedures System kept methods are packaged with SQL Host. Many processes are em..."</p>
<hr />
<div>[http://www.sqlsolutions.com sql server performance] Program Saved Procedures<br />
<br />
<br />
Program Stored Procedures System kept methods are packaged with SQL Host. Many processes are employed to give SQL Machine, however, many tend to be utilities that can be profitablly used by designers. They're worldwide, and will end up being referred to as from the database program without having their particular fully qualified name. (They all are owned by dbo.) . They are all kept in the Master database, and have the prefix sp_. This can be a reason it's regarded as foolish to call nearby stored processes with the sp_ prefix. They may be examine through watching their own attributes inside the Issue Analyzer.<br />
<br />
The particular system-stored processes are grouped in to these categories.<br />
<br />
Class<br />
Outline<br />
<br />
Active Index Methods<br />
Accustomed to sign up installments of SQL Machine and also SQL Machine directories in Microsoft Windows? The year 2000 Active Directory?.<br />
<br />
Directory Methods<br />
Implements ODBC data thesaurus capabilities and also isolates ODBC apps coming from adjustments in order to underlying system furniture.<br />
<br />
Cursor Methods<br />
Implements cursor adjustable functionality.<br />
<br />
Database Servicing Strategy Processes<br />
Used to create central upkeep duties necessary to make sure databases overall performance.<br />
<br />
Sent out Queries Procedures<br />
Used to put into action and also control Dispersed Questions.<br />
<br />
Full-Text Lookup Methods<br />
Used to put into action and problem full-text indices.<br />
<br />
Record Delivery Processes<br />
Utilized to arrange and also control sign shipping and delivery.<br />
<br />
OLE Automation Methods<br />
Enables regular OLE hands free operation things to be used in just a standard Transact-SQL order.<br />
<br />
Replication Processes<br />
Used to control replication.<br />
<br />
Safety Processes<br />
Used to control safety.<br />
<br />
SQL Email Methods<br />
Accustomed to perform e-mail functions from the inside SQL Host.<br />
<br />
SQL Profiler Processes<br />
Employed by SQL Profiler to observe efficiency and activity.<br />
<br />
SQL Host Agent Procedures<br />
Used by SQL Server Agent to manage planned and event-driven activities.<br />
<br />
Program Methods<br />
Useful for common repair off SQL Host.<br />
<br />
Web Assistant Methods<br />
Employed by the Web Assistant.<br />
<br />
XML Methods<br />
Useful for Extensible Markup Language (XML) textual content management.</div>FitzwaterLampe698