Sql Server 7 – Misc, Top Exam Questions and answers, Graded A+

Sql Server 7 – Misc, Top Exam Questions and answers, Graded 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 provide query access against files and folders (read index server) regrebld utility used to backup