SMS SP2 db upgrade errors

---

• From: "a6avant@xxxxxxxxxxx" <a6avant@xxxxxxxxxxx>
• Date: 12 Feb 2007 05:09:09 -0800

---

Hi,

I recently tried upgrading our sms sp1 primary site to sp2 which
failed with an sql error. As I'm not a SQL person I'm wondering if
anybody is able to hint me in the right direction for this. The error
I'm getting is :

<02-07-2007 16:46:39> Upgrade database...
<02-07-2007 16:46:39> The database compatibility level for SMS_EVE is
80
<02-07-2007 16:46:39> Beginning script execution.
<02-07-2007 16:47:12> SQL Script: Creating indexes on Collections
<02-07-2007 16:47:12> SQL Script: Creating indexes on AttributeMap
<02-07-2007 16:47:12> SQL Script: Creating indexes on Collection_Rules
<02-07-2007 16:47:12> SQL Script: Creating indexes on
MachineIdGroupXRef
<02-07-2007 16:47:13> SQL Script: Creating indexes on
QueriableObjectColumns
<02-07-2007 16:47:13> SQL Script: Creating indexes on
PropertyDisplayNode
<02-07-2007 16:47:13> SQL Script: Creating indexes on CollectedFiles
<02-07-2007 16:47:13> SQL Script: Creating indexes on
PropertyDisplayProps
<02-07-2007 16:47:13> SQL Script: Creating indexes on PackageLocations
<02-07-2007 16:47:13> SQL Script: Creating indexes on PkgStatus
<02-07-2007 16:47:13> SQL Script: Creating indexes on PkgProgramOS
<02-07-2007 16:47:13> SQL Script: Creating indexes on
OfferStatusSummary
<02-07-2007 16:47:40> SQL Script: Creating indexes on StatusMessages
<02-07-2007 16:48:28> SQL Script: Creating indexes on
StatusMessageAttributes
<02-07-2007 16:48:36> SQL Script: Creating indexes on
SoftwareInventory
<02-07-2007 16:48:36> SQL Script: Creating indexes on SoftwareFile
<02-07-2007 16:48:36> SQL Script: Creating indexes on SoftwareFile
<02-07-2007 16:48:37> SQL Script: Creating indexes on
SoftwareProductMap
<02-07-2007 16:48:37> SQL Script: Creating indexes on
SoftwareProductMap
<02-07-2007 16:48:37> SQL Script: Creating indexes on System_DISC
<02-07-2007 16:48:37> SQL Script: Creating indexes on User_DISC
<02-07-2007 16:48:37> SQL Script: Creating indexes on User_Group_DISC
<02-07-2007 16:48:37> SQL Script: Creating indexes on System_DISC
<02-07-2007 16:48:37> SQL Script: Creating indexes on
MonthlyUsageSummary
<02-07-2007 16:48:37> SQL Script: Creating indexes on
MonthlyUsageSummary
<02-07-2007 16:48:37> SQL Script: Creating indexes on
MonthlyUsageSummary
<02-07-2007 16:48:37> SQL Script: Creating indexes on FileUsageSummary
<02-07-2007 16:48:37> SQL Script: Creating indexes on MeterData
<02-07-2007 16:48:37> SQL Script: Creating indexes on MeterData
<02-07-2007 16:48:37> SQL Script: Creating indexes on
CollectionMembers
<02-07-2007 16:48:37> SQL Script: Creating indexes on
CollectionMembers
<02-07-2007 16:48:37> SQL Script: Creating indexes on
SiteBoundaryADSite
<02-07-2007 16:48:37> SQL Script: Creating indexes on
SiteBoundaryIPSubnet
<02-07-2007 16:48:37> SQL Script: Creating indexes on
RoamingBoundaryADSite
<02-07-2007 16:48:37> SQL Script: Creating indexes on
RoamingBoundaryIPSubnet
<02-07-2007 16:48:37> SQL Script: Creating indexes on User_Group_DISC
<02-07-2007 16:48:38> SQL Script: Creating indexes on
ClientOfferStatus
<02-07-2007 16:48:38> SQL Script: Creating indexes on
ClientOfferStatus
<02-07-2007 16:48:38> SQL Script: Creating indexes on
PatchStatusSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on
PatchStatusSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on
VULNERABILITY_DETAIL_DEF
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdatesSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdatesSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdatesSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdatesSummary
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdateRelations
<02-07-2007 16:48:39> SQL Script: Creating indexes on ClientKeyData
<02-07-2007 16:48:39> SQL Script: Creating indexes on UpdatePackages
<02-07-2007 16:48:39> SQL Script: Creating indexes on ProgramOffers
<02-07-2007 16:48:39> SQL Script: Creating indexes on ProgramOffers
<02-07-2007 16:48:39> SQL Script: Creating indexes on SysResList
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSecurityInstancePermissions
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSecurityClassPermissions
<02-07-2007 16:48:39> SQL Script: Create SQL object vPackage
<02-07-2007 16:48:39> SQL Script: Create SQL object vAdvertisement
<02-07-2007 16:48:39> SQL Script: Create SQL object vProgram
<02-07-2007 16:48:39> SQL Script: Create SQL object vDistributionPoint
<02-07-2007 16:48:39> SQL Script: Create SQL object vCollections
<02-07-2007 16:48:39> SQL Script: Create SQL object
vCollectToSubCollect
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_AdvertisementInfo
<02-07-2007 16:48:39> SQL Script: Create SQL object vStatusMessages
<02-07-2007 16:48:39> SQL Script: Create SQL object
vMappedSoftwareProductRaw
<02-07-2007 16:48:39> SQL Script: Create SQL object vProductMapping
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_G_System_SoftwareFile
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_G_System_SoftwareProduct
<02-07-2007 16:48:39> SQL Script: Create SQL object vUnknownFile
<02-07-2007 16:48:39> SQL Script: Create SQL object vCollectedFile
<02-07-2007 16:48:39> SQL Script: Create SQL object
vPkgStatusSummaryDistPts
<02-07-2007 16:48:39> SQL Script: Create SQL object vPkgSite
<02-07-2007 16:48:39> SQL Script: Create SQL object
vPkgStatusSummaryDetail
<02-07-2007 16:48:39> SQL Script: Create SQL object
vPkgStatusSummaryRoot
<02-07-2007 16:48:39> SQL Script: Create SQL object
vOfferStatusSummarizer
<02-07-2007 16:48:39> SQL Script: Create SQL object
vOfferStatusSummarizer2
<02-07-2007 16:48:39> SQL Script: Create SQL object
vOfferStatusSummarizerRoot
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_ClientAdvertisementStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_ClientUpdateAdvertisementStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_AdvertisementStatusInformation
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSummarizers_SiteStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSummarizers_RootStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSummarizer_SiteSystem
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_ComponentSummarizer
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_SiteDetailSummarizer
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_UserInstancePermissions
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_ApplicableUpdatesSummary
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_G_System_PatchStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
vSMS_G_System_PatchStatusEx
<02-07-2007 16:48:39> SQL Script: Create SQL object System_Sites_ins
<02-07-2007 16:48:39> SQL Script: Create SQL object System_Sites_del
<02-07-2007 16:48:39> SQL Script: Create SQL object sp_GetIndexInfo
<02-07-2007 16:48:39> SQL Script: Create SQL object sp_SMSGetNextID
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_SMSGetNextID_Internal
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetNextInstanceKey
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetNextInstanceKey_Internal
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdateClientOfferStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdatePatchStatusSummary
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdatePatchStatusSummaryEx
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdateClientUpdateOfferStatus
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_DelOfferStatusInterval
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetOfferSummaryData
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetOffSummToRepl
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_PurgeOldOfferTokens
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_InsOfferStatusInterval
<02-07-2007 16:48:39> SQL Script: Create SQL object sp_VerifyNoLoops
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdOfferStatusSummary
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_DelOfferStatusSummary
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetOfferStatusInterval
<02-07-2007 16:48:39> SQL Script: Create SQL object sp_GetInvHistory
<02-07-2007 16:48:39> SQL Script: Create SQL object sp_CalcNumResults
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetSubCollections
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_GetAdvertisements
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_UpdAdvertMemberCount
<02-07-2007 16:48:39> SQL Script: Create SQL object vConversionRules
<02-07-2007 16:48:39> SQL Script: Create SQL object
sp_InsertConversionRule
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_DeleteConversionRuleById
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetIDForSoftwareProduct
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetIDForSoftwareProduct_Int
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetIDForSoftwareFile
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetIDForSoftwareFile_Int
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_SoftwareInventory
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetIDForSoftwareFilePath
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_DeleteOrphanedSINVInfo
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_DeleteAgedStatusMessages
<02-07-2007 16:48:40> SQL Script: Create SQL object
SoftwareFilePath_PK
<02-07-2007 16:48:40> SQL Script: Create SQL object
SoftwareFilePath_AK
<02-07-2007 16:48:40> SQL Script: Create SQL object SoftwareFile_PK
<02-07-2007 16:48:40> SQL Script: Create SQL object SoftwareFile_AK
<02-07-2007 16:48:40> SQL Script: Create SQL object SoftwareProduct_AK
<02-07-2007 16:48:40> SQL Script: Create SQL object sp_CollectedFile
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_SoftwareInventoryStatus
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetCompStatusSummary
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_UpdCompStatusSummary
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_UpdCompStatusTallys
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_DelMarkedCompStatus
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetSummarizers_SiteDetail
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_ReplAllOffersToParent
<02-07-2007 16:48:40> SQL Script: Create SQL object sp_DelOfferOrphans
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_InsStatusMessage
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_InsStatusMessageInsStr
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_InsStatusMessageAttribute
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_InsertComplianceData
<02-07-2007 16:48:40> SQL Script: Create SQL object
sp_GetGroupsWithData
<02-07-2007 16:48:40> SQL Script: Create SQL object
ArchitectureMap_del
<02-07-2007 16:48:40> SQL Script: Create SQL object GroupMap_del
<02-07-2007 16:48:40> SQL Script: Create SQL object SMSProcedure_del
<02-07-2007 16:48:41> SQL Script: Create SQL object Sites_del
<02-07-2007 16:48:41> SQL Script: Create SQL object DomainTypes_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
PropertyDisplayNode_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
StatMsgModuleNames_del
<02-07-2007 16:48:41> SQL Script: Create SQL object StatusMessages_del
<02-07-2007 16:48:41> SQL Script: Create SQL object SecurityObjs_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
SecurityObjUsers_del
<02-07-2007 16:48:41> SQL Script: Create SQL object ProgramOffers_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object ProgramOffers_del
<02-07-2007 16:48:41> SQL Script: Create SQL object SMSPackages_del
<02-07-2007 16:48:41> SQL Script: Create SQL object UpdatesSummary_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
UpdateRelations_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PatchStatusSummary_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
UpdatePackages_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object PkgPrograms_del
<02-07-2007 16:48:41> SQL Script: Create SQL object SoftwarePolicy_del
<02-07-2007 16:48:41> SQL Script: Create SQL object SettingsPolicy_del
<02-07-2007 16:48:41> SQL Script: Create SQL object ResyncPolicy_del
<02-07-2007 16:48:41> SQL Script: Create SQL object MeteringPolicy_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
MachineIdGroupXRef_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
MachineIdGroupXRef_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SupportedPlatforms_del
<02-07-2007 16:48:41> SQL Script: Create SQL object Collections_del
<02-07-2007 16:48:41> SQL Script: Create SQL object Collections_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
CollectionMembers_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DecrementCollectionChangeCount
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_MarkCollectionForDeletion
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_FixMembershipResults
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_TransferMembership
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_CreateCollectionMemberViews
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_RemoveCollectionMemberViews
<02-07-2007 16:48:41> SQL Script: Create SQL object
CollectionMembers_ins_upd_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_UpdateResCollOfferMap
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Rules_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Rules_ins
<02-07-2007 16:48:41> SQL Script: Create SQL object
DiscoveryArchitectures_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DiscPropertyDefs_del
<02-07-2007 16:48:41> SQL Script: Create SQL object SoftwareFile_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
SoftwareProduct_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
SoftwareFilePath_del
<02-07-2007 16:48:41> SQL Script: Create SQL object PDF_Package_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
User_Group_DISC_del
<02-07-2007 16:48:41> SQL Script: Create SQL object User_DISC_del
<02-07-2007 16:48:41> SQL Script: Create SQL object System_DISC_del
<02-07-2007 16:48:41> SQL Script: Create SQL object System_DATA_del
<02-07-2007 16:48:41> SQL Script: Create SQL object Agents_del
<02-07-2007 16:48:41> SQL Script: Create SQL object Queries_del
<02-07-2007 16:48:41> SQL Script: Create SQL object DWTr_User_Disc_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DWTr_User_Group_DISC_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DWTr_SoftwareInventory_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DWTr_CollectionMembers_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DWTr_PatchStatusSummary_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object
DWTr_System_Disc_Del
<02-07-2007 16:48:41> SQL Script: Create SQL object System_DATA_ins
<02-07-2007 16:48:41> SQL Script: Create SQL object
Software_Updates_DATA_iud
<02-07-2007 16:48:41> SQL Script: Create SQL object
Software_Updates_Extended_DATA_iud
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DATA_iud
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DETAIL_DATA_iud
<02-07-2007 16:48:41> SQL Script: Create SQL object
WorkstationStatus_DATA_ins
<02-07-2007 16:48:41> SQL Script: Create SQL object System_HIST_iu
<02-07-2007 16:48:41> SQL Script: Create SQL object GroupMap_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
AttributeMap_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SMSProcParameters_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object SiteWork_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SiteControl_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SiteControlNotif_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object Domains_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SiteNotification_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SecurityObjUsers_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SecurityObjInstances_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
StatusMessageAttr_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
StatusMessageIns_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
QueriableObjectCol_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
QueriableObjectRel_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PropertyDisplayProps_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PropertyScopeProps_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
OfferNotification_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
ProgramOffers_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PkgNotification_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object PkgAccess_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PkgPrograms_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object PkgStatus_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PkgRuleExpressions_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object PkgServers_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
PkgProgramOS_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SoftwarePolicy_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
SettingsPolicy_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
ResyncPolicy_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
MeteringPolicy_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
DiscPropertyDefs_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
DiscItemAgents_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Rules_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Rules_SQL_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_SubColl_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_SubColl_del
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Copies_ins
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_MemberChg_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
Collection_Maint_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
CollectionOfferList_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
ProgramGroupProgramItems_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object Packages_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object ProgramItems_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object ProgramGroups_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
ProgramGroupUserGroups_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
PackageLocations_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object StatusMessages_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
StatusMessageAttributes_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
Summarizer_Components_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
Summarizer_ComponentTallys_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
OfferStatusSummary_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
OfferStatusSummaryDetail_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
OfferStatusIntervals_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
OfferStatusSummaryDetail_FK2
<02-07-2007 16:48:41> SQL Script: Create SQL object ConversionTypes_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object ConversionRules_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object Policy_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
PolicyAssignment_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DepPolicyAssignment_1_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DepPolicyAssignment_2_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_SUMM_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DEF_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_SUMM_1_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_SCORE_DEF_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_SUMM_2_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DETAIL_SUMM_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DETAIL_DEF_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DETAIL_SUMM_1_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
VULNERABILITY_DETAIL_SUMM_2_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object DataItem_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object InventoryClass_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
InventoryClassProperty_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
InventoryClassContext_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object InventoryAction_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItem_ActionID_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object InventoryClass_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItem_ClassID_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
InventoryClassContext_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItemContext_1_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItemContext_2_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
InventoryClassProperty_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItemProperty_1_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DataItemProperty_2_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object ConversionRules_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object ConversionRules_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
SoftwareProductCompliance_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
DiscoveryArchitectures_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object GroupMap_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object GroupMap_AK2
<02-07-2007 16:48:41> SQL Script: Create SQL object SMSProcedures_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object UpdatesSummary_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
PDF_Program_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_UpdateSiteSystemSummaryStatus
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_UpdateComponentSummaryStatus
<02-07-2007 16:48:41> SQL Script: Create SQL object MeterRules_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object MeteredUsers_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object MeteredUsers_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object MeterRules_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object MeterData_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
MeterData_MeteredUsers_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
MeterData_SoftwareFile_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
SummarizationInterval_PK
<02-07-2007 16:48:41> SQL Script: Create SQL object
SummarizationInterval_AK
<02-07-2007 16:48:41> SQL Script: Create SQL object
MonthlyUsageSummary_SummarizationInterval_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
MonthlyUsageSummary_SoftwareFile_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
MonthlyUsageSummary_MeteredUsers_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
FileUsageSummary_SoftwareFile_FK
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMeteringSummaryFiles
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetFileUsageSummary
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMonthlyUsageSummary
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_InsertFileUsageSummary
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_InsertMonthlyUsageSummary
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_MarkSummaryExportComplete
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMeteredUserID_int
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMeteredUserID
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_InsertMeterRules
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_UpdateMeterRules
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DeleteMeterRules
<02-07-2007 16:48:41> SQL Script: Create SQL object vProductFile_Info
<02-07-2007 16:48:41> SQL Script: Create SQL object
vSMS_MeteredProductRule
<02-07-2007 16:48:41> SQL Script: Create SQL object vSMS_MeteredFiles
<02-07-2007 16:48:41> SQL Script: Create SQL object vSMS_MeterData
<02-07-2007 16:48:41> SQL Script: Create SQL object
vSMS_G_System_SoftwareUsageData
<02-07-2007 16:48:41> SQL Script: Create SQL object MeterRules_ins_upd
<02-07-2007 16:48:41> SQL Script: Create SQL object MeterRules_del
<02-07-2007 16:48:41> SQL Script: Create SQL object sp_InsertMeterData
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMachineFromSMSUID
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetPublicKeySMSUID
<02-07-2007 16:48:41> SQL Script: Create SQL object sp_GetMeterRuleID
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetMeterRuleChanges
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DeleteMeterRuleChanges
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DeleteOldMeterData
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DeleteOldMeterSummary
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_DeleteAgedSCRMData
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetIntervalsWithData_MUS
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_GetIntervalsWithData_FUS
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_MakeSureIntervalExists
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_SummarizeMonthlyData
<02-07-2007 16:48:41> SQL Script: Create SQL object
sp_SummarizeFileUsageData
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_ClearUndiscoveredClients
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_GetInactiveClients
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_GetObsoleteClients
<02-07-2007 16:48:42> SQL Script: Create SQL object Report_PK
<02-07-2007 16:48:42> SQL Script: Create SQL object Report_AK
<02-07-2007 16:48:42> SQL Script: Create SQL object Report_AK2
<02-07-2007 16:48:42> SQL Script: Create SQL object Report_Report_FK
<02-07-2007 16:48:42> SQL Script: Create SQL object
ReportParameters_AK
<02-07-2007 16:48:42> SQL Script: Create SQL object
ReportParamters_Report_FK
<02-07-2007 16:48:42> SQL Script: Create SQL object
DrillThroughColumns_Report_FK
<02-07-2007 16:48:42> SQL Script: Create SQL object Dashboard_PK
<02-07-2007 16:48:42> SQL Script: Create SQL object
DashboardReports_Dashboard_FK
<02-07-2007 16:48:42> SQL Script: Create SQL object sp_DeleteReport
<02-07-2007 16:48:42> SQL Script: Create SQL object sp_DeleteDashboard
<02-07-2007 16:48:42> SQL Script: Create SQL object
vSMS_ReportViewSchema
<02-07-2007 16:48:42> SQL Script: Create SQL object
ReportParameters_ins
<02-07-2007 16:48:42> SQL Script: Create SQL object
ReportParameters_del
<02-07-2007 16:48:42> SQL Script: Create SQL object sp_GetSampleValues
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_CreateReportProc
<02-07-2007 16:48:42> SQL Script: Create SQL object
vSMS_ReportCategory
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Identification
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Site
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteBoundary_IPSubnet
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteBoundary_ADSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteRoamingBoundary_IPSubnet
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteRoamingBoundary_ADSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteRoamingBoundary_IPRange
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityData
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityDetailData
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityDefintion
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityDetailDefinition
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityScoreDefinition
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilitySummary
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_VulnerabilityDetailSummary
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ApplicableUpdatesSummary
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ApplicableUpdatesSummaryEx
<02-07-2007 16:48:42> SQL Script: Create SQL object v_UpdatePrograms
<02-07-2007 16:48:42> SQL Script: Create SQL object v_UpdateRelations
<02-07-2007 16:48:42> SQL Script: Create SQL object v_UpdateBundles
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GS_PatchStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GS_PatchStatusEx
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Package
<02-07-2007 16:48:42> SQL Script: Create SQL object v_PackageStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Program
<02-07-2007 16:48:42> SQL Script: Create SQL object v_OS_Details
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Advertisement
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_AdvertisementInfo
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_DistributionPoint
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_DistributionPointGroup
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Collection
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_FullCollectionMembership
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_CollectToSubCollect
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_CollectionRuleDirect
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_CollectionRuleQuery
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Query
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ResourceMap
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ResourceAttributeMap
<02-07-2007 16:48:42> SQL Script: Create SQL object v_AgentDiscoveries
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GroupMap
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_GroupAttributeMap
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_GS_SoftwareProduct
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GS_SoftwareFile
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_GS_SoftwareUsageData
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_GS_Mapped_Add_Remove_Programs
<02-07-2007 16:48:42> SQL Script: Create SQL object v_SoftwareFile
<02-07-2007 16:48:42> SQL Script: Create SQL object v_SoftwareProduct
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GS_UnknownFile
<02-07-2007 16:48:42> SQL Script: Create SQL object v_GS_CollectedFile
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_GS_LastSoftwareScan
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SoftwareProductCompliance
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SoftwareConversionRules
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SystemResourceList
<02-07-2007 16:48:42> SQL Script: Create SQL object v_StatusMessage
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_StatMsgAttributes
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_StatMsgInsStrings
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_StatMsgModuleNames
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_UserInstancePermissions
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_UserClassPermissions
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_UserInstancePermNames
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_UserClassPermNames
<02-07-2007 16:48:42> SQL Script: Create SQL object v_SecuredObject
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SummarizerRootStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SummarizerSiteStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteSystemSummarizer
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ComponentSummarizer
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SiteDetailSummarizer
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_PackageStatusRootSummarizer
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_PackageStatusDetailSumm
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_PackageStatusDistPointsSumm
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_AdvertisementStatusRootSumm
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_AdvertisementStatusSummarize
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ClientAdvertisementStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ClientUpdateAdvertisementStatus
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_AdvertisementStatusInformation
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ServerComponents
<02-07-2007 16:48:42> SQL Script: Create SQL object v_Report
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ReportParameter
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ReportDrillThroughColumns
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ReportDashboard
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_ReportDashboardReports
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ReportViewSchema
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_LocalizedNameLookup
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ReportCategory
<02-07-2007 16:48:42> SQL Script: Create SQL object v_MeterData
<02-07-2007 16:48:42> SQL Script: Create SQL object v_MeteredUser
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_MeteredProductRule
<02-07-2007 16:48:42> SQL Script: Create SQL object v_MeteredFiles
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_MeterRuleInstallBase
<02-07-2007 16:48:42> SQL Script: Create SQL object v_ProductFileInfo
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_SummarizationInterval
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_MonthlyUsageSummary
<02-07-2007 16:48:42> SQL Script: Create SQL object v_FileUsageSummary
<02-07-2007 16:48:42> SQL Script: Create SQL object
v_FileUsageSummaryIntervals
<02-07-2007 16:48:42> SQL Script: Create SQL object v_SchemaViews
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_CreateCollectionView
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RenewCollectionViews
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_CreateResourceView
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RemoveResourceView
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RenewResourceViews
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_CreateInventoryView
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RemoveInventoryView
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RenewInvGroupViews
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_RenewSMSSchemaViews
<02-07-2007 16:48:42> SQL Script: Create SQL object sp_RC_InvResync
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetAllInventoryClasses
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetInventoryClassProperties
<02-07-2007 16:48:42> SQL Script: Create SQL object MP_GetPolicyBody
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetMachinePolicyAssignments
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetUserAndUserGroupPolicyAssignments
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetListOfMPsInSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetMPListForSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetHINVLastUpdateTime
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetSiteInfoFromADSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetSiteInfoFromIPAddress
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetLocalSitesFromAssignedSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetMPSitesFromAssignedSite
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetContentDPInfoUnprotected
<02-07-2007 16:48:42> SQL Script: Create SQL object
MP_GetContentDPInfoProtected
<02-07-2007 16:48:42> SQL Script: Create SQL object DMP_GetFqdns
<02-07-2007 16:48:42> SQL Script: Create SQL object FqdnModification
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetMachinePolicies
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetPackageVersion
<02-07-2007 16:48:42> SQL Script: Create SQL object DMP_GetSettings
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetSoftwareDistBody
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetSoftwareDistIDs
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetHinvTranslations
<02-07-2007 16:48:42> SQL Script: Create SQL object
DMP_GetDiscoveryTranslations
<02-07-2007 16:48:42> SQL Script: Create SQL object
TranslationModification
<02-07-2007 16:48:42> SQL Script: Create SQL object
DiscoveryTranslationModification
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_DeleteFolderMember
<02-07-2007 16:48:42> SQL Script: Create SQL object vFolderMembers
<02-07-2007 16:48:42> SQL Script: Create SQL object
sp_FolderVerifyNoLoops
<02-07-2007 16:48:42> SQL Script: Create SQL object sp_DeleteFolder
<02-07-2007 16:48:42> SQL Script: Create SQL object Folders_PK
<02-07-2007 16:48:42> SQL Script: Create SQL object FolderMembers_FK
<02-07-2007 16:49:03> SqlExecute < IF user_id('smsschm_users') IS
NULL exec sp_addrole 'smsschm_users' DECLARE @pwd varchar(255) SET
@pwd = CONVERT(varchar(255),NEWID()) IF user_id('webreport_approle')
IS NULL exec sp_addapprole 'webreport_approle', @pwd DECLARE
@viewname varchar(255) DECLARE newviews INSENSITIVE CURSOR FOR
SELECT name FROM sysobjects WHERE type='V' AND name like 'v[_]%'
OPEN newviews FETCH NEXT FROM newviews INTO @viewname WHILE
(@@FETCH_STATUS <> -1) BEGIN EXEC('GRANT SELECT ON ' + @viewname
+ ' to smsschm_users, webreport_approle') FETCH NEXT FROM newviews
INTO @viewname END CLOSE newviews DEALLOCATE newviews GRANT
SELECT ON Report TO webreport_approle GRANT SELECT ON
ReportParameters TO webreport_approle GRANT SELECT ON
DrillThroughColumns TO webreport_approle GRANT SELECT ON Dashboard
TO webreport_approle GRANT SELECT ON DashboardReports TO
webreport_approle GRANT SELECT ON LocalizedNameLookup TO
webreport_approle GRANT EXECUTE ON sp_CreateReportProc TO
webreport_approle GRANT CREATE PROCEDURE TO webreport_approle EXEC
sp_RenewResourceViews EXEC sp_RenewInvGroupViews >
<02-07-2007 16:49:03> CSql::Execute failed, SQL error <[42000][170]
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
syntax near '-'.

