DEFINITIONS

Definitions More Info.
Definition ID202
TitleSQL
CategoryKOMUT
DefinitionDDL Statements That Have Server or Database Scope KOMUTLAR
Definition DescriptionAsagidaki komutlar daha cok log tutmak icin kullanılacak CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION, CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE, CREATE_INDEX, ALTER_INDEX, DROP_INDEX, CREATE_TABLE, ALTER_TABLE, DROP_TABLE, CREATE_TRIGGER, ALTER_TRIGGER, DROP_TRIGGER, CREATE_STATISTICS, DROP_STATISTICS, UPDATE_STATISTICS, CREATE_PARTITION_FUNCTION, ALTER_PARTITION_FUNCTION, DROP_PARTITION_FUNCTION, CREATE_PARTITION_SCHEME, ALTER_PARTITION_SCHEME, DROP_PARTITION_SCHEME, CREATE_SCHEMA, ALTER_SCHEMA, DROP_SCHEMA, CREATE_USER, ALTER_USER, DROP_USER, CREATE_VIEW, ALTER_VIEW, DROP_VIEW, CREATE_XML_INDEX, CREATE_LINKED_SERVER, ALTER_LINKED_SERVER, DROP_LINKED_SERVER, CREATE_LINKED_SERVER_LOGIN, DROP_LINKED_SERVER_LOGIN, CREATE_LOGIN, ALTER_LOGIN, DROP_LOGIN --CREATE_APPLICATION_ROLE, --ALTER_APPLICATION_ROLE, --DROP_APPLICATION_ROLE, --CREATE_ASSEMBLY, --ALTER_ASSEMBLY, --DROP_ASSEMBLY, --CREATE_ASYMMETRIC_KEY, --ALTER_ASYMMETRIC_KEY, --DROP_ASYMMETRIC_KEY, --CREATE_AUTHORIZATION, --ALTER_AUTHORIZATION, --DROP_AUTHORIZATION, --CREATE_BROKER_PRIORITY, --ALTER_BROKER_PRIORITY, --DROP_BROKER_PRIORITY, --CREATE_CERTIFICATE, --ALTER_CERTIFICATE, --DROP_CERTIFICATE, --CREATE_CONTRACT, --ALTER_CONTRACT, --DROP_CONTRACT, --CREATE_CREDENTIAL, --ALTER_CREDENTIAL, --DROP_CREDENTIAL, --GRANT_DATABASE, --DENY_DATABASE, --REVOKE_DATABASE, --CREATE_DATABASE_AUDIT_SPEFICIATION, --ALTER_DATABASE_AUDIT_SPEFICIATION, --DENY_DATABASE_AUDIT_SPEFICIATION, --CREATE_DATABASE_ENCRYPTION_KEY, --ALTER_DATABASE_ENCRYPTION_KEY, --DROP_DATABASE_ENCRYPTION_KEY, --CREATE_DEFAULT, --DROP_DEFAULT, --BIND_DEFAULT, --UNBIND_DEFAULT, --CREATE_EVENT_NOTIFICATION, --DROP_EVENT_NOTIFICATION, --CREATE_EXTENDED_PROPERTY, --ALTER_EXTENDED_PROPERTY, --DROP_EXTENDED_PROPERTY, --CREATE_FULLTEXT_CATALOG, --ALTER_FULLTEXT_CATALOG, --DROP_FULLTEXT_CATALOG, --CREATE_FULLTEXT_INDEX, --ALTER_FULLTEXT_INDEX, --DROP_FULLTEXT_INDEX, --CREATE_FULLTEXT_STOPLIST, --ALTER_FULLTEXT_STOPLIST, --DROP_FULLTEXT_STOPLIST, --CREATE_MASTER_KEY, --ALTER_MASTER_KEY, --DROP_MASTER_KEY, --CREATE_MESSAGE_TYPE, --ALTER_MESSAGE_TYPE, --DROP_MESSAGE_TYPE, --CREATE_PLAN_GUIDE, --ALTER_PLAN_GUIDE, --DROP_PLAN_GUIDE, --CREATE_QUEUE, --ALTER_QUEUE, --DROP_QUEUE, --CREATE_REMOTE_SERVICE_BINDING, --ALTER_REMOTE_SERVICE_BINDING, --DROP_REMOTE_SERVICE_BINDING, --CREATE_ROLE, --ALTER_ROLE, --DROP_ROL, --ADD_ROLE_MEMBER, --DROP_ROLE_MEMBER, --CREATE_ROUTE, --ALTER_ROUTE, --DROP_ROUTE, --CREATE_RULE, --DROP_RULE, --BIND_RULE, --UNBIND_RULE, --CREATE_SEARCH_PROPERTY_LIST, --ALTER_SEARCH_PROPERTY_LIST, --DROP_SEARCH_PROPERTY_LIST, --CREATE_SEQUENCE_EVENTS, --ALTER_SEQUENCE_EVENTS, --DROP_SEQUENCE_EVENTS, --CREATE_SERVER_ROLE, --ALTER_SERVER_ROLE, --DROP_SERVER_ROLE, --CREATE_SERVICE, --ALTER_SERVICE, --DROP_SERVICE, --ALTER_SERVICE_MASTER_KEY, --BACKUP_SERVICE_MASTER_KEY, --RESTORE_SERVICE_MASTER_KEY, --ADD_SIGNATURE, --DROP_SIGNATURE, --CREATE_SYMMETRIC_KEY, --ALTER_SYMMETRIC_KEY, --DROP_SYMMETRIC_KEY, --CREATE_SYNONYM, --DROP_SYNONYM, --CREATE_TYPE, --DROP_TYPE, --CREATE_XML_SCHEMA_COLLECTION, --ALTER_XML_SCHEMA_COLLECTION, --DROP_XML_SCHEMA_COLLECTION, --ALTER_AUTHORIZATION_SERVER, --ALTER_SERVER_CONFIGURATION, --ALTER_INSTANCE, --CREATE_AVAILABILITY_GROUP, --ALTER_AVAILABILITY_GROUP, --DROP_AVAILABILITY_GROUP, --CREATE_CREDENTIAL, --ALTER_CREDENTIAL, --DROP_CREDENTIAL, --CREATE_CRYPTOGRAPHIC_PROVIDER, --ALTER_CRYPTOGRAPHIC_PROVIDER, --DROP_CRYPTOGRAPHIC_PROVIDER, --CREATE_DATABASE, --ALTER_DATABASE, --DROP_DATABASE, --CREATE_ENDPOINT, --ALTER_ENDPOINT, --DROP_ENDPOINT, --CREATE_EVENT_SESSION, --ALTER_EVENT_SESSION, --DROP_EVENT_SESSION, --CREATE_EXTENDED_PROCEDURE, --DROP_EXTENDED_PROCEDURE, --CREATE_MESSAGE, --ALTER_MESSAGE, --DROP_MESSAGE, --CREATE_REMOTE_SERVER, --ALTER_REMOTE_SERVER, --DROP_REMOTE_SERVER, --CREATE_RESOURCE_POOL, --ALTER_RESOURCE_POOL, --DROP_RESOURCE_POOL, --GRANT_SERVER, --DENY_SERVER, --REVOKE_SERVER, --ADD_SERVER_ROLE_MEMBER, --DROP_SERVER_ROLE_MEMBER, --CREATE_SERVER_AUDIT, --ALTER_SERVER_AUDIT, --DROP_SERVER_AUDIT, --CREATE_SERVER_AUDIT_SPECIFICATION, --ALTER_SERVER_AUDIT_SPECIFICATION, --DROP_SERVER_AUDIT_SPECIFICATION, --CREATE_WORKLOAD_GROUP, --CREATE_WORKLOAD_GROUP, --CREATE_WORKLOAD_GROUP
RecordBycunay
Record Date21-06-2012 08:21:14
Düzenle
Kopyala
Sil