Reply to thread

Message: [QUOTE="benny, post: 4934381"] Gary, I'm guessing you mean the sql statement. There really is no command line. I open the sql statement in SQL Query Analyzer and run it on the database. The sql statement is very long, so I'm only going to put a little in this post and if you want more I can email it to you or post it to a website. ****************************************************************************************************/ /* Drop the MSP_PROJECTS_AI_TRG trigger if it exists when upgrading 10.5 - 11, since it only needs to exist in a 10.5 scenario */ IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.MSP_PROJECTS_AI_TRG') AND OBJECTPROPERTY(id, N'IsTrigger') = 1) DROP TRIGGER dbo.MSP_PROJECTS_AI_TRG GO /* Remove obsolete P10 stored procedures */ IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MSP_WEB_SP_ADM_GetAllCategories]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[MSP_WEB_SP_ADM_GetAllCategories] GO IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MSP_WEB_SP_ADM_GetCategoriesForResID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[MSP_WEB_SP_ADM_GetCategoriesForResID] GO IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MSP_WEB_SP_ADM_GetProjectsForCategoryID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[MSP_WEB_SP_ADM_GetProjectsForCategoryID] GO IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MSP_WEB_SP_ADM_GetUsersForCategoryID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[MSP_WEB_SP_ADM_GetUsersForCategoryID] GO IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MSP_WEB_SP_ADM_GetViewsForCategoryID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[MSP_WEB_SP_ADM_GetViewsForCategoryID] GO The [/QUOTE]

Verification