<02-07-2007 16:49:03> Cannot execute sql command IF
user_id('smsschm_users') IS NULL exec sp_addrole 'smsschm_users'
DECLARE @pwd varchar(255) SET @pwd = CONVERT(varchar(255),NEWID())
IF user_id('webreport_approle') IS NULL exec sp_addapprole
'webreport_approle', @pwd DECLARE @viewname varchar(255) DECLARE
newviews INSENSITIVE CURSOR FOR SELECT name FROM sysobjects WHERE
type='V' AND name like 'v[_]%' OPEN newviews FETCH NEXT FROM
newviews INTO @viewname WHILE (@@FETCH_STATUS <> -1) BEGIN
EXEC('GRANT SELECT ON ' + @viewname + ' to smsschm_users,
webreport_approle') FETCH NEXT FROM newviews INTO @viewname
END CLOSE newviews DEALLOCATE newviews GRANT SELECT ON Report TO
webreport_approle GRANT SELECT ON ReportParameters TO
webreport_approle GRANT SELECT ON DrillThroughColumns TO
webreport_approle GRANT SELECT ON Dashboard TO webreport_approle
GRANT SELECT ON DashboardReports TO webreport_approle GRANT SELECT
ON LocalizedNameLookup TO webreport_approle GRANT EXECUTE ON
sp_CreateReportProc TO webreport_approle GRANT CREATE PROCEDURE TO
webreport_approle EXEC sp_RenewResourceViews EXEC
sp_RenewInvGroupViews

.

---

• Prev by Date: Re: Cache
• Next by Date: Printer discovery Query
• Previous by thread: Remote Control problems
• Next by thread: Printer discovery Query
• Index(es):
  • Date
  • Thread

---

Relevant Pages RE: Error while upgrading SMS 2003 SP1 to SP2 - SQL Database Error ... the sysobjects - table but no equivalent view-object! ... Now I am ready to install the software to a production system with nearly ... GRANT SELECT ON Report TO webreport_approle GRANT SELECT ON ... OPEN newviews FETCH NEXT FROM newviews INTO @viewname WHILE ... (microsoft.public.sms.admin) Error while upgrading SMS 2003 SP1 to SP2 - SQL Database Error ... Now I am ready to install the software to a production system with nearly ... GRANT SELECT ON Report TO webreport_approle GRANT SELECT ON ... TO webreport_approle GRANT SELECT ON Dashboard TO webreport_approle GRANT ... OPEN newviews FETCH NEXT FROM newviews INTO @viewname WHILE ... (microsoft.public.sms.admin) Re: Permission to Insert records for DB USERS ... To add to the response by Vyas, consider creating your own database ... EXEC sp_addrole 'Supervisors' ... GRANT SELECT ON MyTable TO Supervisors ... > I am a fresh developer for the SQL server and have no Idea> for the permissions on the database. ... (microsoft.public.sqlserver.security) Re: grant execution permission ... execute permission to the user/role: ... EXEC sp_addrolemember 'MyRole', 'MyDomain\MyUser' ... GRANT EXEC ON MyProcedure TO MyRole ... (microsoft.public.sqlserver.security) Re: Alice Cooper is a pinhead! ... head:P I'll grant you I planted Paradise by the Dashboard Lights...never ... (rec.games.pinball)

---

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint

www.tech-archive.net  > Archive  > SMS  > microsoft.public.sms.admin  > 2007-02