none
After migration from Sql 2008 to 2012 not able to insert or update

    Question

  • Dear,

    I have migrated SQL Server 2008 R2 SP1 to SQL Server 2012 SP1.

    After I successfully upgrade my I am not able to insert anything in the application.

    I have tried to run

    DBCC

    CHECKDB('March7',REPAIR_ALLOW_DATA_LOSS)

    But even this command didn't help me can any one help me.

    Thursday, May 22, 2014 5:48 AM

Answers

  • We have fixed the issue its all about as you said in your earlier reply in each store procedure  we have to define severity

    SQL SERVER 2012 – Discontinued Functionality – RAISERROR syntax

    • Marked as answer by Zameer madani Thursday, May 22, 2014 8:38 AM
    Thursday, May 22, 2014 7:59 AM

All replies

  • I am not able to insert anything in the application.

    "Not able" means you get an error message (which one)?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, May 22, 2014 6:09 AM
  • DBCC results for 'march7'.

    Service Broker Msg 9675, State 1: Message Types analyzed: 14.

    Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

    Service Broker Msg 9667, State 1: Services analyzed: 3.

    Service Broker Msg 9668, State 1: Service Queues analyzed: 3.

    Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.

    Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.

    Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.

    Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.

    DBCC results for 'sys.sysrscols'.

    There are 5079 rows in 103 pages for object "sys.sysrscols".

    DBCC results for 'sys.sysrowsets'.

    There are 523 rows in 9 pages for object "sys.sysrowsets".

    DBCC results for 'sys.sysclones'.

    There are 0 rows in 0 pages for object "sys.sysclones".

    DBCC results for 'sys.sysallocunits'.

    There are 572 rows in 13 pages for object "sys.sysallocunits".

    DBCC results for 'sys.sysfiles1'.

    There are 2 rows in 1 pages for object "sys.sysfiles1".

    DBCC results for 'sys.sysseobjvalues'.

    There are 0 rows in 0 pages for object "sys.sysseobjvalues".

    DBCC results for 'sys.syspriorities'.

    There are 0 rows in 0 pages for object "sys.syspriorities".

    DBCC results for 'sys.sysdbfrag'.

    There are 0 rows in 0 pages for object "sys.sysdbfrag".

    DBCC results for 'sys.sysfgfrag'.

    There are 0 rows in 1 pages for object "sys.sysfgfrag".

    DBCC results for 'sys.sysdbfiles'.

    There are 2 rows in 1 pages for object "sys.sysdbfiles".

    DBCC results for 'sys.syspru'.

    There are 0 rows in 0 pages for object "sys.syspru".

    DBCC results for 'sys.sysbrickfiles'.

    There are 0 rows in 0 pages for object "sys.sysbrickfiles".

    DBCC results for 'sys.sysphfg'.

    There are 1 rows in 1 pages for object "sys.sysphfg".

    DBCC results for 'sys.sysprufiles'.

    There are 2 rows in 1 pages for object "sys.sysprufiles".

    DBCC results for 'sys.sysftinds'.

    There are 0 rows in 0 pages for object "sys.sysftinds".

    DBCC results for 'sys.sysowners'.

    There are 31 rows in 1 pages for object "sys.sysowners".

    DBCC results for 'sys.sysdbreg'.

    There are 0 rows in 0 pages for object "sys.sysdbreg".

    DBCC results for 'sys.sysprivs'.

    There are 287 rows in 2 pages for object "sys.sysprivs".

    DBCC results for 'sys.sysschobjs'.

    There are 4500 rows in 80 pages for object "sys.sysschobjs".

    DBCC results for 'sys.syscolpars'.

    There are 9716 rows in 233 pages for object "sys.syscolpars".

    DBCC results for 'sys.sysxlgns'.

    There are 0 rows in 0 pages for object "sys.sysxlgns".

    DBCC results for 'sys.sysxsrvs'.

    There are 0 rows in 0 pages for object "sys.sysxsrvs".

    DBCC results for 'sys.sysnsobjs'.

    There are 1 rows in 1 pages for object "sys.sysnsobjs".

    DBCC results for 'sys.sysusermsgs'.

    There are 0 rows in 0 pages for object "sys.sysusermsgs".

    DBCC results for 'sys.syscerts'.

    There are 0 rows in 0 pages for object "sys.syscerts".

    DBCC results for 'sys.sysrmtlgns'.

    There are 0 rows in 0 pages for object "sys.sysrmtlgns".

    DBCC results for 'sys.syslnklgns'.

    There are 0 rows in 0 pages for object "sys.syslnklgns".

    DBCC results for 'sys.sysxprops'.

    There are 18 rows in 6 pages for object "sys.sysxprops".

    DBCC results for 'sys.sysscalartypes'.

    There are 34 rows in 1 pages for object "sys.sysscalartypes".

    DBCC results for 'sys.systypedsubobjs'.

    There are 0 rows in 0 pages for object "sys.systypedsubobjs".

    DBCC results for 'sys.sysidxstats'.

    There are 2346 rows in 59 pages for object "sys.sysidxstats".

    DBCC results for 'sys.sysiscols'.

    There are 2536 rows in 20 pages for object "sys.sysiscols".

    DBCC results for 'sys.sysendpts'.

    There are 0 rows in 0 pages for object "sys.sysendpts".

    DBCC results for 'sys.syswebmethods'.

    There are 0 rows in 0 pages for object "sys.syswebmethods".

    DBCC results for 'sys.sysbinobjs'.

    There are 23 rows in 1 pages for object "sys.sysbinobjs".

    DBCC results for 'sys.sysaudacts'.

    There are 0 rows in 0 pages for object "sys.sysaudacts".

    DBCC results for 'sys.sysobjvalues'.

    There are 3945 rows in 1853 pages for object "sys.sysobjvalues".

    DBCC results for 'sys.syscscolsegments'.

    There are 0 rows in 0 pages for object "sys.syscscolsegments".

    DBCC results for 'sys.syscsdictionaries'.

    There are 0 rows in 0 pages for object "sys.syscsdictionaries".

    DBCC results for 'sys.sysclsobjs'.

    There are 32 rows in 1 pages for object "sys.sysclsobjs".

    DBCC results for 'sys.sysrowsetrefs'.

    There are 0 rows in 0 pages for object "sys.sysrowsetrefs".

    DBCC results for 'sys.sysremsvcbinds'.

    There are 0 rows in 0 pages for object "sys.sysremsvcbinds".

    DBCC results for 'sys.sysxmitqueue'.

    There are 0 rows in 0 pages for object "sys.sysxmitqueue".

    DBCC results for 'sys.sysrts'.

    There are 1 rows in 1 pages for object "sys.sysrts".

    DBCC results for 'sys.sysconvgroup'.

    There are 0 rows in 0 pages for object "sys.sysconvgroup".

    DBCC results for 'sys.sysdesend'.

    There are 0 rows in 0 pages for object "sys.sysdesend".

    DBCC results for 'sys.sysdercv'.

    There are 0 rows in 0 pages for object "sys.sysdercv".

    DBCC results for 'sys.syssingleobjrefs'.

    There are 1291 rows in 9 pages for object "sys.syssingleobjrefs".

    DBCC results for 'sys.sysmultiobjrefs'.

    There are 9929 rows in 87 pages for object "sys.sysmultiobjrefs".

    DBCC results for 'sys.sysguidrefs'.

    There are 0 rows in 0 pages for object "sys.sysguidrefs".

    DBCC results for 'sys.sysfoqueues'.

    There are 0 rows in 0 pages for object "sys.sysfoqueues".

    DBCC results for 'sys.syschildinsts'.

    There are 0 rows in 0 pages for object "sys.syschildinsts".

    DBCC results for 'sys.syscompfragments'.

    There are 0 rows in 0 pages for object "sys.syscompfragments".

    DBCC results for 'sys.sysftsemanticsdb'.

    There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".

    DBCC results for 'sys.sysftstops'.

    There are 0 rows in 0 pages for object "sys.sysftstops".

    DBCC results for 'sys.sysftproperties'.

    There are 0 rows in 0 pages for object "sys.sysftproperties".

    DBCC results for 'sys.sysxmitbody'.

    There are 0 rows in 0 pages for object "sys.sysxmitbody".

    DBCC results for 'sys.sysfos'.

    There are 0 rows in 0 pages for object "sys.sysfos".

    DBCC results for 'sys.sysqnames'.

    There are 99 rows in 1 pages for object "sys.sysqnames".

    DBCC results for 'sys.sysxmlcomponent'.

    There are 100 rows in 1 pages for object "sys.sysxmlcomponent".

    DBCC results for 'sys.sysxmlfacet'.

    There are 112 rows in 1 pages for object "sys.sysxmlfacet".

    DBCC results for 'sys.sysxmlplacement'.

    There are 19 rows in 1 pages for object "sys.sysxmlplacement".

    DBCC results for 'sys.sysobjkeycrypts'.

    There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".

    DBCC results for 'sys.sysasymkeys'.

    There are 0 rows in 0 pages for object "sys.sysasymkeys".

    DBCC results for 'sys.syssqlguides'.

    There are 0 rows in 0 pages for object "sys.syssqlguides".

    DBCC results for 'sys.sysbinsubobjs'.

    There are 3 rows in 1 pages for object "sys.sysbinsubobjs".

    DBCC results for 'sys.syssoftobjrefs'.

    There are 2748 rows in 35 pages for object "sys.syssoftobjrefs".

    DBCC results for 'ESFormContentsDetail'.

    There are 4003 rows in 232 pages for object "ESFormContentsDetail".

    DBCC results for 'PermisionApp'.

    There are 154 rows in 2 pages for object "PermisionApp".

    DBCC results for 'Audit_MemberLabor'.

    There are 2 rows in 1 pages for object "Audit_MemberLabor".

    DBCC results for 'TempPosterBal'.

    There are 114 rows in 4 pages for object "TempPosterBal".

    DBCC results for 'TempPosterBalTrans'.

    There are 127 rows in 2 pages for object "TempPosterBalTrans".

    DBCC results for 'PermitBookKeepingTypes'.

    There are 16105 rows in 71 pages for object "PermitBookKeepingTypes".

    DBCC results for 'Audit_MemberTransactionsException'.

    There are 1082 rows in 14 pages for object "Audit_MemberTransactionsException".

    DBCC results for 'PermitTravelHeader'.

    There are 0 rows in 1 pages for object "PermitTravelHeader".

    DBCC results for 'TempPosterBalTranslast'.

    There are 127 rows in 2 pages for object "TempPosterBalTranslast".

    DBCC results for 'Audit_MemberActivityUN'.

    There are 1208461 rows in 16928 pages for object "Audit_MemberActivityUN".

    DBCC results for 'ZIPValidate'.

    There are 469 rows in 2 pages for object "ZIPValidate".

    DBCC results for 'Audit_MemberAddresses'.

    There are 873624 rows in 7601 pages for object "Audit_MemberAddresses".

    DBCC results for 'user_mapping'.

    There are 349 rows in 7 pages for object "user_mapping".

    DBCC results for 'MainAcivity'.

    There are 5 rows in 1 pages for object "MainAcivity".

    DBCC results for 'MemberActivityUN'.

    There are 863861 rows in 8939 pages for object "MemberActivityUN".

    DBCC results for 'MemberLnkLocationComplex'.

    There are 6302 rows in 77 pages for object "MemberLnkLocationComplex".

    DBCC results for 'SignCollHeader'.

    There are 14125525 rows in 180490 pages for object "SignCollHeader".

    DBCC results for 'SubSysCodes'.

    There are 33 rows in 1 pages for object "SubSysCodes".

    DBCC results for 'Permisions'.

    There are 3251 rows in 24 pages for object "Permisions".

    DBCC results for 'ESSadadInv'.

    There are 0 rows in 0 pages for object "ESSadadInv".

    DBCC results for 'UserGroup'.

    There are 350 rows in 1 pages for object "UserGroup".

    DBCC results for 'Audit_Application'.

    There are 0 rows in 0 pages for object "Audit_Application".

    DBCC results for 'VisaType'.

    There are 5 rows in 1 pages for object "VisaType".

    DBCC results for 'DataMigrationErrorLog'.

    There are 31823 rows in 10243 pages for object "DataMigrationErrorLog".

    DBCC results for 'SysCodes'.

    There are 7 rows in 1 pages for object "SysCodes".

    DBCC results for 'MemberActivity'.

    There are 60 rows in 1 pages for object "MemberActivity".

    DBCC results for 'Application'.

    There are 2 rows in 1 pages for object "Application".

    DBCC results for 'Audit_BookTypes'.

    There are 7 rows in 1 pages for object "Audit_BookTypes".

    DBCC results for 'ScreenClasses'.

    There are 5 rows in 1 pages for object "ScreenClasses".

    DBCC results for 'PermitCompetCondition'.

    There are 507 rows in 6 pages for object "PermitCompetCondition".

    DBCC results for 'Audit_UserLogin'.

    There are 17965 rows in 164 pages for object "Audit_UserLogin".

    DBCC results for 'SignCollDetail'.

    There are 23815377 rows in 121129 pages for object "SignCollDetail".

    DBCC results for 'PermisionScreen'.

    There are 1303 rows in 10 pages for object "PermisionScreen".

    DBCC results for 'RefuseReason'.

    There are 7 rows in 1 pages for object "RefuseReason".

    DBCC results for 'SubAcivity'.

    There are 8 rows in 1 pages for object "SubAcivity".

    DBCC results for 'ControlCRInfo'.

    There are 9310 rows in 47 pages for object "ControlCRInfo".

    DBCC results for 'RefuseSign'.

    There are 99436 rows in 589 pages for object "RefuseSign".

    DBCC results for 'MemberNameAutoComplete'.

    There are 13 rows in 1 pages for object "MemberNameAutoComplete".

    DBCC results for 'ESAppReqPermitCompet'.

    There are 1 rows in 1 pages for object "ESAppReqPermitCompet".

    DBCC results for 'Audit_City'.

    There are 4 rows in 1 pages for object "Audit_City".

    DBCC results for 'ESClientComplaints'.

    There are 25 rows in 1 pages for object "ESClientComplaints".

    DBCC results for 'ControlFunction'.

    There are 5 rows in 1 pages for object "ControlFunction".

    DBCC results for 'SignCollOthersHeader'.

    There are 447191 rows in 6270 pages for object "SignCollOthersHeader".

    DBCC results for 'Poster'.

    There are 8238578 rows in 83621 pages for object "Poster".

    DBCC results for 'Screen'.

    There are 163 rows in 4 pages for object "Screen".

    DBCC results for 'MemberSubActivity'.

    There are 99 rows in 1 pages for object "MemberSubActivity".

    DBCC results for 'Audit_Country'.

    There are 6 rows in 1 pages for object "Audit_Country".

    DBCC results for 'AuthorizesTreatTemp'.

    There are 1272289 rows in 2673 pages for object "AuthorizesTreatTemp".

    DBCC results for 'AddressType'.

    There are 11 rows in 1 pages for object "AddressType".

    DBCC results for 'SignCollOthersDetail'.

    There are 746117 rows in 3336 pages for object "SignCollOthersDetail".

    DBCC results for 'Audit_PermitTypeReason'.

    There are 0 rows in 0 pages for object "Audit_PermitTypeReason".

    DBCC results for 'TempExcel'.

    There are 127 rows in 2 pages for object "TempExcel".

    DBCC results for 'TempMaterial'.

    There are 5437 rows in 129 pages for object "TempMaterial".

    DBCC results for 'OperationsControl'.

    There are 94979 rows in 1228 pages for object "OperationsControl".

    DBCC results for 'PermitCompetQuestion'.

    There are 689 rows in 9 pages for object "PermitCompetQuestion".

    DBCC results for 'Oracle_MEM_COLLECTION_temp'.

    There are 621418 rows in 7121 pages for object "Oracle_MEM_COLLECTION_temp".

    DBCC results for 'TransactionPosters_Old'.

    There are 30 rows in 1 pages for object "TransactionPosters_Old".

    DBCC results for 'aspnet_WebEvent_Events'.

    There are 0 rows in 0 pages for object "aspnet_WebEvent_Events".

    DBCC results for 'SignCollVisaHeader'.

    There are 1671800 rows in 21302 pages for object "SignCollVisaHeader".

    DBCC results for 'Audit_Screen'.

    There are 232 rows in 6 pages for object "Audit_Screen".

    DBCC results for 'TransactionPostersDetails_Old'.

    There are 1459880 rows in 5499 pages for object "TransactionPostersDetails_Old".

    DBCC results for 'ESWebUsers'.

    There are 1231 rows in 59 pages for object "ESWebUsers".

    DBCC results for 'PermitTransactions'.

    There are 150259 rows in 4615 pages for object "PermitTransactions".

    DBCC results for 'sys.filetable_updates_327828380'.

    There are 0 rows in 0 pages for object "sys.filetable_updates_327828380".

    DBCC results for 'Audit_PartnerPosition'.

    There are 0 rows in 0 pages for object "Audit_PartnerPosition".

    DBCC results for 'CoC_MemberMaster'.

    There are 96774 rows in 15184 pages for object "CoC_MemberMaster".

    DBCC results for 'AdministrativePosition'.

    There are 39 rows in 1 pages for object "AdministrativePosition".

    DBCC results for 'Oracle_VoucherNotExported'.

    There are 370 rows in 5 pages for object "Oracle_VoucherNotExported".

    DBCC results for 'Audit_ESFormContents'.

    There are 0 rows in 0 pages for object "Audit_ESFormContents".

    DBCC results for 'DirectionsofIssue'.

    There are 34 rows in 1 pages for object "DirectionsofIssue".

    DBCC results for 'Mem2011_copy'.

    There are 257623 rows in 11965 pages for object "Mem2011_copy".

    DBCC results for 'Audit_CollectionDetail'.

    There are 23016 rows in 198 pages for object "Audit_CollectionDetail".

    DBCC results for 'PosterConfiguraion'.

    There are 1 rows in 1 pages for object "PosterConfiguraion".

    DBCC results for 'Audit_ESFormContentsDetail'.

    There are 0 rows in 0 pages for object "Audit_ESFormContentsDetail".

    DBCC results for 'Audit_PackagingType'.

    There are 0 rows in 0 pages for object "Audit_PackagingType".

    DBCC results for 'Temp_RatificationLog_FixBug10032013'.

    There are 2706 rows in 13 pages for object "Temp_RatificationLog_FixBug10032013".

    DBCC results for 'PermissionSetup'.

    There are 1 rows in 1 pages for object "PermissionSetup".

    DBCC results for 'MainCR'.

    There are 1922 rows in 36 pages for object "MainCR".

    DBCC results for 'Oracle_mem_collection'.

    There are 12996 rows in 342 pages for object "Oracle_mem_collection".

    DBCC results for 'Country'.

    There are 250 rows in 3 pages for object "Country".

    DBCC results for 'Audit_OwnerType'.

    There are 0 rows in 0 pages for object "Audit_OwnerType".

    DBCC results for 'VoucherHeader'.

    There are 939551 rows in 25531 pages for object "VoucherHeader".

    DBCC results for 'aspnet_Applications'.

    There are 1 rows in 1 pages for object "aspnet_Applications".

    DBCC results for 'MemberTrans'.

    There are 939552 rows in 12953 pages for object "MemberTrans".

    DBCC results for 'Audit_VisaType'.

    There are 0 rows in 0 pages for object "Audit_VisaType".

    DBCC results for 'OLDPerson'.

    There are 13752 rows in 350 pages for object "OLDPerson".

    DBCC results for 'SadadUpdate'.

    There are 163725 rows in 1662 pages for object "SadadUpdate".

    DBCC results for 'Audit_MajorSector'.

    There are 0 rows in 0 pages for object "Audit_MajorSector".

    DBCC results for 'Oracle_ELECTION'.

    There are 5525 rows in 96 pages for object "Oracle_ELECTION".

    DBCC results for 'Complex'.

    There are 496 rows in 8 pages for object "Complex".

    DBCC results for 'ESAppReqPermitCompetCondition'.

    There are 0 rows in 0 pages for object "ESAppReqPermitCompetCondition".

    DBCC results for 'Query'.

    There are 6498 rows in 171 pages for object "Query".

    DBCC results for 'Audit_UserGroup'.

    There are 1136 rows in 8 pages for object "Audit_UserGroup".

    DBCC results for 'AdminComm.TempScannedDoc'.

    There are 295 rows in 4 pages for object "AdminComm.TempScannedDoc".

    DBCC results for 'ESWalletMemberRenew'.

    There are 1 rows in 1 pages for object "ESWalletMemberRenew".

    DBCC results for 'EPaymentErrorLog'.

    There are 306 rows in 2 pages for object "EPaymentErrorLog".

    DBCC results for 'TEMPDUPNAME'.

    There are 8056 rows in 86 pages for object "TEMPDUPNAME".

    DBCC results for 'Audit_TreatmentType'.

    There are 0 rows in 0 pages for object "Audit_TreatmentType".

    DBCC results for 'Position'.

    There are 18 rows in 1 pages for object "Position".

    DBCC results for 'TEMPDUPNAME_2'.

    There are 18124 rows in 225 pages for object "TEMPDUPNAME_2".

    DBCC results for 'ESAppReqPermitCompetPrize'.

    There are 0 rows in 0 pages for object "ESAppReqPermitCompetPrize".

    DBCC results for 'SignCollVisaDetail'.

    There are 2417387 rows in 9266 pages for object "SignCollVisaDetail".

    DBCC results for 'BranchCollectionTypeNumber'.

    There are 204 rows in 1 pages for object "BranchCollectionTypeNumber".

    DBCC results for 'Delegation'.

    There are 22 rows in 1 pages for object "Delegation".

    DBCC results for 'Audit_EPaymentErrorLog'.

    There are 1956 rows in 18 pages for object "Audit_EPaymentErrorLog".

    DBCC results for 'Audit_SpecialNumbers'.

    There are 1843 rows in 12 pages for object "Audit_SpecialNumbers".

    DBCC results for 'IndividualMale'.

    There are 46384 rows in 1232 pages for object "IndividualMale".

    DBCC results for 'Temp1'.

    There are 181296 rows in 2529 pages for object "Temp1".

    DBCC results for 'ESAppReqPermitCompetPrizeWinner'.

    There are 0 rows in 0 pages for object "ESAppReqPermitCompetPrizeWinner".

    DBCC results for 'Audit_ScreenPermission'.

    There are 45 rows in 1 pages for object "Audit_ScreenPermission".

    DBCC results for 'ExServicesCode'.

    There are 16 rows in 1 pages for object "ExServicesCode".

    DBCC results for 'Mem2013'.

    There are 257498 rows in 11921 pages for object "Mem2013".

    DBCC results for 'DocumentClass'.

    There are 13 rows in 1 pages for object "DocumentClass".

    DBCC results for 'ESFormContents'.

    There are 1025 rows in 21 pages for object "ESFormContents".

    DBCC results for 'PersonTitle'.

    There are 4 rows in 1 pages for object "PersonTitle".

    DBCC results for 'aspnet_Users'.

    There are 4453 rows in 78 pages for object "aspnet_Users".

    DBCC results for 'MemberCancelSignException_2013'.

    There are 36 rows in 1 pages for object "MemberCancelSignException_2013".

    DBCC results for 'Temp_TransIds_mainBranch'.

    There are 2997 rows in 8 pages for object "Temp_TransIds_mainBranch".

    DBCC results for 'ESAppReqPermitCompetQuestion'.

    There are 0 rows in 0 pages for object "ESAppReqPermitCompetQuestion".

    DBCC results for 'PermitBookKeeping'.

    There are 6997 rows in 85 pages for object "PermitBookKeeping".

    DBCC results for 'ArchivingDocuments'.

    There are 1389789 rows in 13451 pages for object "ArchivingDocuments".

    DBCC results for 'Audit_RefuseReason'.

    There are 0 rows in 0 pages for object "Audit_RefuseReason".

    DBCC results for 'ESAppReqPermitCompetSchedule'.

    There are 2 rows in 1 pages for object "ESAppReqPermitCompetSchedule".

    DBCC results for 'MemberCounter'.

    There are 1 rows in 1 pages for object "MemberCounter".

    DBCC results for 'CorruptedDocuments'.

    There are 0 rows in 1 pages for object "CorruptedDocuments".

    DBCC results for 'Audit_ReasonCancellation'.

    There are 0 rows in 0 pages for object "Audit_ReasonCancellation".

    DBCC results for 'PermitDiscountGood'.

    There are 27288 rows in 193 pages for object "PermitDiscountGood".

    DBCC results for 'ElectronicSignArchive'.

    There are 6734 rows in 21 pages for object "ElectronicSignArchive".

    DBCC results for 'aspnet_SchemaVersions'.

    There are 6 rows in 1 pages for object "aspnet_SchemaVersions".

    DBCC results for 'PosterHistoryERROR60'.

    There are 2254 rows in 32 pages for object "PosterHistoryERROR60".

    DBCC results for 'ActivitiesUN'.

    There are 3473 rows in 77 pages for object "ActivitiesUN".

    DBCC results for 'PermitException'.

    There are 721 rows in 9 pages for object "PermitException".

    DBCC results for 'PosterHistoryERROR72'.

    There are 1269 rows in 18 pages for object "PosterHistoryERROR72".

    DBCC results for 'Audit_Professions'.

    There are 0 rows in 0 pages for object "Audit_Professions".

    DBCC results for 'PosterHistoryERRORDiff'.

    There are 398 rows in 1 pages for object "PosterHistoryERRORDiff".

    DBCC results for 'PosterHistoryERRORDiff2'.

    There are 417 rows in 6 pages for object "PosterHistoryERRORDiff2".

    DBCC results for 'sys.filestream_tombstone_843202104'.

    There are 0 rows in 0 pages for object "sys.filestream_tombstone_843202104".

    DBCC results for 'VoucherDetail'.

    There are 1020282 rows in 9431 pages for object "VoucherDetail".

    DBCC results for 'ArchivingDocumentsTemp'.

    There are 120637 rows in 374 pages for object "ArchivingDocumentsTemp".

    DBCC results for 'PosterHistoryERRORDiff3'.

    There are 388 rows in 6 pages for object "PosterHistoryERRORDiff3".

    DBCC results for 'sys.syscommittab'.

    There are 0 rows in 0 pages for object "sys.syscommittab".

    DBCC results for 'TempMemIDs'.

    There are 7957 rows in 25 pages for object "TempMemIDs".

    DBCC results for 'SignCollDetail72'.

    There are 1131 rows in 6 pages for object "SignCollDetail72".

    DBCC results for 'Audit_Position'.

    There are 0 rows in 0 pages for object "Audit_Position".

    DBCC results for 'TreatmentType'.

    There are 63 rows in 1 pages for object "TreatmentType".

    DBCC results for 'Audit_MemberNote'.

    There are 871697 rows in 14667 pages for object "Audit_MemberNote".

    DBCC results for 'SignCollOthersDetail72'.

    There are 66 rows in 4 pages for object "SignCollOthersDetail72".

    DBCC results for 'PermitReexportGood'.

    There are 102554 rows in 218 pages for object "PermitReexportGood".

    DBCC results for 'Location'.

    There are 205 rows in 4 pages for object "Location".

    DBCC results for 'User'.

    There are 348 rows in 23 pages for object "User".

    DBCC results for 'SignCollOthersHeader72'.

    There are 39 rows in 2 pages for object "SignCollOthersHeader72".

    DBCC results for 'Degree'.

    There are 6 rows in 1 pages for object "Degree".

    DBCC results for 'SignCollVisaDetail72'.

    There are 279 rows in 12 pages for object "SignCollVisaDetail72".

    DBCC results for 'Audit_PersonTitle'.

    There are 0 rows in 0 pages for object "Audit_PersonTitle".

    DBCC results for 'Oracle_SERVICES'.

    There are 1225 rows in 10 pages for object "Oracle_SERVICES".

    DBCC results for 'ESAppReqPermitDiscount'.

    There are 0 rows in 0 pages for object "ESAppReqPermitDiscount".

    DBCC results for 'SignCollVisaHeader72'.

    There are 195 rows in 3 pages for object "SignCollVisaHeader72".

    DBCC results for 'Oracle_SERVICE_CODES'.

    There are 12 rows in 1 pages for object "Oracle_SERVICE_CODES".

    DBCC results for 'aspnet_Membership'.

    There are 4453 rows in 358 pages for object "aspnet_Membership".

    DBCC results for 'Bank'.

    There are 22 rows in 1 pages for object "Bank".

    DBCC results for 'PermitCompetSchedule'.

    There are 10240 rows in 134 pages for object "PermitCompetSchedule".

    DBCC results for 'EMAIL_NOTIFICATION'.

    There are 43469 rows in 14496 pages for object "EMAIL_NOTIFICATION".

    DBCC results for 'SignCollHeader72'.

    There are 582 rows in 9 pages for object "SignCollHeader72".

    DBCC results for 'CollectionType'.

    There are 14 rows in 1 pages for object "CollectionType".

    DBCC results for 'PermitCompetPrize'.

    There are 4091 rows in 36 pages for object "PermitCompetPrize".

    DBCC results for 'Oracle_MemberNotExported'.

    There are 28 rows in 1 pages for object "Oracle_MemberNotExported".

    DBCC results for 'Mem2011'.

    There are 257623 rows in 11857 pages for object "Mem2011".

    DBCC results for 'ScreenPermission'.

    There are 482 rows in 6 pages for object "ScreenPermission".

    DBCC results for 'Sign_Coll'.

    There are 13653 rows in 334 pages for object "Sign_Coll".

    DBCC results for 'PermitTypeReason'.

    There are 4 rows in 1 pages for object "PermitTypeReason".

    DBCC results for 'Audit_Person'.

    There are 2162267 rows in 57351 pages for object "Audit_Person".

    DBCC results for 'Collection'.

    There are 1069534 rows in 14531 pages for object "Collection".

    DBCC results for 'MemberNote'.

    There are 54829 rows in 1384 pages for object "MemberNote".

    DBCC results for 'PermitReexportCertCountry'.

    There are 130605 rows in 340 pages for object "PermitReexportCertCountry".

    DBCC results for 'SignCollDetLog72'.

    There are 1419 rows in 28 pages for object "SignCollDetLog72".

    DBCC results for 'Audit_MemberExService'.

    There are 3693 rows in 61 pages for object "Audit_MemberExService".

    DBCC results for 'KeyValueId'.

    There are 17872 rows in 40 pages for object "KeyValueId".

    DBCC results for 'Audit_PermitTravelHeader'.

    There are 0 rows in 1 pages for object "Audit_PermitTravelHeader".

    DBCC results for 'TempMemberRenewedNextYear'.

    There are 11693 rows in 37 pages for object "TempMemberRenewedNextYear".

    DBCC results for 'MemberAddresses'.

    There are 588302 rows in 3496 pages for object "MemberAddresses".

    DBCC results for 'ESAppReqPermitDiscountBrand'.

    There are 0 rows in 0 pages for object "ESAppReqPermitDiscountBrand".

    DBCC results for 'Oracle_MEM_COLLECTION_X_TRANS_TYPE'.

    There are 1485 rows in 47 pages for object "Oracle_MEM_COLLECTION_X_TRANS_TYPE".

    DBCC results for 'AttachmentInfo'.

    There are 0 rows in 0 pages for object "AttachmentInfo".

    DBCC results for 'Audit_PermitTravelDetail'.

    There are 0 rows in 1 pages for object "Audit_PermitTravelDetail".

    DBCC results for 'MemberExService'.

    There are 3541 rows in 48 pages for object "MemberExService".

    DBCC results for 'PermitCompetPrizeWinner'.

    There are 7893 rows in 119 pages for object "PermitCompetPrizeWinner".

    DBCC results for 'Audit_PermitTransactions'.

    There are 111320 rows in 4415 pages for object "Audit_PermitTransactions".

    DBCC results for 'VRC_HR_PersonBackup'.

    There are 28 rows in 1 pages for object "VRC_HR_PersonBackup".

    DBCC results for 'ESAppReqPermitDiscountGood'.

    There are 0 rows in 0 pages for object "ESAppReqPermitDiscountGood".

    DBCC results for 'PackagingType'.

    There are 126 rows in 2 pages for object "PackagingType".

    DBCC results for 'Audit_PermitReexportGood'.

    There are 36963 rows in 236 pages for object "Audit_PermitReexportGood".

    DBCC results for 'Audit_Collection'.

    There are 1077882 rows in 18863 pages for object "Audit_Collection".

    DBCC results for 'UserBalance'.

    There are 56 rows in 1 pages for object "UserBalance".

    DBCC results for 'PermitTravelDetail'.

    There are 0 rows in 1 pages for object "PermitTravelDetail".

    DBCC results for 'AdminComm.OutboundType'.

    There are 6 rows in 1 pages for object "AdminComm.OutboundType".

    DBCC results for 'Audit_MemberPartnersAndAuthorizes'.

    There are 809432 rows in 14718 pages for object "Audit_MemberPartnersAndAuthorizes".

    DBCC results for 'Audit_PermitReexportCertCountry'.

    There are 65012 rows in 445 pages for object "Audit_PermitReexportCertCountry".

    DBCC results for 'Nationality'.

    There are 184 rows in 3 pages for object "Nationality".

    DBCC results for 'ClassCommReg'.

    There are 33 rows in 1 pages for object "ClassCommReg".

    DBCC results for 'AdminComm.InternalAssignment'.

    There are 0 rows in 0 pages for object "AdminComm.InternalAssignment".

    DBCC results for 'SerialNumbers'.

    There are 1000000 rows in 1611 pages for object "SerialNumbers".

    DBCC results for 'AdminComm.Counter'.

    There are 2 rows in 1 pages for object "AdminComm.Counter".

    DBCC results for 'Audit_PermitException'.

    There are 1494 rows in 23 pages for object "Audit_PermitException".

    DBCC results for 'Audit_RDCCIConfiguraion'.

    There are 23 rows in 1 pages for object "Audit_RDCCIConfiguraion".

    DBCC results for 'ESWalletMemberBal'.

    There are 342 rows in 4 pages for object "ESWalletMemberBal".

    DBCC results for 'PermitReexportCert'.

    There are 100860 rows in 1968 pages for object "PermitReexportCert".

    DBCC results for 'AdminComm.InboundType'.

    There are 6 rows in 1 pages for object "AdminComm.InboundType".

    DBCC results for 'Audit_PermitDiscountGood'.

    There are 4110 rows in 46 pages for object "Audit_PermitDiscountGood".

    DBCC results for 'MemberCancelSignException'.

    There are 7 rows in 1 pages for object "MemberCancelSignException".

    DBCC results for 'Audit_PermitDiscount'.

    There are 3400 rows in 106 pages for object "Audit_PermitDiscount".

    DBCC results for 'AdminComm.Outbound'.

    There are 15233 rows in 556 pages for object "AdminComm.Outbound".

    DBCC results for 'PartnerPosition'.

    There are 38 rows in 1 pages for object "PartnerPosition".

    DBCC results for 'temptable'.

    There are 85750 rows in 314 pages for object "temptable".

    DBCC results for 'ESAppReqPermitReexportCert'.

    There are 1 rows in 1 pages for object "ESAppReqPermitReexportCert".

    DBCC results for 'Audit_PermitDicountBrand'.

    There are 14426 rows in 183 pages for object "Audit_PermitDicountBrand".

    DBCC results for 'TEMP'.

    There are 46 rows in 3 pages for object "TEMP".

    DBCC results for 'aspnet_Profile'.

    There are 0 rows in 0 pages for object "aspnet_Profile".

    DBCC results for 'MemberForeignComp'.

    There are 0 rows in 1 pages for object "MemberForeignComp".

    DBCC results for 'AdminComm.AttachmentType'.

    There are 7 rows in 1 pages for object "AdminComm.AttachmentType".

    DBCC results for 'VRC_HR_Person'.

    There are 352 rows in 11 pages for object "VRC_HR_Person".

    DBCC results for 'OldTempMember'.

    There are 63071 rows in 136 pages for object "OldTempMember".

    DBCC results for 'Audit_PermitCompetSchedule'.

    There are 32711 rows in 468 pages for object "Audit_PermitCompetSchedule".

    DBCC results for 'AdminComm.IndexType'.

    There are 23 rows in 1 pages for object "AdminComm.IndexType".

    DBCC results for 'OldTempMemberExceptSign'.

    There are 108 rows in 1 pages for object "OldTempMemberExceptSign".

    DBCC results for 'Audit_PermitCompetQuestion'.

    There are 38 rows in 1 pages for object "Audit_PermitCompetQuestion".

    DBCC results for 'OwnerType'.

    There are 30 rows in 1 pages for object "OwnerType".

    DBCC results for 'TempEle'.

    There are 62814 rows in 700 pages for object "TempEle".

    DBCC results for 'Currency'.

    There are 17 rows in 1 pages for object "Currency".

    DBCC results for 'AdminComm.ExternalAssignment'.

    There are 12472 rows in 114 pages for object "AdminComm.ExternalAssignment".

    DBCC results for 'Audit_PermitCompetPrizeWinner'.

    There are 1584 rows in 27 pages for object "Audit_PermitCompetPrizeWinner".

    DBCC results for 'ELEmemberDeleted'.

    There are 6873 rows in 15 pages for object "ELEmemberDeleted".

    DBCC results for 'Audit_MemberDealCountries'.

    There are 0 rows in 0 pages for object "Audit_MemberDealCountries".

    DBCC results for 'Audit_ArchivingDocuments'.

    There are 311863 rows in 4433 pages for object "Audit_ArchivingDocuments".

    DBCC results for 'City'.

    There are 268 rows in 4 pages for object "City".

    DBCC results for 'Audit_UserBalance'.

    There are 112 rows in 2 pages for object "Audit_UserBalance".

    DBCC results for 'OldTempPrmitCompetExceptSign'.

    There are 14 rows in 1 pages for object "OldTempPrmitCompetExceptSign".

    DBCC results for 'BookTypes'.

    There are 3 rows in 1 pages for object "BookTypes".

    DBCC results for 'Audit_PermitReexportCert'.

    There are 38335 rows in 892 pages for object "Audit_PermitReexportCert".

    DBCC results for 'OldTempPrmitCertExceptSign'.

    There are 36 rows in 1 pages for object "OldTempPrmitCertExceptSign".

    DBCC results for 'AdminComm.ExternalPartyCategory'.

    There are 15 rows in 1 pages for object "AdminComm.ExternalPartyCategory".

    DBCC results for 'Audit_PermitCompetPrize'.

    There are 959 rows in 12 pages for object "Audit_PermitCompetPrize".

    DBCC results for 'ELEmember'.

    There are 57220 rows in 126 pages for object "ELEmember".

    DBCC results for 'ESForms'.

    There are 36 rows in 1 pages for object "ESForms".

    DBCC results for 'MemberDealCountries'.

    There are 16648 rows in 129 pages for object "MemberDealCountries".

    DBCC results for 'OldTempPrmitDiscountExceptSign'.

    There are 85 rows in 1 pages for object "OldTempPrmitDiscountExceptSign".

    DBCC results for 'Audit_PermitCompetCondition'.

    There are 21 rows in 1 pages for object "Audit_PermitCompetCondition".

    DBCC results for 'ESAppReqPermitReexportCountry'.

    There are 0 rows in 0 pages for object "ESAppReqPermitReexportCountry".

    DBCC results for 'OldTempPrmitBookExceptSign'.

    There are 4 rows in 1 pages for object "OldTempPrmitBookExceptSign".

    DBCC results for 'AdminComm.Action'.

    There are 9 rows in 1 pages for object "AdminComm.Action".

    DBCC results for 'QueryLastChange'.

    There are 357302 rows in 4484 pages for object "QueryLastChange".

    DBCC results for 'Branch'.

    There are 27 rows in 1 pages for object "Branch".

    DBCC results for 'OldTempMemTransExceptSign'.

    There are 32 rows in 1 pages for object "OldTempMemTransExceptSign".

    DBCC results for 'Audit_PermitCompet'.

    There are 4179 rows in 160 pages for object "Audit_PermitCompet".

    DBCC results for 'ESFormColumnsDictionary'.

    There are 255 rows in 7 pages for object "ESFormColumnsDictionary".

    DBCC results for 'aspnet_Roles'.

    There are 6 rows in 1 pages for object "aspnet_Roles".

    DBCC results for 'MajorSector'.

    There are 5 rows in 1 pages for object "MajorSector".

    DBCC results for 'PERSONMIGRATIONTABLE'.

    There are 2 rows in 1 pages for object "PERSONMIGRATIONTABLE".

    DBCC results for 'OldMemberTrans'.

    There are 5702 rows in 78 pages for object "OldMemberTrans".

    DBCC results for 'OldVoucherHeader'.

    There are 5702 rows in 150 pages for object "OldVoucherHeader".

    DBCC results for 'AdminComm.Department'.

    There are 113 rows in 2 pages for object "AdminComm.Department".

    DBCC results for 'Audit_Tables'.

    There are 23 rows in 1 pages for object "Audit_Tables".

    DBCC results for 'Audit_PermitBookKeepingTypes'.

    There are 9733 rows in 84 pages for object "Audit_PermitBookKeepingTypes".

    DBCC results for 'ESAppReqPermitReexportGood'.

    There are 0 rows in 0 pages for object "ESAppReqPermitReexportGood".

    DBCC results for 'OldVoucherDetail'.

    There are 6399 rows in 60 pages for object "OldVoucherDetail".

    DBCC results for 'AdminComm.ScannedDoc'.

    There are 27118 rows in 350 pages for object "AdminComm.ScannedDoc".

    DBCC results for 'Audit_Lookups'.

    There are 963 rows in 11 pages for object "Audit_Lookups".

    DBCC results for 'Audit_PermitBookKeeping'.

    There are 4507 rows in 74 pages for object "Audit_PermitBookKeeping".

    DBCC results for 'PermisionFunction'.

    There are 32 rows in 1 pages for object "PermisionFunction".

    DBCC results for 'OldAuthorizeTreatment'.

    There are 3034609 rows in 6376 pages for object "OldAuthorizeTreatment".

    DBCC results for 'MemberExceptions'.

    There are 0 rows in 0 pages for object "MemberExceptions".

    DBCC results for 'OldSignCollVisaHeader'.

    There are 80 rows in 1 pages for object "OldSignCollVisaHeader".

    DBCC results for 'AdminComm.DeliveryMethod'.

    There are 8 rows in 1 pages for object "AdminComm.DeliveryMethod".

    DBCC results for 'Audit_PermissionSetup'.

    There are 26 rows in 1 pages for object "Audit_PermissionSetup".

    DBCC results for 'aspnet_UsersInRoles'.

    There are 1047 rows in 7 pages for object "aspnet_UsersInRoles".

    DBCC results for 'sysdiagrams'.

    There are 4 rows in 1 pages for object "sysdiagrams".

    DBCC results for 'dtproperties'.

    There are 0 rows in 0 pages for object "dtproperties".

    DBCC results for 'TransferUserBranch'.

    There are 1 rows in 1 pages for object "TransferUserBranch".

    DBCC results for 'AdminComm.ExternalParty'.

    There are 592 rows in 6 pages for object "AdminComm.ExternalParty".

    DBCC results for 'Audit_PermisionScreen'.

    There are 1452 rows in 17 pages for object "Audit_PermisionScreen".

    DBCC results for 'TransactionPosters'.

    There are 27006 rows in 195 pages for object "TransactionPosters".

    DBCC results for 'TransactionsPeriods'.

    There are 8 rows in 1 pages for object "TransactionsPeriods".

    DBCC results for 'OldSignCollHeader'.

    There are 32304 rows in 440 pages for object "OldSignCollHeader".

    DBCC results for 'Audit_Branch'.

    There are 314 rows in 8 pages for object "Audit_Branch".

    DBCC results for 'OldSignCollDetail'.

    There are 46018 rows in 206 pages for object "OldSignCollDetail".

    DBCC results for 'Audit_Permisions'.

    There are 3689 rows in 42 pages for object "Audit_Permisions".

    DBCC results for 'TransactionPostersDetails'.

    There are 44538816 rows in 165639 pages for object "TransactionPostersDetails".

    DBCC results for 'Common.Exceptions'.

    There are 2000132 rows in 306253 pages for object "Common.Exceptions".

    DBCC results for 'Oracle_Deal_Countries'.

    There are 0 rows in 0 pages for object "Oracle_Deal_Countries".

    DBCC results for 'MemberBank'.

    There are 25546 rows in 69 pages for object "MemberBank".

    DBCC results for 'CollectionDetail'.

    There are 23392 rows in 110 pages for object "CollectionDetail".

    DBCC results for 'OldSignCollVisaDetail'.

    There are 87 rows in 1 pages for object "OldSignCollVisaDetail".

    DBCC results for 'PermitDiscount'.

    There are 25671 rows in 641 pages for object "PermitDiscount".

    DBCC results for 'AdminComm.InboundTransaction'.

    There are 12235 rows in 436 pages for object "AdminComm.InboundTransaction".

    DBCC results for 'Audit_PermisionFunction'.

    There are 0 rows in 0 pages for object "Audit_PermisionFunction".

    DBCC results for 'PosterHistory'.

    There are 55889998 rows in 820742 pages for object "PosterHistory".

    DBCC results for 'OldMember'.

    There are 63071 rows in 7729 pages for object "OldMember".

    DBCC results for 'OldSpecialMember'.

    There are 549 rows in 2 pages for object "OldSpecialMember".

    DBCC results for 'AdminComm.InternalAssignmentEmployee'.

    There are 0 rows in 0 pages for object "AdminComm.InternalAssignmentEmployee".

    DBCC results for 'Audit_PermisionApp'.

    There are 184 rows in 3 pages for object "Audit_PermisionApp".

    DBCC results for 'ESArchivingFiles'.

    There are 0 rows in 0 pages for object "ESArchivingFiles".

    DBCC results for 'MemberCancellation'.

    There are 23603 rows in 569 pages for object "MemberCancellation".

    DBCC results for 'AdminComm.ExternalAssignmentInboundTransaction'.

    There are 12434 rows in 39 pages for object "AdminComm.ExternalAssignmentInboundTransaction".

    DBCC results for 'Audit_ClassCommReg'.

    There are 1 rows in 1 pages for object "Audit_ClassCommReg".

    DBCC results for 'DealType'.

    There are 4 rows in 1 pages for object "DealType".

    DBCC results for 'AdminComm.OutboundTransactions'.

    There are 0 rows in 1 pages for object "AdminComm.OutboundTransactions".

    DBCC results for 'Audit_Complex'.

    There are 8204 rows in 141 pages for object "Audit_Complex".

    DBCC results for 'BankDeposit'.

    There are 0 rows in 1 pages for object "BankDeposit".

    DBCC results for 'ESMemberNote'.

    There are 0 rows in 0 pages for object "ESMemberNote".

    DBCC results for 'OtherMember'.

    There are 68 rows in 2 pages for object "OtherMember".

    DBCC results for 'Exemption'.

    There are 7 rows in 1 pages for object "Exemption".

    DBCC results for 'PermitDicountBrand'.

    There are 37092 rows in 310 pages for object "PermitDicountBrand".

    DBCC results for 'AdminComm.OutboundParty'.

    There are 15343 rows in 53 pages for object "AdminComm.OutboundParty".

    DBCC results for 'Audit_Degree'.

    There are 46 rows in 1 pages for object "Audit_Degree".

    DBCC results for 'Audit_MemberCancellation'.

    There are 23666 rows in 615 pages for object "Audit_MemberCancellation".

    DBCC results for 'SpecialNumbers'.

    There are 1755 rows in 5 pages for object "SpecialNumbers".

    DBCC results for 'Temp_mapuser'.

    There are 374 rows in 4 pages for object "Temp_mapuser".

    DBCC results for 'AdminComm.AttachmentInfo'.

    There are 3381 rows in 25 pages for object "AdminComm.AttachmentInfo".

    DBCC results for 'Audit_Delegation'.

    There are 110 rows in 3 pages for object "Audit_Delegation".

    DBCC results for 'Temp_TimeFrames'.

    There are 3 rows in 1 pages for object "Temp_TimeFrames".

    DBCC results for 'MinorSector'.

    There are 2 rows in 1 pages for object "MinorSector".

    DBCC results for 'BankDepositDetails'.

    There are 0 rows in 0 pages for object "BankDepositDetails".

    DBCC results for 'Common.Messages'.

    There are 216 rows in 8 pages for object "Common.Messages".

    DBCC results for 'AdminComm.Employee'.

    There are 12 rows in 1 pages for object "AdminComm.Employee".

    DBCC results for 'Audit_Importers'.

    There are 12441 rows in 270 pages for object "Audit_Importers".

    DBCC results for 'aspnet_Paths'.

    There are 0 rows in 0 pages for object "aspnet_Paths".

    DBCC results for 'ESMessageAndSMSNotifications'.

    There are 6523 rows in 1136 pages for object "ESMessageAndSMSNotifications".

    DBCC results for 'Mem2012'.

    There are 224546 rows in 10471 pages for object "Mem2012".

    DBCC results for 'MemberPartnersAndAuthorizes'.

    There are 473736 rows in 8527 pages for object "MemberPartnersAndAuthorizes".

    DBCC results for 'Audit_Location'.

    There are 236 rows in 4 pages for object "Audit_Location".

    DBCC results for 'ESDocPapers'.

    There are 1039 rows in 22 pages for object "ESDocPapers".

    DBCC results for 'SadadUpdate_2012'.

    There are 125670 rows in 1169 pages for object "SadadUpdate_2012".

    DBCC results for 'Audit_SignCollVisaHeader'.

    There are 1022752 rows in 16139 pages for object "Audit_SignCollVisaHeader".

    DBCC results for 'ReasonCancellation'.

    There are 9 rows in 1 pages for object "ReasonCancellation".

    DBCC results for 'Audit_Member'.

    There are 2236347 rows in 113231 pages for object "Audit_Member".

    DBCC results for 'sys.queue_messages_1977058079'.

    There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".

    DBCC results for 'Audit_SignCollVisaDetail'.

    There are 1532624 rows in 12388 pages for object "Audit_SignCollVisaDetail".

    DBCC results for 'Importers'.

    There are 29893 rows in 546 pages for object "Importers".

    DBCC results for 'AuthorizeTreatment'.

    There are 12991503 rows in 29756 pages for object "AuthorizeTreatment".

    DBCC results for 'TransactionESDocPapers'.

    There are 69 rows in 3 pages for object "TransactionESDocPapers".

    DBCC results for 'Good'.

    There are 417 rows in 5 pages for object "Good".

    DBCC results for 'Audit_MemberAgency'.

    There are 0 rows in 0 pages for object "Audit_MemberAgency".

    DBCC results for 'Member'.

    There are 263341 rows in 12806 pages for object "Member".

    DBCC results for 'sys.queue_messages_2009058193'.

    There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".

    DBCC results for 'RDCCIConfiguraion'.

    There are 31 rows in 1 pages for object "RDCCIConfiguraion".

    DBCC results for 'ESLogAction'.

    There are 15572 rows in 233 pages for object "ESLogAction".

    DBCC results for 'MemberAgency'.

    There are 0 rows in 1 pages for object "MemberAgency".

    DBCC results for 'Professions'.

    There are 5 rows in 1 pages for object "Professions".

    DBCC results for 'tempDeg4'.

    There are 4381 rows in 10 pages for object "tempDeg4".

    DBCC results for 'Audit_MemberBank'.

    There are 25554 rows in 162 pages for object "Audit_MemberBank".

    DBCC results for 'aspnet_PersonalizationAllUsers'.

    There are 0 rows in 0 pages for object "aspnet_PersonalizationAllUsers".

    DBCC results for 'ESWalletTransaction'.

    There are 550 rows in 10 pages for object "ESWalletTransaction".

    DBCC results for 'sys.queue_messages_2041058307'.

    There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".

    DBCC results for 'Person'.

    There are 530306 rows in 13497 pages for object "Person".

    DBCC results for 'ESExceptions'.

    There are 4176 rows in 709 pages for object "ESExceptions".

    DBCC results for 'MemberLabor'.

    There are 2 rows in 1 pages for object "MemberLabor".

    DBCC results for 'Audit_MemberForeignComp'.

    There are 0 rows in 1 pages for object "Audit_MemberForeignComp".

    DBCC results for 'AccountNumber'.

    There are 138 rows in 1 pages for object "AccountNumber".

    DBCC results for 'MemberTransactionsException'.

    There are 727 rows in 10 pages for object "MemberTransactionsException".

    DBCC results for 'Audit_MemberNameAutoComplete'.

    There are 12 rows in 1 pages for object "Audit_MemberNameAutoComplete".

    DBCC results for 'ESApplicationParticipation'.

    There are 3938 rows in 142 pages for object "ESApplicationParticipation".

    DBCC results for 'aspnet_PersonalizationPerUser'.

    There are 0 rows in 0 pages for object "aspnet_PersonalizationPerUser".

    DBCC results for 'RatificationLog'.

    There are 55216 rows in 266 pages for object "RatificationLog".

    DBCC results for 'PermitCompet'.

    There are 2088 rows in 65 pages for object "PermitCompet".

    DBCC results for 'Group'.

    There are 24 rows in 1 pages for object "Group".

    DBCC results for 'Audit_MemberLnkLocationComplex'.

    There are 6028 rows in 89 pages for object "Audit_MemberLnkLocationComplex".

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'march7'.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.


    Thursday, May 22, 2014 6:28 AM
  • I didn't ask for the DBCC Output, I ask what happens when you try to insert data and which error message you may get? Was it a in-place or a side-by-side migration?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, May 22, 2014 6:33 AM
  • Sorry, it gives me incorrect syntax near 50009 error.
    Thursday, May 22, 2014 6:50 AM
  • no It was not side by side on a running instance I have upgraded.
    Thursday, May 22, 2014 6:54 AM
  • Could be more an application issue, may it uses some deprecated T-SQL syntax Features, which was removed in SQL Server 2012. You could use SQL Server Profiler to trace the Statement, which the application sends to SQL Server.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, May 22, 2014 7:05 AM
  • I

    In the visual studio we get this error the store procedure  is not working.

    I will check through sql profiler

    Thursday, May 22, 2014 7:22 AM
  • Dear Also I am not able to run any store procedure.
    Thursday, May 22, 2014 7:25 AM
  • Can you post the code of a small stored procedure, which is not working?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, May 22, 2014 7:33 AM
  • USE

    [march7]


    GO


    /****** Object:  StoredProcedure [AdminComm].[Rep_ExternalAssignmentFromDept]    Script Date: 5/22/2014 10:43:02 AM ******/


    SET

    ANSI_NULLSON

    GO

    SET

    QUOTED_IDENTIFIERON

    GO


    -- ****************************************************************************************************

    -- Author : Amer Jamaeen

    -- Create date : 01-11-2010

    -- Description : Determined to whome department the inboundtransactions assigned

    -- ****************************************************************************************************



    ALTER

    PROCEDURE[AdminComm].[Rep_ExternalAssignmentFromDept]


    (


    @DeptId     int,

    @StartDate       datetime,

    @EndDatedatetime


    )


    AS

    SET

    NOCOUNTON



    DECLARE


    @SQL_SELECT

      nvarchar(max),


    @SQL_WHERE

      nvarchar(max),


    @ParmDefinition

    nvarchar(max)


     

     


    SET

    @SQL_WHERE='';



    if

    @EndDateisnullor@EndDate=''


       

    set@EndDate=(selectmax(Date)fromAdminComm.ExternalAssignment)


       

    if@StartDateisnullor@StartDate=''


       

    set@StartDate=(selectmin(Date)fromAdminComm.ExternalAssignment)



    /* Select records according to the passed pageSize param */


    SET

    @SQL_SELECT=N'

          SELECT AdminComm.InboundTransaction.RegNo,

      AdminComm.InboundTransaction.Date as InboundTransactionDate  ,

      AdminComm.InboundTransaction.Subject,

      AdminComm.ExternalAssignment.ToDept,

      AdminComm.ExternalAssignment.Date, AdminComm.Action.Name as ActionName,

      AdminComm.ExternalAssignment.FromDept,

      AdminComm.Department.Name AS ReceiverDept

      FROM         AdminComm.ExternalAssignment INNER JOIN

      AdminComm.ExternalAssignmentInboundTransaction ON

      AdminComm.ExternalAssignment.Id = AdminComm.ExternalAssignmentInboundTransaction.ExternalAssignmentId

      INNER JOIN

      AdminComm.InboundTransaction ON

      AdminComm.ExternalAssignmentInboundTransaction.InboundTransactionId = AdminComm.InboundTransaction.Id INNER JOIN

      AdminComm.Action ON

      AdminComm.ExternalAssignmentInboundTransaction.ActionId = AdminComm.Action.Id

      INNER JOIN

      AdminComm.Department ON

      AdminComm.ExternalAssignment.ToDept = AdminComm.Department.DeptNo

      where AdminComm.ExternalAssignment.Date between @StartDate and @EndDate

    '


     


    IF

    @DeptId  <>-1

    SET@SQL_WHERE=N'  And AdminComm.ExternalAssignment.FromDept = @DeptId '

       


    SET

    @SQL_SELECT=@SQL_SELECT+@SQL_WHERE



    -- Print the select query


    Print

    @SQL_SELECT



    -- Specify the Params


    SET

    @ParmDefinition=N'

    @DeptId      int,

        @StartDate      datetime,

        @EndDate datetime'



    --Execute the query.


    EXEC

    Sp_ExecuteSql@SQL_SELECT,@ParmDefinition,


    @DeptId      ,


    @StartDate,

    @EndDate

     


    --------------------------------------------------------------------------------------------------------------


    Print

    @SQL_SELECT


    --------------------------------------------------------------------------------------------------------------


    Thursday, May 22, 2014 7:38 AM
  • We have many store procedures what after the upgrade what are other possibilities even I cannot insert manually  a record in the table. 
    Thursday, May 22, 2014 7:39 AM
  • Even when I try to delete a record it gives me errorwhen trying to delete a record.
    Thursday, May 22, 2014 7:42 AM
  • I think the error message is pretty clear: In table "ActivitiesUN" the column "ArbDesc" is defined as NOT NULL, but you (your app) tries to insert a NULL value and because of this it fails.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Shanky_621 Thursday, May 22, 2014 8:10 AM
    Thursday, May 22, 2014 7:47 AM
  • We have fixed the issue its all about as you said in your earlier reply in each store procedure  we have to define severity

    SQL SERVER 2012 – Discontinued Functionality – RAISERROR syntax

    • Marked as answer by Zameer madani Thursday, May 22, 2014 8:38 AM
    Thursday, May 22, 2014 7:59 AM