Sql Server 7 - Misc – Locking. Questions & answers, 100% Accurate. Rated A+

Sql Server 7 - Misc – Locking. Questions & answers, 100% Accurate. Rated A+ MSREPL_COMMANDS--this table lives in the distribution database. contains info about the location of synchronization files–– truncated after successful replication foreign keys in merge replication--when the fk table is not included in the publication you cannot add new rows or update the fk column. you can however still change other columns. error 1205--deadlock situation security level = 13 what is the general unicode locale identifier?--1033 sp_create_removeable--creates a removeable media database. 6 create trace wizard options--1. find the worse performing queries 2. identify scans of large tables 3. identify the cause of a deadlock 4. profile the performace of a stored procedure 5. trace tsql activity by application 6. trace tsql activity by user what is the sql server agent monitor?--component that automatically starts sql server agent if it abnormally stops virtual table--constructed to