BESCHREIBUNG
Die Schlüssel in den SQL Server Tabellen werden vom SQL Server automatisch erzeugt. Es kann vorkommen, dass der interne Zähler nicht mehr aktuell ist und doppelte Schlüssel erzeugt werden.
LÖSUNG
Folgende SQL Befehle restaurieren die Schlüsselwerte. Sie müssen in einem Abfragefenster oder OSQL Fenster ausgeführt werden!
dbcc checkident ('tProjects', RESEED)
dbcc checkident ('tToolsLoaded', RESEED)
dbcc checkident ('tFavorites', RESEED)
dbcc checkident ('tFeeTasks', RESEED)
dbcc checkident ('tInvoices', RESEED)
dbcc checkident ('tProjectDocuments', RESEED)
dbcc checkident ('tProjectTeam', RESEED)
dbcc checkident ('tTasks', RESEED)
dbcc checkident ('tAccPayments', RESEED)
dbcc checkident ('tExpenseServices', RESEED)
dbcc checkident ('tFees', RESEED)
dbcc checkident ('tInvCurFactors', RESEED)
dbcc checkident ('tLumpSums', RESEED)
dbcc checkident ('tMaterialServices', RESEED)
dbcc checkident ('tPayments', RESEED)
dbcc checkident ('tTimeServices', RESEED)
dbcc checkident ('tMasterInvoiceState', RESEED)
dbcc checkident ('tScheduledItem', RESEED)
dbcc checkident ('tAuthorisationGroup', RESEED)
dbcc checkident ('tCategories', RESEED)
dbcc checkident ('tCostCenter', RESEED)
dbcc checkident ('tDepartment', RESEED)
dbcc checkident ('tInvoiceRptDefinition', RESEED)
dbcc checkident ('tMasterAccounts', RESEED)
dbcc checkident ('tMasterCurrencies', RESEED)
dbcc checkident ('tMasterFreeFields', RESEED)
dbcc checkident ('tMasterInvConditions', RESEED)
dbcc checkident ('tMasterPubHolidays', RESEED)
dbcc checkident ('tMasterTextTemplates', RESEED)
dbcc checkident ('tPrinter', RESEED)
dbcc checkident ('tProjectType', RESEED)
dbcc checkident ('tEmployees', RESEED)
dbcc checkident ('tMasterTaxKeys', RESEED)
dbcc checkident ('tBookings', RESEED)
dbcc checkident ('tContacts', RESEED)
dbcc checkident ('tCreditBalanceCorrections', RESEED)
dbcc checkident ('tEmployment', RESEED)
dbcc checkident ('tIntHourlyRate', RESEED)
dbcc checkident ('tMasterActivities', RESEED)
dbcc checkident ('tMasterExpenses', RESEED)
dbcc checkident ('tMasterMaterials', RESEED)
dbcc checkident ('tTaxKeyValidities', RESEED)
dbcc checkident ('tOrganizations', RESEED)
dbcc checkident ('tTools', RESEED)
dbcc checkident ('tActivities', RESEED)
dbcc checkident ('tBookingsLog', RESEED)
dbcc checkident ('tContactCategories', RESEED)
