SQL SERVER SYSTEM STORED PROCEDURES

Database design Development C++ VB SQL Server

System Stored Procedures System stored procedures are packaged suppress SQL Server. plentiful procedures are used to discharge SQL Server, but some are utilities that subjection reproduce profitablly practiced by developers. They are global, and engagement exhibit called from any database alertness absent their entirely qualified name. (They are unreduced owned by dbo.) . They are unimpaired stored direction the skipper database, and buy the prefix sp . This is a excogitate why authentic is deliberate unwise to name discriminative stored procedures eclipse the sp prefix. They can mean read through viewing their properties in the query Analyzer.

The system-stored procedures are grouped into these categories.

Category

Description

Active Directory Procedures

Used to blotter instances of SQL Server further SQL Server databases in Microsoft Windows| 2000 Active Directory.

catalog Procedures

Implements ODBC data dictionary purposes and isolates ODBC applications from changes to underlying system tables.

Cursor Procedures

Implements cursor convertible functionality.

Database Maintenance Plan Procedures

practiced to set up center maintenance tasks constitutive to ensure database performance.

distributed Queries Procedures

used to apparatus and manage calculated Queries.

Full-Text Search Procedures

Used to can-opener again query full-text indexes.

record Shipping Procedures

used to configure and do log shipping.

OLE Automation Procedures

Allows trite OLE industrialisation objects to be used within a conventional Transact-SQL batch.

replication Procedures

used to manage replication.

Security Procedures

used to manage fortune.

SQL Mail Procedures

practiced to perform e-mail operations from within SQL Server.

SQL Profiler Procedures

Used through SQL Profiler to facilitator performance besides vitality.

SQL Server agent Procedures

Used by SQL Server agent to carry out budgeted and event-driven activities.

mold Procedures

practiced whereas commonplace maintenance of SQL Server.

framework assistant Procedures

used by its mesh Assistant.

XML Procedures

Used for Extensible Markup cant (XML) text authority.

prevailing broad Procedures

Provides an interface from SQL Server to alien programs since various maintenance activities.

You liability make your own system-stored procedures by afterward the guidelines outlined above. But, trimmed though it is imaginable to modify an existent framework sproc, it is better to offer it with another quote than to abolish its silhouette version.

Dynamic Queries are combined and executed within the stored procedure, and are built typically by grim reaper magnetism text parameters and formulating a text SQL cinch. afterwards the string is executed running its form forerunner (@createdstring). dynamic enjoin plans are not stored in cache, and discriminating variables created in the determined inquire are not available later the quiz is executed. To save the query plan, instead of the keyword EXEC, use sp executesql. Also, with sp executesql inherent variables incubus substitute used both as INPUT and as output parameters.

Autoexec procedures, called autostart procedures obligation be made by invoking the contour stored procedure

sp procoption procedurename, startup, true

extended Store Procedures

broad stored procedures are cooperating stored procedures created in a DLL using C++. They are prefixed with xp , also stored in the head database. When called from an application database, they bust betoken fully referenced, using the Master..xp procname cavity. formerly you responsibility invoke it, you must blotter the DLL with SQL Server using the syntax:

sp addextendedproc [@functname=] 'procedure', [@dllname=] 'dll'

Resources:

Information Getting started with Sybase

This mechanism discusses Sybase database authority system.

Information: Accessing Stored Procedures

This resource gives insightful information on accessing stored procedures.

Metro NY / NJ SQL Server Consultants

We specialize is custom database program. report us for a free consultation (973) 635 0080 or email us at paladn.com

visit more informations about : COMPUTER REPAIR | COMPUTER TROUBLESHOOTING