Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.parameters

  No additional text.


Syntax
CREATE VIEW sys.parameters AS
	SELECT object_id, name,
		parameter_id, system_type_id,
		user_type_id, max_length,
		precision, scale,
		is_output, is_cursor_ref,
		has_default_value, is_xml_document,
		default_value, xml_collection_id,
		is_readonly
	FROM sys.parameters$
	WHERE number = 1

 
Last revision 2008RTM
See also

  all_parameters (View)
numbered_procedure_parameters (View)
parameters$ (View)
partition_parameters (View)
plan_guides (View)
ROUTINES (View)
spt_all_procedures (View)
spt_parameters_numbered_parameters (View)
spt_parameters_system (View)
spt_parameters_user (View)
spt_procedures_system (View)
spt_procedures_user (View)
spt_procedure_params_managed_view (View)
spt_procedure_params_view (View)
spt_sproc_columns_odbc_view (View)
sp_ActiveDirectory_Obj (Procedure)
sp_ActiveDirectory_SCP (Procedure)
sp_adddistributiondb (Procedure)
sp_addextendedproc (Procedure)
sp_addlinkedserver (Procedure)
sp_addlinkedsrvlogin (Procedure)
sp_addmergearticle (Procedure)
sp_addmergelogsettings (Procedure)
sp_addmergesubscription (Procedure)
sp_addmessage (Procedure)
sp_addpullsubscription_agent (Procedure)
sp_addserver (Procedure)
sp_addtask (Procedure)
sp_add_agent_parameter (Procedure)
sp_add_agent_profile (Procedure)
sp_add_alert_internal (Procedure)
sp_add_category (Procedure)
sp_add_job (Procedure)
sp_add_jobserver (Procedure)
sp_add_jobstep (Procedure)
sp_add_jobstep_internal (Procedure)
sp_add_notification (Procedure)
sp_add_operator (Procedure)
sp_add_proxy (Procedure)
sp_add_schedule (Procedure)
sp_add_targetservergroup (Procedure)
sp_add_targetsvrgrp_member (Procedure)
sp_altermessage (Procedure)
sp_apply_job_to_targets (Procedure)
sp_attachsubscription (Procedure)
sp_bindefault (Procedure)
sp_bindrule (Procedure)
sp_browsereplcmds (Procedure)
sp_cdc_create_change_enumeration_functions (Procedure)
sp_cdc_create_objects (Procedure)
sp_cdc_generate_wrapper_function (Procedure)
sp_cdc_get_job_parameters (Procedure)
sp_cdc_lsn_time_mapping_procs (Procedure)
sp_cdc_start_job (Procedure)
sp_cdc_start_job_internal (Procedure)
sp_cdc_vupgrade (Procedure)
sp_changedynamicsnapshot_job (Procedure)
sp_changemergearticle (Procedure)
sp_changemergelogsettings (Procedure)
sp_changemergepublication (Procedure)
sp_changesubscriptiondtsinfo (Procedure)
sp_change_agent_parameter (Procedure)
sp_change_subscription_properties (Procedure)
sp_check_for_owned_jobsteps (Procedure)
sp_configure (Procedure)
sp_copysubscription (Procedure)
sp_createagentparameterlist (Procedure)
sp_dbmmonitorchangealert (Procedure)
sp_dbmmonitorhelpmonitoring (Procedure)
sp_deletetracertokenhistory (Procedure)
sp_delete_alert (Procedure)
sp_delete_category (Procedure)
sp_delete_job (Procedure)
sp_delete_jobschedule (Procedure)
sp_delete_jobserver (Procedure)
sp_delete_notification (Procedure)
sp_delete_operator (Procedure)
sp_delete_proxy (Procedure)
sp_delete_targetserver (Procedure)
sp_delete_targetservergroup (Procedure)
sp_delete_targetsvrgrp_member (Procedure)
sp_downloaded_row_limiter (Procedure)
sp_dropdatatypemapping (Procedure)
sp_dropdistributor (Procedure)
sp_droplinkedsrvlogin (Procedure)
sp_dropmergepublication (Procedure)
sp_dropmessage (Procedure)
sp_droppullsubscription (Procedure)
sp_dropreplsymmetrickey (Procedure)
sp_dropserver (Procedure)
sp_dropwebtask (Procedure)
sp_drop_agent_parameter (Procedure)
sp_drop_agent_profile (Procedure)
sp_dsninfo (Procedure)
sp_enlist_tsx (Procedure)
sp_enumcustomresolvers (Procedure)
sp_enumfullsubscribers (Procedure)
sp_enum_login_for_proxy (Procedure)
sp_enum_proxy_for_subsystem (Procedure)
sp_foreign_keys_rowset (Procedure)
sp_foreign_keys_rowset3 (Procedure)
sp_fulltext_database (Procedure)
sp_getagentparameterlist (Procedure)
sp_getdefaultdatatypemapping (Procedure)
sp_get_chunked_jobstep_params (Procedure)
sp_get_composite_job_info (Procedure)
sp_grant_login_to_proxy (Procedure)
sp_grant_proxy_to_subsystem (Procedure)
sp_help (Procedure)
sp_helpdatatypemap (Procedure)
sp_helpdistributor (Procedure)
sp_helptracertokenhistory (Procedure)
sp_helptracertokens (Procedure)
sp_help_agent_parameter (Procedure)
sp_help_alert (Procedure)
sp_help_category (Procedure)
sp_help_downloadlist (Procedure)
sp_help_job (Procedure)
sp_help_jobactivity (Procedure)
sp_help_jobhistory (Procedure)
sp_help_jobschedule (Procedure)
sp_help_notification (Procedure)
sp_help_operator (Procedure)
sp_help_proxy (Procedure)
sp_help_targetserver (Procedure)
sp_help_targetservergroup (Procedure)
sp_IHscriptupdateparams (Procedure)
sp_IHXactSetJob (Procedure)
sp_instdist (Procedure)
sp_lock (Procedure)
sp_lookupcustomresolver (Procedure)
sp_manage_jobs_by_login (Procedure)
sp_MSactivateprocedureexecutionarticleobject (Procedure)
sp_MSaddautonosyncsubscription (Procedure)
sp_MSadddynamicsnapshotjobatdistributor (Procedure)
sp_MSaddexecarticle (Procedure)
sp_MSaddmergedynamicsnapshotjob (Procedure)
sp_MSaddoffloadparameter (Procedure)
sp_MSaddreplsymmetrickey (Procedure)
sp_MSadd_anonymous_agent (Procedure)
sp_MSadd_subscription (Procedure)
sp_MSadd_tracer_history (Procedure)
sp_MSadd_tracer_token (Procedure)
sp_MSagent_retry_stethoscope (Procedure)
sp_MSallocate_new_identity_range (Procedure)
sp_MScache_agent_parameter (Procedure)
sp_MScdc_capture_job (Procedure)
sp_MSchange_distribution_agent_properties (Procedure)
sp_MSchange_merge_agent_properties (Procedure)
sp_MSchange_repl_job (Procedure)
sp_MScheckprocexec (Procedure)
sp_MScheck_autoident_parameters (Procedure)
sp_MScheck_functions_directly_in_view (Procedure)
sp_MScleanupdynamicsnapshotfolder (Procedure)
sp_MSclear_dynamic_snapshot_location (Procedure)
sp_MScopyregvalue (Procedure)
sp_MScopyscriptfile (Procedure)
sp_MScopyscriptfile_merge (Procedure)
sp_MScopysnapshot (Procedure)
sp_MScopy_subscription_regkeys (Procedure)
sp_MScreatelightweightinsertproc (Procedure)
sp_MScreatemergedynamicsnapshot (Procedure)
sp_MScreate_distributor_tables (Procedure)
sp_MSdelete_tracer_history (Procedure)
sp_MSdetectinvalidpeersubscription (Procedure)
sp_MSdropmergedynamicsnapshotjob (Procedure)
sp_MSdropreplsymmetrickey (Procedure)
sp_MSdrop_cdc (Procedure)
sp_MSdrop_mergesystables (Procedure)
sp_MSdrop_repl_job (Procedure)
sp_MSdrop_rladmin (Procedure)
sp_MSenableautonosync (Procedure)
sp_MSenumpartialdeletes (Procedure)
sp_MSenum_replication_agents (Procedure)
sp_MSextractlastlsnfrombackup (Procedure)
sp_MSfixupftpinfo (Procedure)
sp_MSgeneratenosyncsubscriptionsetupscript (Procedure)
sp_MSgetarticlereinitvalue (Procedure)
sp_MSgetdbversion (Procedure)
sp_MSgetdynsnapvalidationtoken (Procedure)
sp_MSgetpartitionsnapshotfolder (Procedure)
sp_MSgettablecontents (Procedure)
sp_MSgettools_path (Procedure)
sp_MSgettransarticlecolumnlist (Procedure)
sp_MSget_file_existence (Procedure)
sp_MSget_jobstate (Procedure)
sp_MSget_min_seqno (Procedure)
sp_MSget_setup_paths (Procedure)
sp_MSgrantconnectreplication (Procedure)
sp_MShasdbaccess (Procedure)
sp_MShelpdestowner (Procedure)
sp_MShelpmergedynamicsnapshotjob (Procedure)
sp_MShelptracertokenhistory (Procedure)
sp_MShelptracertokens (Procedure)
sp_MShelp_profile (Procedure)
sp_MShelp_profilecache (Procedure)
sp_MShelp_snapshot_agent (Procedure)
sp_MShelp_subscriberside_history (Procedure)
sp_MSinstance_qv (Procedure)
sp_MSisdistributionjobnamegenerated (Procedure)
sp_MSislogreaderjobnamegenerated (Procedure)
sp_MSismergejobnamegenerated (Procedure)
sp_MSispulldistributionjobnamegenerated (Procedure)
sp_MSispullmergejobnamegenerated (Procedure)
sp_MSisqueuereaderjobnamegenerated (Procedure)
sp_MSissnapshotitemapplied (Procedure)
sp_MSissnapshotjobnamegenerated (Procedure)
sp_MSmakebatchinsertproc (Procedure)
sp_MSmakebatchupdateproc (Procedure)
sp_MSmaketrancftproc (Procedure)
sp_MSmakeupdateproc (Procedure)
sp_MSmerge_create_sub_table (Procedure)
sp_MSmerge_dropindex (Procedure)
sp_MSmerge_log_idrange_alloc_on_distributor (Procedure)
sp_MSobjectprivs (Procedure)
sp_MSpeerdbinfo (Procedure)
sp_MSpurgepartialmergesnapshot (Procedure)
sp_MSrecordsnapshotdeliveryprogress (Procedure)
sp_MSregisterdynsnapseqno (Procedure)
sp_MSregistermergesnappubid (Procedure)
sp_MSregistersubscription (Procedure)
sp_MSremovedbreplication (Procedure)
sp_MSremove_userscript (Procedure)
sp_MSreplclosesymmetrickey (Procedure)
sp_MSreplcopyscriptfile (Procedure)
sp_MSrepldecrypt (Procedure)
sp_MSreplencrypt (Procedure)
sp_MSreplopensymmetrickey (Procedure)
sp_MSreplremoveuncdir (Procedure)
sp_MSrepltrigcertgrant (Procedure)
sp_MSrepl_adddistpublisher (Procedure)
sp_MSrepl_addpublication (Procedure)
sp_MSrepl_addpushsubscription_agent (Procedure)
sp_MSrepl_addsubscriber (Procedure)
sp_MSrepl_addsubscription (Procedure)
sp_MSrepl_changearticle (Procedure)
sp_MSrepl_changepublication (Procedure)
sp_MSrepl_check_job_access (Procedure)
sp_MSrepl_clean_replication_bit (Procedure)
sp_MSrepl_drop_all_role_members (Procedure)
sp_MSrepl_getdistributorinfo (Procedure)
sp_MSrepl_getpublisherinfo (Procedure)
sp_MSrepl_helpreplicationdboptionex (Procedure)
sp_MSrepl_reinitsubscription (Procedure)
sp_MSrepl_set_oracle_provider_inproc_on64bit (Procedure)
sp_MSrepl_testconnection (Procedure)
sp_MSrepl_verify_oracle_client_version (Procedure)
sp_MSrepl_verify_oracle_provider_isregistered (Procedure)
sp_MSrestore_sub (Procedure)
sp_MSrevokeconnectreplication (Procedure)
sp_MSscript_sync_del_proc (Procedure)
sp_MSscript_sync_ins_proc (Procedure)
sp_MSscript_sync_upd_proc (Procedure)
sp_MSsetupbelongs (Procedure)
sp_MSsetupnosyncsubscriptionwithlsn (Procedure)
sp_MSsetupnosyncsubwithlsnatdist (Procedure)
sp_MSset_oledb_prop (Procedure)
sp_MSsubscription_enabled_for_syncmgr (Procedure)
sp_MStran_ddlrepl (Procedure)
sp_MSupdatesharedagentproperties (Procedure)
sp_MSupdatesysmergearticles (Procedure)
sp_MSupdate_subscriber_tracer_history (Procedure)
sp_MSupdate_tracer_history (Procedure)
sp_MSupgrade_distdb_security_metadata (Procedure)
sp_MSupgrade_subdb_security_metadata (Procedure)
sp_MSvalidate_agent_parameter (Procedure)
sp_MSvupgrade_registry_core (Procedure)
sp_msx_enlist (Procedure)
sp_MS_replication_installed (Procedure)
sp_notify_operator (Procedure)
sp_ORAhelpXactBatching (Procedure)
sp_ORAhelpXactSetJob (Procedure)
sp_post_msx_operation (Procedure)
sp_procoption (Procedure)
sp_readwebtask (Procedure)
sp_refreshreplsysservers (Procedure)
sp_registercustomresolver (Procedure)
sp_rename (Procedure)
sp_replgetparsedddlcmd (Procedure)
sp_replscriptuniquekeywhereclause (Procedure)
sp_restoremergeidentityrange (Procedure)
sp_resync_targetserver (Procedure)
sp_revoke_login_from_proxy (Procedure)
sp_revoke_proxy_from_subsystem (Procedure)
sp_RunMailQuery (Procedure)
sp_runwebtask (Procedure)
sp_scriptupdateparams (Procedure)
sp_scriptupdproccore (Procedure)
sp_serveroption (Procedure)
sp_setdefaultdatatypemapping (Procedure)
sp_setnetname (Procedure)
sp_SetPublicInterfaceObject (Procedure)
sp_settriggerorder (Procedure)
sp_set_sqlagent_properties (Procedure)
sp_sqlagent_notify (Procedure)
sp_start_job (Procedure)
sp_stop_job (Procedure)
sp_subscribe (Procedure)
sp_syscollector_create_collection_item (Procedure)
sp_syscollector_create_collection_set (Procedure)
sp_syscollector_event_oncollectionbegin (Procedure)
sp_syscollector_event_oncollectionstart (Procedure)
sp_syscollector_event_onpackagebegin (Procedure)
sp_syscollector_run_collection_set (Procedure)
sp_syscollector_start_collection_set (Procedure)
sp_syscollector_stop_collection_set (Procedure)
sp_syscollector_update_collection_item (Procedure)
sp_syscollector_update_collection_item_internal (Procedure)
sp_syscollector_update_collection_set (Procedure)
sp_syscollector_upload_collection_set (Procedure)
sp_syscollector_validate_xml (Procedure)
sp_syscollector_verify_collection_item (Procedure)
sp_syscollector_verify_collection_set (Procedure)
sp_syscollector_verify_collector_type (Procedure)
sp_syspolicy_add_policy (Procedure)
sp_syspolicy_update_policy (Procedure)
sp_syspolicy_update_policy_category_subscription (Procedure)
sp_tableoption (Procedure)
sp_table_statistics2_rowset (Procedure)
sp_table_types (Procedure)
sp_unbindefault (Procedure)
sp_unbindrule (Procedure)
sp_unregistercustomresolver (Procedure)
sp_unsubscribe (Procedure)
sp_update_alert (Procedure)
sp_update_category (Procedure)
sp_update_job (Procedure)
sp_update_jobschedule (Procedure)
sp_update_jobstep (Procedure)
sp_update_notification (Procedure)
sp_update_operator (Procedure)
sp_update_proxy (Procedure)
sp_update_schedule (Procedure)
sp_update_targetservergroup (Procedure)
sp_verify_alert (Procedure)
sp_verify_category (Procedure)
sp_verify_category_identifiers (Procedure)
sp_verify_credential_identifiers (Procedure)
sp_verify_job (Procedure)
sp_verify_jobproc_caller (Procedure)
sp_verify_jobstep (Procedure)
sp_verify_job_date (Procedure)
sp_verify_job_identifiers (Procedure)
sp_verify_job_time (Procedure)
sp_verify_notification (Procedure)
sp_verify_operator (Procedure)
sp_verify_operator_identifiers (Procedure)
sp_verify_proxy_identifiers (Procedure)
sp_verify_schedule (Procedure)
sp_verify_schedule_identifiers (Procedure)
sp_verify_subsystem (Procedure)
sp_verify_subsystem_identifiers (Procedure)
sp_vupgrade_mergeobjects (Procedure)
sp_vupgrade_registry (Procedure)
sp_vupgrade_registry_custom_resolver_katmai (Procedure)
sp_vupgrade_replmsdb (Procedure)
syscollector_collection_items (View)
sysmail_delete_principalprofile_sp (Procedure)
sysmail_delete_profileaccount_sp (Procedure)
sysmail_help_principalprofile_sp (Procedure)
sysmail_verify_account_sp (Procedure)
sysmail_verify_principal_sp (Procedure)
sysmail_verify_profile_sp (Procedure)
system_parameters (View)
system_parameters$ (View)
xp_logininfo (Procedure)
xp_repl_convert_encrypt_sysadmin_wrapper (Procedure)
       



News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash