Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL DataProvider05.01.00 issue on upgrade from DNN 5.0.1 to 5.1.2SQL DataProvider05.01.00 issue on upgrade from DNN 5.0.1 to 5.1.2
Previous
 
Next
New Post
9/11/2009 8:20 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

Hi all,

I get this error on upgrating a DNN 05.00.01 to 05.01.02, how do I fix it?

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'SaveCoreAuditTypes' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.SaveCoreAuditTypes
 @LogTypeKey nvarchar(35), 
 @LogTypeFriendlyName nvarchar(50), 
 @LogTypeOwner nvarchar(100), 
 @LogTypeCSSClass nvarchar(40) ,
 @LoggingIsActive bit, 
 @KeepMostRecent int, 
 @EmailNotificationIsActive bit 

AS 
 IF NOT EXISTS (SELECT * FROM dbo.EventLogTypes WHERE LogTypeKey = @LogTypeKey) 
 BEGIN 
  -- Add new Event Type 
  EXEC dbo.AddEventLogType @LogTypeKey, @LogTypeFriendlyName, N'', @LogTypeOwner, @LogTypeCSSClass 

  -- Add new Event Type Config 
  EXEC dbo.AddEventLogConfig @LogTypeKey, NULL, @LoggingIsActive, @KeepMostRecent, @EmailNotificationIsActive, 1, 1, 1, N'', N'' 
   
  -- exit 
  Return
 END
  ELSE

  UPDATE dbo.EventLogTypes SET LogTypeFriendlyName = @LogTypeFriendlyName WHERE LogTypeKey = @LogTypeKey 

  UPDATE dbo.EventLogConfig
  SET LoggingIsActive=@LoggingIsActive,
  KeepMostRecent=@KeepMostRecent,
  EmailNotificationIsActive=@EmailNotificationIsActive
  WHERE LogTypeKey = @LogTypeKey 

 

System.Data.SqlClient.SqlException: Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Verletzung der PRIMARY KEY-Einschränkung 'PK_EventLogTypes'. Ein doppelter Schlüssel kann in das 'dbo.EventLogTypes'-Objekt nicht eingefügt werden.
Eine Zeile mit doppeltem Schlüssel kann in das 'dbo.EventLogConfig'-Objekt mit dem eindeutigen 'IX_LogTypeKey_LogTypePortalID'-Index nicht eingefügt werden.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
Die Anweisung wurde beendet.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

EXEC dbo.SaveCoreAuditTypes N'LISTENTRY_CREATED',N'List entry created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LISTENTRY_UPDATED',N'List entry updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LISTENTRY_DELETED',N'List entry deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULE_CREATED',N'Desktop module created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULE_UPDATED',N'Desktop module updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULE_DELETED',N'Desktop module deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINCONTROL_CREATED',N'Skin control created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINCONTROL_UPDATED',N'Skin control updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINCONTROL_DELETED',N'Skin control deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALALIAS_CREATED',N'Portal alias created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALALIAS_UPDATED',N'Portal alias updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALALIAS_DELETED',N'Portal alias deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PROFILEPROPERTY_CREATED',N'Profile property created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PROFILEPROPERTY_UPDATED',N'Profile property updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PROFILEPROPERTY_DELETED',N'Profile property deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'USER_UPDATED',N'User updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULEPERMISSION_CREATED',N'Desktop module permission created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULEPERMISSION_UPDATED',N'Desktop module permission updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'DESKTOPMODULEPERMISSION_DELETED',N'Desktop module permission deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PERMISSION_CREATED',N'Permission created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PERMISSION_UPDATED',N'Permission updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PERMISSION_DELETED',N'Permission deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABPERMISSION_CREATED',N'Tab permission created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABPERMISSION_UPDATED',N'Tab permission updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABPERMISSION_DELETED',N'Tab permission deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_CREATED',N'Authentication system created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_UPDATED',N'Authentication system updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_DELETED',N'Authentication system deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'FOLDER_CREATED',N'Folder created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'FOLDER_UPDATED',N'Folder updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'FOLDER_DELETED',N'Folder deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PACKAGE_CREATED',N'Package created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PACKAGE_UPDATED',N'Package updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PACKAGE_DELETED',N'Package deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGEPACK_CREATED',N'Language pack created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGEPACK_UPDATED',N'Language pack updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGEPACK_DELETED',N'Language pack deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGE_CREATED',N'Language created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGE_UPDATED',N'Language updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGE_DELETED',N'Language deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINPACKAGE_CREATED',N'Skin package created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINPACKAGE_UPDATED',N'Skin package updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SKINPACKAGE_DELETED',N'Skin package deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SCHEDULE_CREATED',N'Schedule created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SCHEDULE_UPDATED',N'Schedule updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'SCHEDULE_DELETED',N'Schedule deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'HOST_SETTING_CREATED',N'Host setting created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'HOST_SETTING_UPDATED',N'Host setting updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'HOST_SETTING_DELETED',N'Host setting deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALDESKTOPMODULE_CREATED',N'Portal desktop module created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALDESKTOPMODULE_UPDATED',N'Portal desktop module updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALDESKTOPMODULE_DELETED',N'Portal desktop module deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_CREATED',N'Tab module created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_UPDATED',N'Tab module updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_DELETED',N'Tab module deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_SETTING_CREATED',N'Tab module setting created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_SETTING_UPDATED',N'Tab module setting updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TABMODULE_SETTING_DELETED',N'Tab module setting deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'MODULE_SETTING_CREATED',N'Module setting created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'MODULE_SETTING_UPDATED',N'Module setting updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'MODULE_SETTING_DELETED',N'Module setting deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTAL_SETTING_CREATED',N'Portal setting created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTAL_SETTING_UPDATED',N'Portal setting updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTAL_SETTING_DELETED',N'Portal setting deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALINFO_CREATED',N'Portal info created',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALINFO_UPDATED',N'Portal info updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'PORTALINFO_DELETED',N'Portal info deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_USER_CREATED',N'User authentication added',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_USER_UPDATED',N'User authentication updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'AUTHENTICATION_USER_DELETED',N'User authentication deleted',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGETOPORTAL_CREATED',N'Language created on portal',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGETOPORTAL_UPDATED',N'Language updated on portal',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'LANGUAGETOPORTAL_DELETED',N'Language deleted on portal',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'TAB_ORDER_UPDATED',N'Tab order updated',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_REMOVED',N'Cache Item Removed',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_EXPIRED',N'Cache Item Expired',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_UNDERUSED',N'Cache Item Underused',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_DEPENDENCYCHANGED',N'Cache Item Dependency Changed',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_OVERFLOW',N'Cache Item Overflow',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0
EXEC dbo.SaveCoreAuditTypes N'CACHE_REFRESH',N'Cache Refresh',N'DotNetNuke.Logging.EventLogType',N'GeneralAdminOperation' ,0,-1,0


System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.AddEventLog' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* update AddEventLog Procedure */
/********************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddEventLog]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddEventLog


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddEventLog' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddEventLog 
 @LogGUID varchar(36),
 @LogTypeKey nvarchar(35),
 @LogUserID int,
 @LogUserName nvarchar(50),
 @LogPortalID int,
 @LogPortalName nvarchar(100),
 @LogCreateDate datetime,
 @LogServerName nvarchar(50),
 @LogProperties ntext,
 @LogConfigID int
AS
 IF NOT EXISTS (SELECT * FROM dbo.EventLogTypes WHERE LogTypeKey = @LogTypeKey)
  BEGIN
  -- Add new Event Type
   EXEC dbo.AddEventLogType @LogTypeKey, @LogTypeKey, N'', N'DotNetNuke.Logging.EventLogType', N'GeneralAdminOperation'

  -- Add new Event Type Config
   EXEC dbo.AddEventLogConfig @LogTypeKey, NULL, 0, -1, 0, 1, 1, 1, N'', N''
  -- As the new log config is unlogged, exit without logging
   Return
  END

 INSERT INTO dbo.EventLog
  (LogGUID,
  LogTypeKey,
  LogUserID,
  LogUserName,
  LogPortalID,
  LogPortalName,
  LogCreateDate,
  LogServerName,
  LogProperties,
  LogConfigID)
 VALUES
  (@LogGUID,
  @LogTypeKey,
  @LogUserID,
  @LogUserName,
  @LogPortalID,
  @LogPortalName,
  @LogCreateDate,
  @LogServerName,
  @LogProperties,
  @LogConfigID)

 DECLARE @NotificationActive bit
 DECLARE @NotificationThreshold bit
 DECLARE @ThresholdQueue int
 DECLARE @NotificationThresholdTime int
 DECLARE @NotificationThresholdTimeType int
 DECLARE @MinDateTime smalldatetime
 DECLARE @CurrentDateTime smalldatetime

 SET @CurrentDateTime = getDate()


 SELECT TOP 1 @NotificationActive = EmailNotificationIsActive,
  @NotificationThreshold = NotificationThreshold,
  @NotificationThresholdTime = NotificationThresholdTime,
  @NotificationThresholdTimeType = NotificationThresholdTimeType,
  @MinDateTime =
   CASE
     --seconds
    WHEN NotificationThresholdTimeType=1 THEN DateAdd(second, NotificationThresholdTime * -1, @CurrentDateTime)
    --minutes
    WHEN NotificationThresholdTimeType=2  THEN DateAdd(minute, NotificationThresholdTime * -1, @CurrentDateTime)
    --hours
    WHEN NotificationThresholdTimeType=3  THEN DateAdd(Hour, NotificationThresholdTime * -1, @CurrentDateTime)
    --days
    WHEN NotificationThresholdTimeType=4  THEN DateAdd(Day, NotificationThresholdTime * -1, @CurrentDateTime)
   END
 FROM dbo.EventLogConfig
 WHERE ID = @LogConfigID

 IF @NotificationActive=1
 BEGIN
  
  SELECT @ThresholdQueue = COUNT(*)
  FROM dbo.EventLog
   INNER JOIN dbo.EventLogConfig
    ON dbo.EventLog.LogConfigID = dbo.EventLogConfig.ID
  WHERE LogCreateDate > @MinDateTime

  PRINT 'MinDateTime=' + convert(varchar(20), @MinDateTime)
  PRINT 'ThresholdQueue=' + convert(varchar(20), @ThresholdQueue)
  PRINT 'NotificationThreshold=' + convert(varchar(20), @NotificationThreshold)

  IF @ThresholdQueue > @NotificationThreshold
  BEGIN
   UPDATE dbo.EventLog
   SET LogNotificationPending = 1
   WHERE LogConfigID = @LogConfigID
    AND LogNotificationPending IS NULL  
    AND LogCreateDate > @MinDateTime
  END
 END
   


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Portals'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


/* Add Columns to Portals Table */
/***********************************/

ALTER TABLE dbo.Portals ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.UserRoles'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to UserRoles Table */
/***********************************/

ALTER TABLE dbo.UserRoles ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'IsDeleted' wurde in der 'dbo.Users'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Users Table */
/******************************/

ALTER TABLE dbo.Users ADD
 IsDeleted bit NOT NULL CONSTRAINT [DF_Users_IsDeleted]  DEFAULT ((0)),
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.PortalAlias'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to PortalAlias Table */
/***********************************/

ALTER TABLE dbo.PortalAlias ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.ModulePermission'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to ModulePermission Table */
/***********************************/

ALTER TABLE dbo.ModulePermission ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.TabModules'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to TabModules Table */
/***********************************/

ALTER TABLE dbo.TabModules ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.TabModuleSettings'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to TabModuleSettings Table */
/***********************************/

ALTER TABLE dbo.TabModuleSettings ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'ViewOrder' wurde in der 'dbo.Permission'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Permission Table */
/***********************************/

ALTER TABLE dbo.Permission ADD
 ViewOrder int NOT NULL CONSTRAINT DF_Permission_ViewOrder DEFAULT 9999,
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.TabPermission'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to TabPermission Table */
/***********************************/

ALTER TABLE dbo.TabPermission ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Folders'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Folders Table */
/***********************************/

ALTER TABLE dbo.Folders ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.FolderPermission'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to FolderPermission Table */
/***********************************/

ALTER TABLE dbo.FolderPermission ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Files'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Files Table */
/***********************************/

ALTER TABLE dbo.Files ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Modules'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Modules Table */
/***********************************/

ALTER TABLE dbo.Modules ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.ModuleSettings'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to ModuleSettings Table */
/***********************************/

ALTER TABLE dbo.ModuleSettings ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.DesktopModules'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to DesktopModules Table */
/***********************************/

ALTER TABLE dbo.DesktopModules ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.ModuleDefinitions'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to ModuleDefinitions Table */
/***********************************/

ALTER TABLE dbo.ModuleDefinitions ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.ModuleControls'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to ModuleControls Table */
/***********************************/

ALTER TABLE dbo.ModuleControls ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.PortalDesktopModules'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to PortalDesktopModules Table */
/***********************************/

ALTER TABLE dbo.PortalDesktopModules ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 83) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update AddModulePermission Stored Procedure */
/***********************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddModulePermission]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddModulePermission


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddModulePermission' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddModulePermission
 @ModuleID    int,
 @PermissionID   int,
 @RoleID    int,
 @AllowAccess   bit,
 @UserID    int,
 @CreatedByUserID int
AS

INSERT INTO dbo.ModulePermission (
 [ModuleID],
 [PermissionID],
 [RoleID],
 [AllowAccess],
 [UserID],
 [CreatedByUserID],
 [CreatedOnDate],
 [LastModifiedByUserID],
 [LastModifiedOnDate]
) VALUES (
 @ModuleID,
 @PermissionID,
 @RoleID,
 @AllowAccess,
 @UserID,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate()
)

select SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddModule
 @PortalID   int,
 @ModuleDefId  int,
 @ModuleTitle  nvarchar(256),
 @AllTabs   bit,
 @Header    ntext,
 @Footer    ntext,
 @StartDate   datetime,
 @EndDate   datetime,
 @InheritViewPermissions        bit,
 @IsDeleted   bit,
 @CreatedByUserID   int
 
AS

INSERT INTO dbo.Modules (
 PortalId,
 ModuleDefId,
 ModuleTitle,
 AllTabs,
 Header,
 Footer,
 StartDate,
 EndDate,
 InheritViewPermissions,
 IsDeleted,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate
)
values (
 @PortalID,
 @ModuleDefId,
 @ModuleTitle,
 @AllTabs,
 @Header,
 @Footer,
 @StartDate,
 @EndDate,
 @InheritViewPermissions,
 @IsDeleted,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate()
)

select SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.UpdateModule' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update UpdateModule Stored Procedure */
/****************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdateModule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.UpdateModule


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateModule
 @ModuleId               int,
 @ModuleTitle            nvarchar(256),
 @AllTabs                bit,
 @Header                 ntext,
 @Footer                 ntext,
 @StartDate              datetime,
 @EndDate                datetime,
 @InheritViewPermissions bit,
 @IsDeleted              bit,
 @LastModifiedByUserID   int

AS

UPDATE dbo.Modules
SET  ModuleTitle = @ModuleTitle,
  AllTabs = @AllTabs,
  Header = @Header,
  Footer = @Footer,
  StartDate = @StartDate,
  EndDate = @EndDate,
  InheritViewPermissions = @InheritViewPermissions,
  IsDeleted = @IsDeleted,
  LastModifiedByUserID = @LastModifiedByUserID,
  LastModifiedOnDate = getdate()
WHERE  ModuleId = @ModuleId

 

System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 89) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update AddModuleSetting Stored Procedure */
/********************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddModuleSetting]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddModuleSetting


System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.UpdateModuleSetting' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update UpdateModuleSetting Stored Procedure */
/***********************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdateModuleSetting]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.UpdateModuleSetting


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateModuleSetting' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.UpdateModuleSetting
 @ModuleId    int,
 @SettingName   nvarchar(50),
 @SettingValue   nvarchar(2000),
 @LastModifiedByUserID   int
AS

UPDATE  dbo.ModuleSettings
SET  SettingValue = @SettingValue,
  LastModifiedByUserID = @LastModifiedByUserID,
  LastModifiedOnDate = getdate()
WHERE ModuleId = @ModuleId
AND SettingName = @SettingName

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddPermission' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddPermission
 @ModuleDefID  int,
 @PermissionCode  varchar(50),
 @PermissionKey  varchar(50),
 @PermissionName  varchar(50),
 @CreatedByUserID int
AS

INSERT INTO dbo.Permission (
 [ModuleDefID],
 [PermissionCode],
 [PermissionKey],
 [PermissionName],
 [CreatedByUserID],
 [CreatedOnDate],
 [LastModifiedByUserID],
 [LastModifiedOnDate]
) VALUES (
 @ModuleDefID,
 @PermissionCode,
 @PermissionKey,
 @PermissionName,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate()
)

select SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddPortalInfo' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddPortalInfo
 @PortalName         nvarchar(128),
 @Currency           char(3),
 @ExpiryDate         datetime,
 @HostFee            money,
 @HostSpace          int,
 @PageQuota          int,
 @UserQuota          int,
 @SiteLogHistory     int,
 @HomeDirectory  varchar(100),
 @CreatedByUserID int
AS

DECLARE @PortalID int

insert into dbo.Portals (
  PortalName,
  ExpiryDate,
  UserRegistration,
  BannerAdvertising,
  Currency,
  HostFee,
  HostSpace,
  PageQuota,
  UserQuota,
  Description,
  KeyWords,
  SiteLogHistory,
  HomeDirectory,
  CreatedByUserID,
  CreatedOnDate,
  LastModifiedByUserID,
  LastModifiedOnDate
)
values (
  @PortalName,
  @ExpiryDate,
  0,
  0,
  @Currency,
  @HostFee,
  @HostSpace,
  @PageQuota,
  @UserQuota,
  @PortalName,
  @PortalName,
  @SiteLogHistory,
  @HomeDirectory,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
)

SET @PortalID = SCOPE_IDENTITY()

IF @HomeDirectory = ''
BEGIN
 UPDATE dbo.Portals SET HomeDirectory = 'Portals/' + convert(varchar(10), @PortalID) WHERE PortalID = @PortalID
END

SELECT @PortalID

 

System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.UpdatePortalInfo' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


/* Update UpdatePortalInfo Stored Procedure */
/****************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdatePortalInfo]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.UpdatePortalInfo


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdatePortalInfo' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdatePortalInfo
 @PortalID           int,
 @PortalName         nvarchar(128),
 @LogoFile           nvarchar(50),
 @FooterText         nvarchar(100),
 @ExpiryDate         datetime,
 @UserRegistration   int,
 @BannerAdvertising  int,
 @Currency           char(3),
 @AdministratorId    int,
 @HostFee            money,
 @HostSpace          int,
 @PageQuota          int,
 @UserQuota          int,
 @PaymentProcessor   nvarchar(50),
 @ProcessorUserId    nvarchar(50),
 @ProcessorPassword  nvarchar(50),
 @Description        nvarchar(500),
 @KeyWords           nvarchar(500),
 @BackgroundFile     nvarchar(50),
 @SiteLogHistory     int,
 @SplashTabId          int,
 @HomeTabId          int,
 @LoginTabId         int,
 @UserTabId          int,
 @DefaultLanguage    nvarchar(10),
 @TimeZoneOffset     int,
 @HomeDirectory  varchar(100),
 @LastModifiedByUserID int
AS

update dbo.Portals
set    PortalName = @PortalName,
       LogoFile = @LogoFile,
       FooterText = @FooterText,
       ExpiryDate = @ExpiryDate,
       UserRegistration = @UserRegistration,
       BannerAdvertising = @BannerAdvertising,
       Currency = @Currency,
       AdministratorId = @AdministratorId,
       HostFee = @HostFee,
       HostSpace = @HostSpace,
       PageQuota = @PageQuota,
       UserQuota = @UserQuota,
       PaymentProcessor = @PaymentProcessor,
       ProcessorUserId = @ProcessorUserId,
       ProcessorPassword = @ProcessorPassword,
       Description = @Description,
       KeyWords = @KeyWords,
       BackgroundFile = @BackgroundFile,
       SiteLogHistory = @SiteLogHistory,
       SplashTabId = @SplashTabId,
       HomeTabId = @HomeTabId,
       LoginTabId = @LoginTabId,
       UserTabId = @UserTabId,
       DefaultLanguage = @DefaultLanguage,
       TimeZoneOffset = @TimeZoneOffset,
       HomeDirectory = @HomeDirectory,
    LastModifiedByUserID = @LastModifiedByUserID,
    LastModifiedOnDate = getdate()
where  PortalId = @PortalID

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateTabModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateTabModule
 @TabId               int,
 @ModuleId            int,
 @ModuleOrder         int,
 @PaneName            nvarchar(50),
 @CacheTime           int,
 @Alignment           nvarchar(10),
 @Color               nvarchar(20),
 @Border              nvarchar(1),
 @IconFile            nvarchar(100),
 @Visibility          int,
 @ContainerSrc        nvarchar(200),
 @DisplayTitle        bit,
 @DisplayPrint        bit,
 @DisplaySyndicate    bit,
 @IsWebSlice    bit,
 @WebSliceTitle   nvarchar(256),
 @WebSliceExpiryDate  datetime,
 @WebSliceTTL   int,
 @LastModifiedByUserID int

AS
 UPDATE dbo.TabModules
  SET   
   ModuleOrder = @ModuleOrder,
   PaneName = @PaneName,
   CacheTime = @CacheTime,
   Alignment = @Alignment,
   Color = @Color,
   Border = @Border,
   IconFile = @IconFile,
   Visibility = @Visibility,
   ContainerSrc = @ContainerSrc,
   DisplayTitle = @DisplayTitle,
   DisplayPrint = @DisplayPrint,
   DisplaySyndicate = @DisplaySyndicate,
   IsWebSlice = @IsWebSlice,
   WebSliceTitle = @WebSliceTitle,
   WebSliceExpiryDate = @WebSliceExpiryDate,
   WebSliceTTL = @WebSliceTTL,
   LastModifiedByUserID = @LastModifiedByUserID,
   LastModifiedOnDate = getdate()
  WHERE  TabId = @TabId
  AND    ModuleId = @ModuleId

 

System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.AddTabModuleSetting' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

 /* Update AddTabModuleSetting Stored Procedure */
/************************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddTabModuleSetting]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddTabModuleSetting


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddTabModuleSetting' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddTabModuleSetting
 @TabModuleId     int,
 @SettingName     NVARCHAR(50),
 @SettingValue    NVARCHAR(2000),
 @CreatedByUserID   int
 
AS

INSERT INTO dbo.TabModuleSettings (
 TabModuleId,
 SettingName,
 SettingValue,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate
)
VALUES (
 @TabModuleId,
 @SettingName,
 @SettingValue,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate()
)

 

System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.AddTabPermission' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

 /* Update AddTabPermission Stored Procedure */
/*********************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddTabPermission]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddTabPermission


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddTabPermission' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddTabPermission
 @TabID int,
 @PermissionID int,
 @RoleID int,
 @AllowAccess bit,
    @UserID int,
 @CreatedByUserID  int
AS

 INSERT INTO dbo.TabPermission (
  [TabID],
  [PermissionID],
  [RoleID],
  [AllowAccess],
  [UserID],
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]
 ) VALUES (
  @TabID,
  @PermissionID,
  @RoleID,
  @AllowAccess,
  @UserID,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
 )

 select SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateTabPermission' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateTabPermission
 @TabPermissionID int,
 @TabID int,
 @PermissionID int,
 @RoleID int ,
 @AllowAccess bit,
    @UserID int,
 @LastModifiedByUserID  int
AS

UPDATE dbo.TabPermission
SET    
 [TabID] = @TabID,
 [PermissionID] = @PermissionID,
 [RoleID] = @RoleID,
 [AllowAccess] = @AllowAccess,
    [UserID] = @UserID,
 [LastModifiedByUserID] = @LastModifiedByUserID,
 [LastModifiedOnDate] = getdate()
WHERE   [TabPermissionID] = @TabPermissionID

 


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddUserRole' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddUserRole
 @PortalID  int,
 @UserID   int,
 @RoleId   int,
 @EffectiveDate datetime = null,
 @ExpiryDate  datetime = null,
 @CreatedByUserID  int
AS

DECLARE @UserRoleId int

SELECT @UserRoleId = null

SELECT @UserRoleId = UserRoleId
 FROM dbo.UserRoles
 WHERE  UserId = @UserID AND RoleId = @RoleId
 
IF @UserRoleId IS NOT NULL
 BEGIN
  UPDATE dbo.UserRoles
   SET ExpiryDate = @ExpiryDate,
    EffectiveDate = @EffectiveDate,
    IsTrialUsed = 1,
    LastModifiedByUserID = @CreatedByUserID,
    LastModifiedOnDate = getdate()
   WHERE  UserRoleId = @UserRoleId
  SELECT @UserRoleId
 END
ELSE
 BEGIN
  INSERT INTO dbo.UserRoles (
   UserId,
   RoleId,
   EffectiveDate,
   ExpiryDate,
   IsTrialUsed,
   CreatedByUserID,
   CreatedOnDate,
   LastModifiedByUserID,
   LastModifiedOnDate
    )
  VALUES (
   @UserID,
   @RoleId,
   @EffectiveDate,
   @ExpiryDate,
   1,
   @CreatedByUserID,
   getdate(),
   @CreatedByUserID,
   getdate()
    )

 SELECT SCOPE_IDENTITY()
    END


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateUserRole' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateUserRole
    @UserRoleId int,
 @EffectiveDate datetime = null,
 @ExpiryDate  datetime = null,
 @LastModifiedByUserID   int
AS

UPDATE dbo.UserRoles
 SET ExpiryDate = @ExpiryDate,
  EffectiveDate = @EffectiveDate,
  IsTrialUsed = 1,
  LastModifiedByUserID = @LastModifiedByUserID,
  LastModifiedOnDate = getdate()
 WHERE  UserRoleId = @UserRoleId
 


System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 106) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update AddUser Stored Procedure */
/*************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddUser]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddUser


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddUser' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddUser

 @PortalID  int,
 @Username  nvarchar(100),
 @FirstName  nvarchar(50),
 @LastName  nvarchar(50),
 @AffiliateId    int,
 @IsSuperUser    bit,
 @Email          nvarchar(256),
 @DisplayName    nvarchar(100),
 @UpdatePassword bit,
 @Authorised  bit,
 @CreatedByUserID int
AS

DECLARE @UserID int

SELECT @UserID = UserID
 FROM dbo.Users
 WHERE  Username = @Username

IF @UserID is null
 BEGIN
  INSERT INTO dbo.Users (
   Username,
   FirstName,
   LastName,
   AffiliateId,
   IsSuperUser,
   Email,
   DisplayName,
   UpdatePassword,
   CreatedByUserID,
   CreatedOnDate,
   LastModifiedByUserID,
   LastModifiedOnDate
    )
  VALUES (
   @Username,
   @FirstName,
   @LastName,
   @AffiliateId,
   @IsSuperUser,
   @Email,
   @DisplayName,
   @UpdatePassword,
   @CreatedByUserID,
   getdate(),
   @CreatedByUserID,
   getdate()
  )

  SELECT @UserID = SCOPE_IDENTITY()
 END

IF @IsSuperUser = 0
 BEGIN
  IF not exists ( SELECT 1 FROM dbo.UserPortals WHERE UserID = @UserID AND PortalID = @PortalID )
   BEGIN
    INSERT INTO dbo.UserPortals (
     UserID,
     PortalID,
     Authorised,
     CreatedDate
    )
    VALUES (
     @UserID,
     @PortalID,
     @Authorised,
     getdate()
    )
   END
 END

SELECT @UserID


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddDesktopModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddDesktopModule
 @PackageID   int,
 @ModuleName   nvarchar(128),
 @FolderName   nvarchar(128),
 @FriendlyName  nvarchar(128),
 @Description  nvarchar(2000),
 @Version   nvarchar(8),
 @IsPremium   bit,
 @IsAdmin   bit,
 @BusinessController nvarchar(200),
 @SupportedFeatures int,
 @CompatibleVersions nvarchar(500),
    @Dependencies       nvarchar(400),
    @Permissions  nvarchar(400),
 @CreatedByUserID int

AS
 INSERT INTO dbo.DesktopModules (
  PackageID,
  ModuleName,
  FolderName,
  FriendlyName,
  Description,
  Version,
  IsPremium,
  IsAdmin,
  BusinessControllerClass,
  SupportedFeatures,
  CompatibleVersions,
  Dependencies,
  Permissions,
  CreatedByUserID,
  CreatedOnDate,
  LastModifiedByUserID,
  LastModifiedOnDate
 )
 VALUES (
  @PackageID,
  @ModuleName,
  @FolderName,
  @FriendlyName,
  @Description,
  @Version,
  @IsPremium,
  @IsAdmin,
  @BusinessController,
  @SupportedFeatures,
  @CompatibleVersions,
  @Dependencies,
  @Permissions,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
 )

 SELECT SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddModuleControl' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddModuleControl
 
 @ModuleDefID                int,
 @ControlKey                 nvarchar(50),
 @ControlTitle               nvarchar(50),
 @ControlSrc                 nvarchar(256),
 @IconFile                   nvarchar(100),
 @ControlType                int,
 @ViewOrder                  int,
 @HelpUrl                    nvarchar(200),
 @SupportsPartialRendering   bit,
 @CreatedByUserID   int

AS
 INSERT INTO dbo.ModuleControls (
  ModuleDefID,
  ControlKey,
  ControlTitle,
  ControlSrc,
  IconFile,
  ControlType,
  ViewOrder,
  HelpUrl,
  SupportsPartialRendering,
  CreatedByUserID,
  CreatedOnDate,
  LastModifiedByUserID,
  LastModifiedOnDate
 )
 VALUES (
  @ModuleDefID,
  @ControlKey,
  @ControlTitle,
  @ControlSrc,
  @IconFile,
  @ControlType,
  @ViewOrder,
  @HelpUrl,
  @SupportsPartialRendering,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
 )

 SELECT SCOPE_IDENTITY()

 


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddModuleDefinition' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddModuleDefinition

 @DesktopModuleId int,   
 @FriendlyName    nvarchar(128),
 @DefaultCacheTime int,
 @CreatedByUserID  int

as

insert into dbo.ModuleDefinitions (
 DesktopModuleId,
 FriendlyName,
 DefaultCacheTime,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate
)
values (
 @DesktopModuleId,
 @FriendlyName,
 @DefaultCacheTime,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate()
)

select SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 92) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* updated various views to include audit fields */
/*************************************************/


/* Update Users View */
/*********************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[vw_Users]') AND OBJECTPROPERTY(id, N'IsVIEW') = 1)
  DROP VIEW dbo.vw_Users


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'vw_Users' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE VIEW dbo.vw_Users 

AS
 SELECT    
  U.UserID,
  UP.PortalId,
  U.Username,
  U.FirstName,
  U.LastName,
  U.DisplayName,
  U.IsSuperUser,
  U.Email,
  U.AffiliateId,
  U.UpdatePassword,
  UP.Authorised,
        (CASE WHEN UP.PortalId IS NULL THEN U.IsDeleted ELSE UP.IsDeleted END) AS IsDeleted,
        UP.RefreshRoles,
        U.LastIPAddress,
  U.CreatedByUserID,
  U.CreatedOnDate,
  U.LastModifiedByUserID,
  U.LastModifiedOnDate
 FROM dbo.Users AS U
  LEFT OUTER JOIN dbo.UserPortals AS UP ON U.UserID = UP.UserId 


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddTab' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddTab
 @PortalId           int,
 @TabName            nvarchar(50),
 @IsVisible          bit,
 @DisableLink        bit,
 @ParentId           int,
 @IconFile           nvarchar(100),
 @IconFileLarge      nvarchar(100),
 @Title              nvarchar(200),
 @Description        nvarchar(500),
 @KeyWords           nvarchar(500),
 @Url                nvarchar(255),
 @SkinSrc            nvarchar(200),
 @ContainerSrc       nvarchar(200),
 @TabPath            nvarchar(255),
 @StartDate          datetime,
 @EndDate            datetime,
 @RefreshInterval    int,
 @PageHeadText     nvarchar(500),
 @IsSecure           bit,
 @PermanentRedirect bit,
 @SiteMapPriority float,
 @CreatedByUserID int

AS

 INSERT INTO dbo.Tabs (
  PortalId,
  TabName,
  IsVisible,
  DisableLink,
  ParentId,
  IconFile,
  IconFileLarge,
  Title,
  Description,
  KeyWords,
  IsDeleted,
  Url,
  SkinSrc,
  ContainerSrc,
  TabPath,
  StartDate,
  EndDate,
  RefreshInterval,
  PageHeadText,
  IsSecure,
  PermanentRedirect,
  SiteMapPriority,
  CreatedByUserID,
  CreatedOnDate,
  LastModifiedByUserID,
  LastModifiedOnDate
 )
 VALUES (
  @PortalId,
  @TabName,
  @IsVisible,
  @DisableLink,
  @ParentId,
  @IconFile,
  @IconFileLarge,
  @Title,
  @Description,
  @KeyWords,
  0,
  @Url,
  @SkinSrc,
  @ContainerSrc,
  @TabPath,
  @StartDate,
  @EndDate,
  @RefreshInterval,
  @PageHeadText,
  @IsSecure,
  @PermanentRedirect,
  @SiteMapPriority,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
 )

 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Roles'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Roles Table */
/***********************************/

ALTER TABLE dbo.Roles ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddRole' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddRole
 @PortalID         int,
 @RoleGroupId      int,
 @RoleName         nvarchar(50),
 @Description      nvarchar(1000),
 @ServiceFee       money,
 @BillingPeriod    int,
 @BillingFrequency char(1),
 @TrialFee         money,
 @TrialPeriod      int,
 @TrialFrequency   char(1),
 @IsPublic         bit,
 @AutoAssignment   bit,
 @RSVPCode         nvarchar(50),
 @IconFile         nvarchar(100),
 @CreatedByUserID  int
AS

 INSERT INTO dbo.Roles (
   PortalId,
   RoleGroupId,
   RoleName,
   Description,
   ServiceFee,
   BillingPeriod,
   BillingFrequency,
   TrialFee,
   TrialPeriod,
   TrialFrequency,
   IsPublic,
   AutoAssignment,
   RSVPCode,
   IconFile,
   CreatedByUserID,
   CreatedOnDate,
   LastModifiedByUserID,
   LastModifiedOnDate
 )

 VALUES (
   @PortalID,
   @RoleGroupId,
   @RoleName,
   @Description,
   @ServiceFee,
   @BillingPeriod,
   @BillingFrequency,
   @TrialFee,
   @TrialPeriod,
   @TrialFrequency,
   @IsPublic,
   @AutoAssignment,
   @RSVPCode,
   @IconFile,
   @CreatedByUserID,
   getdate(),
   @CreatedByUserID,
   getdate()
 )

 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateUser' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateUser
 @UserID         int,
 @PortalID  int,
 @FirstName  nvarchar(50),
 @LastName  nvarchar(50),
 @Email          nvarchar(256),
 @DisplayName    nvarchar(100),
 @UpdatePassword bit,
 @Authorised  bit,
 @RefreshRoles bit,
 @LastIPAddress nvarchar(50),
 @IsDeleted  bit,
 @LastModifiedByUserID int
AS
 UPDATE dbo.Users
  SET
   FirstName = @FirstName,
   LastName = @LastName,
   Email = @Email,
   DisplayName = @DisplayName,
   UpdatePassword = @UpdatePassword,
   LastIPAddress = @LastIPAddress,
   LastModifiedByUserID = @LastModifiedByUserID,
   LastModifiedOnDate = getdate()
  WHERE  UserId = @UserID
 
 IF @PortalID IS NULL
  BEGIN
   UPDATE dbo.Users
    SET
     IsDeleted = @IsDeleted
    WHERE  UserId = @UserID
  END
 ELSE
  BEGIN
   UPDATE dbo.UserPortals
    SET
     Authorised = @Authorised,
     RefreshRoles = @RefreshRoles,
     IsDeleted = @IsDeleted
    WHERE  UserId = @UserID
     AND PortalId = @PortalID
  END


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'FK_DesktopModules_Packages' vorhanden.
Die Einschränkung konnte nicht erstellt werden. Siehe vorherige Fehler.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Foreign Key to PAckages/DesktopModules */
/**********************************************/

ALTER TABLE dbo.DesktopModules WITH NOCHECK
 ADD CONSTRAINT FK_DesktopModules_Packages FOREIGN KEY ( PackageID ) REFERENCES dbo.Packages ( PackageID ) ON UPDATE  CASCADE  ON DELETE  CASCADE


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'FK_Packages_PackageTypes' vorhanden.
Die Einschränkung konnte nicht erstellt werden. Siehe vorherige Fehler.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Foreign Key to Packages/PackageTypes */
/**********************************************/

ALTER TABLE dbo.Packages
 ADD CONSTRAINT FK_Packages_PackageTypes FOREIGN KEY ( PackageType ) REFERENCES dbo.PackageTypes ( PackageType ) ON UPDATE  CASCADE ON DELETE  CASCADE


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'vw_Modules' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE VIEW dbo.vw_Modules
AS
 SELECT    
  M.PortalID,
  TM.TabID,
  TM.TabModuleID,
  M.ModuleID,
  M.ModuleDefID,
  TM.ModuleOrder,
  TM.PaneName,
  M.ModuleTitle,
  TM.CacheTime,
  TM.Alignment,
  TM.Color,
  TM.Border,
  CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM dbo.Files WHERE 'fileid=' + CONVERT(varchar, dbo.Files.FileID) = TM.IconFile) ELSE TM.IconFile END AS IconFile,
  M.AllTabs,
  TM.Visibility,
  TM.IsDeleted,
  M.Header,
  M.Footer,
  M.StartDate,
  M.EndDate,
  TM.ContainerSrc,
  TM.DisplayTitle,
  TM.DisplayPrint,
  TM.DisplaySyndicate,
  TM.IsWebSlice,
  TM.WebSliceTitle,
  TM.WebSliceExpiryDate,
  TM.WebSliceTTL,
  M.InheritViewPermissions,
  MD.DesktopModuleID,
  MD.DefaultCacheTime,
  MC.ModuleControlID,
  DM.BusinessControllerClass,
  DM.IsAdmin,
  DM.SupportedFeatures,
  MD.CreatedByUserID, MD.CreatedOnDate, MD.LastModifiedByUserID, MD.LastModifiedOnDate
 FROM dbo.ModuleDefinitions AS MD
  INNER JOIN dbo.Modules AS M ON MD.ModuleDefID = M.ModuleDefID
  INNER JOIN dbo.ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID
  INNER JOIN dbo.DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID
  LEFT OUTER JOIN dbo.TabModules AS TM ON M.ModuleID = TM.ModuleID
 WHERE (MC.ControlKey IS NULL)


System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 65) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update DeleteTabModule Stored Procedure */
/*******************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[DeleteTabModule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.DeleteTabModule


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'DeleteTabModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.DeleteTabModule
 @TabId      int,
 @ModuleId   int,
 @SoftDelete bit
AS
 IF @SoftDelete = 1
  UPDATE dbo.TabModules
   SET IsDeleted = 1
  WHERE  TabId = @TabId
   AND    ModuleId = @ModuleId
 ELSE
  DELETE
  FROM   dbo.TabModules
  WHERE  TabId = @TabId
   AND    ModuleId = @ModuleId


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'IISAppName' wurde in der 'dbo.WebServers'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update WebServers Table */
/***************************/

ALTER TABLE dbo.WebServers ADD
 IISAppName nvarchar(200) NOT NULL CONSTRAINT DF_WebServers_IISAppName DEFAULT '',
 Enabled bit NOT NULL CONSTRAINT DF_WebServers_Enabled DEFAULT 1


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetServers' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.GetServers
AS
 SELECT *
 FROM dbo.WebServers
 ORDER BY ServerName, IISAppName


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateServerActivity' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.UpdateServerActivity
    @ServerName   nvarchar(50),
    @IISAppName   nvarchar(200),
    @CreatedDate  datetime,
    @LastActivityDate datetime
AS

 DECLARE @ServerID int
 SET @ServerID = (SELECT ServerID FROM dbo.WebServers WHERE ServerName = @ServerName AND IISAppName = @IISAppName)

 IF @ServerID IS NULL
  BEGIN
   -- Insert
   INSERT INTO dbo.WebServers (
    ServerName,
    IISAppName,
    CreatedDate,
    LastActivityDate
   )
   VALUES (
    @ServerName,
    @IISAppName,
    @CreatedDate,
    @LastActivityDate
   )
  END
 ELSE
  BEGIN
   -- Update
   UPDATE dbo.WebServers
    SET
     LastActivityDate = @LastActivityDate
    WHERE  ServerName = @ServerName AND IISAppName = @IISAppName
  END


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetTabsByModuleID' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetTabsByModuleID]
 @ModuleID int
AS
BEGIN

SELECT * FROM dbo.vw_Tabs VT
 INNER JOIN dbo.TabModules TM
  ON VT.TabID=TM.TabID
WHERE TM.ModuleID = @ModuleID
 AND TM.IsDeleted = 0
 AND VT.IsDeleted = 0
ORDER BY VT.Level, VT.ParentID, VT.TabOrder

END


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.DesktopModulePermission'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to DesktopModulesPermissions view */
/***********************************/

ALTER TABLE dbo.DesktopModulePermission ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'vw_DesktopModulePermissions' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE VIEW dbo.[vw_DesktopModulePermissions]
AS
    SELECT    
     PP.DesktopModulePermissionID,
     PP.PortalDesktopModuleID,
     P.PermissionID,
     PP.RoleID,
     CASE PP.RoleID
      when -1 then 'All Users'
      when -2 then 'Superuser'
      when -3 then 'Unauthenticated Users'
      else  R.RoleName
     END AS 'RoleName',
     PP.AllowAccess,
     PP.UserID,
     U.Username,
     U.DisplayName,
     P.PermissionCode,
     P.ModuleDefID,
     P.PermissionKey,
     P.PermissionName,
 PP.CreatedByUserID,
 PP.CreatedOnDate,
 PP.LastModifiedByUserID,
 PP.LastModifiedOnDate
    FROM dbo.DesktopModulePermission AS PP
     LEFT OUTER JOIN dbo.Permission AS P ON PP.PermissionID = P.PermissionID
     LEFT OUTER JOIN dbo.Roles AS R ON PP.RoleID = R.RoleID
     LEFT OUTER JOIN dbo.Users AS U ON PP.UserID = U.UserID


System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.GetHostSettings' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update GetHostSettings */
/**************************/

IF EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[GetHostSettings]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE dbo.[GetHostSettings]


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetHostSettings' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.GetHostSettings
AS
 IF NOT EXISTS ( select 1 from dbo.HostSettings where SettingName = 'GUID' )
   INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure ) values ( 'GUID', newid(), 0 )

 SELECT SettingName,
     SettingValue,
     SettingIsSecure
     CreatedByUserID,
     CreatedOnDate,
        LastModifiedByUserID,
     LastModifiedOnDate
 FROM   dbo.HostSettings


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddHostSetting' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.AddHostSetting

 @SettingName  nvarchar(50),
 @SettingValue  nvarchar(256),
 @SettingIsSecure bit,
 @CreatedByUserID int
AS
 insert into HostSettings (
   SettingName,
   SettingValue,
   SettingIsSecure,
   [CreatedByUserID],
   [CreatedOnDate],
   [LastModifiedByUserID],
   [LastModifiedOnDate]
 )
 values (
   @SettingName,
   @SettingValue,
   @SettingIsSecure,
   @CreatedByUserID,
   getdate(),
   @CreatedByUserID,
   getdate()
 )


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddPackage' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddPackage]
 @PortalID   int,
 @Name       nvarchar(128),
 @FriendlyName     nvarchar(250),
 @Description     nvarchar(2000),
 @PackageType     nvarchar(50),
 @Version      nvarchar(50),
 @License      ntext,
 @Manifest      ntext,
 @Owner    nvarchar(100),
 @Organization  nvarchar(100),
 @Url    nvarchar(250),
 @Email    nvarchar(100),
 @ReleaseNotes     ntext,
 @IsSystemPackage    bit,
 @CreatedByUserID int
AS
 INSERT INTO dbo.Packages
 (
  PortalID,
  [Name],
  FriendlyName,
  [Description],
  PackageType,
  Version,
  License,
  Manifest,
  ReleaseNotes,
  [Owner],
  Organization,
  Url,
  Email,
  IsSystemPackage,
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]
 )
 VALUES (
  @PortalID,
  @Name,
  @FriendlyName,
  @Description,
  @PackageType,
  @Version,
  @License,
  @Manifest,
  @ReleaseNotes,
  @Owner,
  @Organization,
  @Url,
  @Email,
  @IsSystemPackage,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
 )
 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.PortalSettings'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to PortalSettings table */
/***********************************/

ALTER TABLE dbo.PortalSettings ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 94) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* update GetPortalSettings */
/*************************/

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[GetPortalSettings]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE dbo.[GetPortalSettings]


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdatePortalSetting' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[UpdatePortalSetting]
 @PortalID      int,
 @SettingName   nvarchar(50),
 @SettingValue  nvarchar(2000),
 @UserID  int

AS
 IF (SELECT COUNT(*) FROM dbo.PortalSettings WHERE PortalID = @PortalID AND SettingName = @SettingName) > 0
  --Update
  UPDATE  dbo.PortalSettings
   SET SettingValue = @SettingValue,
  [LastModifiedByUserID]=@UserID,
  [LastModifiedOnDate]=getdate()
  WHERE PortalID = @PortalID
   AND SettingName = @SettingName
 ELSE
  --Add
  INSERT INTO dbo.PortalSettings ( PortalID, SettingName, SettingValue, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate )
   VALUES ( @PortalID, @SettingName, @SettingValue ,@UserID ,getdate() ,@UserID ,getdate())


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Authentication'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Authentication table */
/***********************************/

ALTER TABLE dbo.Authentication ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddSkinPackage' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddSkinPackage]
 @PackageID  int,
 @PortalID   int,
 @SkinName   nvarchar(50),
 @SkinType   nvarchar(20),
 @CreatedByUserID int
AS
 INSERT INTO dbo.SkinPackages (
   PackageID,
   PortalID,
   SkinName,
   SkinType,
 [CreatedByUserID],
 [CreatedOnDate],
 [LastModifiedByUserID],
 [LastModifiedOnDate]
 )
 VALUES (
   @PackageID,
   @PortalID,
   @SkinName,
   @SkinType,
   @CreatedByUserID,
   getdate(),
   @CreatedByUserID,
   getdate()
 )
 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateSkinPackage' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[UpdateSkinPackage]
 @SkinPackageID  int,
 @PackageID      int,
 @PortalID       int,
 @SkinName       nvarchar(50),
 @SkinType       nvarchar(20),
 @LastModifiedByUserID int
AS
 UPDATE dbo.SkinPackages
  SET
   PackageID = @PackageID,
   PortalID = @PortalID,
   SkinName = @SkinName,
   SkinType = @SkinType,
    [LastModifiedByUserID] = @LastModifiedByUserID, 
   [LastModifiedOnDate] = getdate()
 WHERE SkinPackageID = @SkinPackageID


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Lists'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

 

/* Add Columns to Lists table */
/***********************************/

ALTER TABLE dbo.Lists ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'vw_Lists' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE VIEW dbo.[vw_Lists]
AS
 SELECT    
  EntryID,
  ListName,
  Value,
  Text,
  [Level],
  SortOrder,
  DefinitionID,
  ParentID,
  Description,
  PortalID,
  SystemList,
  dbo.GetListParentKey(ParentID, ListName, N'ParentKey', 0) AS ParentKey,
  dbo.GetListParentKey(ParentID, ListName, N'Parent', 0) AS Parent,
  dbo.GetListParentKey(ParentID, ListName, N'ParentList', 0) AS ParentList,
  (SELECT MAX(SortOrder) FROM dbo.[Lists] WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS MaxSortOrder,
  (SELECT COUNT(EntryID) FROM dbo.[Lists] AS Lists_1 WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS EntryCount,
  (SELECT COUNT(DISTINCT ParentID) FROM dbo.[Lists] AS Lists_2 WHERE (ParentID = L.EntryID)) AS HasChildren,
  L.CreatedByUserID,
  L.CreatedOnDate,
  L.LastModifiedByUserID,
  L.LastModifiedOnDate
 FROM  dbo.[Lists] AS L

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddListEntry' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddListEntry]

 @ListName nvarchar(50),
 @Value nvarchar(100),
 @Text nvarchar(150),
 @ParentID int,
 @Level int,
 @EnableSortOrder bit,
 @DefinitionID int,
 @Description nvarchar(500),
 @PortalID int,
 @CreatedByUserID int

AS
 DECLARE @SortOrder int

 IF @EnableSortOrder = 1
  SET @SortOrder = IsNull((SELECT MAX ([SortOrder]) From dbo.Lists Where [ListName] = @ListName), 0) + 1
 ELSE
  SET @SortOrder = 0

 -- Check if this entry exists
 If EXISTS (SELECT [EntryID] From dbo.Lists WHERE [ListName] = @ListName And [Value] = @Value And [Text] = @Text And [ParentID] = @ParentID)
 BEGIN
  SELECT -1
  RETURN
 END

 INSERT INTO dbo.Lists
  (
    [ListName],
  [Value],
  [Text],
  [Level],
  [SortOrder],
  [DefinitionID],
  [ParentID],
  [Description],
  [PortalID],
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]
  )
 VALUES (
  @ListName,
  @Value,
  @Text,
  @Level,
  @SortOrder,
  @DefinitionID,
  @ParentID,
  @Description,
  @PortalID,
    @CreatedByUserID,
    getdate(),
    @CreatedByUserID,
    getdate() 
  )

 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateListEntry' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE procedure dbo.[UpdateListEntry]
 
 @EntryID int,
 @Value nvarchar(100),
 @Text nvarchar(150),
 @Description nvarchar(500),
 @LastModifiedByUserID int

AS
 UPDATE dbo.Lists
  SET 
   [Value] = @Value,
   [Text] = @Text, 
   [Description] = @Description,
   [LastModifiedByUserID] = @LastModifiedByUserID, 
   [LastModifiedOnDate] = getdate()
  WHERE  [EntryID] = @EntryID


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.Languages'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Columns to Languages table */
/***********************************/

ALTER TABLE dbo.Languages ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddLanguage' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddLanguage]

 @CultureCode      nvarchar(50),
 @CultureName            nvarchar(200),
 @FallbackCulture        nvarchar(50),
 @CreatedByUserID int

AS
 INSERT INTO dbo.Languages (
  CultureCode,
  CultureName,
  FallbackCulture,
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]
 )
 VALUES (
  @CultureCode,
  @CultureName,
  @FallbackCulture,
  @CreatedByUserID,
    getdate(),
    @CreatedByUserID,
    getdate()
 )
 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddLanguagePack' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddLanguagePack]

 @PackageID       int,
 @LanguageID       int,
 @DependentPackageID  int,
 @CreatedByUserID int

AS
 INSERT INTO dbo.LanguagePacks (
  PackageID,
  LanguageID,
  DependentPackageID,
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]

 )
 VALUES (
  @PackageID,
  @LanguageID,
  @DependentPackageID,
  @CreatedByUserID,
    getdate(),
    @CreatedByUserID,
    getdate()
 )
 SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'UpdateLanguagePack' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[UpdateLanguagePack]

 @LanguagePackID   int,
 @PackageID       int,
 @LanguageID       int,
 @DependentPackageID  int,
 @LastModifiedByUserID int

AS
 UPDATE dbo.LanguagePacks
  SET
   PackageID = @PackageID,
   LanguageID = @LanguageID,
   DependentPackageID = @DependentPackageID,
   [LastModifiedByUserID] = @LastModifiedByUserID, 
   [LastModifiedOnDate] = getdate()
 WHERE LanguagePackID = @LanguagePackID


System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'CreatedByUserID' wurde in der 'dbo.PortalLanguages'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


/* Add Columns to PortalLanguages table */
/***********************************/

ALTER TABLE dbo.PortalLanguages ADD
 CreatedByUserID int NULL,
 CreatedOnDate datetime NULL,
 LastModifiedByUserID int NULL,
 LastModifiedOnDate datetime NULL


System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.AddSchedule' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update AddSchedule Procedure */
/******************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddSchedule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.AddSchedule


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddSchedule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.AddSchedule

@TypeFullName varchar(200)
,@TimeLapse int
,@TimeLapseMeasurement varchar(2)
,@RetryTimeLapse int
,@RetryTimeLapseMeasurement varchar(2)
,@RetainHistoryNum int
,@AttachToEvent varchar(50)
,@CatchUpEnabled bit
,@Enabled bit
,@ObjectDependencies varchar(300)
,@Servers varchar(150),
@CreatedByUserID int
AS
INSERT INTO dbo.Schedule
(TypeFullName
,TimeLapse
,TimeLapseMeasurement
,RetryTimeLapse
,RetryTimeLapseMeasurement
,RetainHistoryNum
,AttachToEvent
,CatchUpEnabled
,Enabled
,ObjectDependencies
,Servers,
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate]
)
VALUES
(@TypeFullName
,@TimeLapse
,@TimeLapseMeasurement
,@RetryTimeLapse
,@RetryTimeLapseMeasurement
,@RetainHistoryNum
,@AttachToEvent
,@CatchUpEnabled
,@Enabled
,@ObjectDependencies
,@Servers,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
)


select SCOPE_IDENTITY()

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermission' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermission
 @PermissionID int
AS
 SELECT *
 FROM
  dbo.Permission
 WHERE
  [PermissionID] = @PermissionID

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermissionByCodeAndKey' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermissionByCodeAndKey
 @PermissionCode varchar(50),
 @PermissionKey varchar(50)
AS
 SELECT *
  FROM dbo.Permission
  WHERE
   (PermissionCode = @PermissionCode or @PermissionCode IS NULL)
   AND
   (PermissionKey = @PermissionKey or @PermissionKey IS NULL)

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermissionsByFolder' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermissionsByFolder
AS
 SELECT  *
  FROM    dbo.Permission
  WHERE   PermissionCode = 'SYSTEM_FOLDER'
  ORDER BY ViewOrder

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermissionsByModuleDefID' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermissionsByModuleDefID
 @ModuleDefID int
AS
 SELECT  *
  FROM    dbo.Permission
  WHERE   ModuleDefID = @ModuleDefID
  ORDER BY ViewOrder

 

System.Data.SqlClient.SqlException: Die Transaktion (Prozess-ID 93) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update GetPermissionsByModuleID Procedure */
/*********************************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetPermissionsByModuleID]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.GetPermissionsByModuleID


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermissionsByModuleID' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermissionsByModuleID
 @ModuleID int
AS
 SELECT  *
  FROM    dbo.Permission
  WHERE   ModuleDefID = (SELECT ModuleDefID FROM dbo.Modules WHERE ModuleID = @ModuleID)
  OR  PermissionCode = 'SYSTEM_MODULE_DEFINITION'
  ORDER BY ViewOrder

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPermissionsByTab' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.GetPermissionsByTab
AS
 SELECT  *
  FROM    dbo.Permission
  WHERE   PermissionCode = 'SYSTEM_TAB'
  ORDER BY ViewOrder

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'MoveTabModule' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 


CREATE PROCEDURE dbo.MoveTabModule
 @FromTabId    int,
 @ModuleId    int,
 @ToTabId    int,
 @PaneName    nvarchar(50),
 @LastModifiedByUserID int

AS
 UPDATE dbo.TabModules
  SET
   TabId = @ToTabId,  
   ModuleOrder = -1,
   PaneName = @PaneName,
   LastModifiedByUserID = @LastModifiedByUserID,
   LastModifiedOnDate = getdate()
  WHERE  TabId = @FromTabId
  AND    ModuleId = @ModuleId

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetModulePackagesInUse' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetModulePackagesInUse]
 @PortalID INT,
 @ForHost BIT
AS

IF (@ForHost = 1)
 -- Get in use for all host pages and portal pages
 SELECT AllPackages.* FROM dbo.Packages AS AllPackages
  INNER JOIN (
   SELECT DISTINCT P.PackageID
   FROM dbo.Packages P
    INNER JOIN dbo.DesktopModules DM
     ON P.PackageID=DM.PackageID
    INNER JOIN dbo.vw_Modules M
     ON M.DesktopModuleID=DM.DesktopModuleID
    INNER JOIN dbo.tabs T
     ON T.TabID=M.TabID
   WHERE T.IsDeleted=0
    AND M.IsDeleted=0) AS InUsePackages
  ON AllPackages.PackageID = InUsePackages.PackageID
 ORDER BY AllPackages.FriendlyName
ELSE
 -- Get in use for portal or host only
 SELECT AllPackages.* FROM dbo.Packages AS AllPackages
  INNER JOIN (
   SELECT DISTINCT P.PackageID
   FROM dbo.Packages P
    INNER JOIN dbo.DesktopModules DM
     ON P.PackageID=DM.PackageID
    INNER JOIN dbo.vw_Modules M
     ON M.DesktopModuleID=DM.DesktopModuleID
    INNER JOIN dbo.tabs T
     ON T.TabID=M.TabID
   WHERE ((@PortalID IS NULL AND T.PortalID IS NULL) OR T.PortalID = @PortalID)
    AND T.IsDeleted=0
    AND M.IsDeleted=0) AS InUsePackages
  ON AllPackages.PackageID = InUsePackages.PackageID
 ORDER BY AllPackages.FriendlyName


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetTabsByPackageID' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetTabsByPackageID]
 @PortalID INT,
 @PackageID INT,
 @ForHost BIT
AS

IF (@ForHost = 1)
 -- Get all host pages and portal pages
 SELECT DISTINCT T.*
 FROM dbo.vw_Modules M
  INNER JOIN dbo.DesktopModules DM
   ON M.DesktopModuleID=DM.DesktopModuleID
  INNER JOIN dbo.tabs T
   ON T.TabID=M.TabID
 WHERE DM.PackageID=@PackageID
  AND T.IsDeleted=0
  AND M.IsDeleted=0
 ORDER BY T.PortalID, T.TabName
ELSE
 -- Get pages for a specific portal (or host pages only)
 SELECT DISTINCT T.*
 FROM dbo.vw_Modules M
  INNER JOIN dbo.DesktopModules DM
   ON M.DesktopModuleID=DM.DesktopModuleID
  INNER JOIN dbo.tabs T
   ON T.TabID=M.TabID
 WHERE DM.PackageID=@PackageID
  AND ((@PortalID IS NULL AND T.PortalID IS NULL) OR T.PortalID = @PortalID)
  AND T.IsDeleted=0
  AND M.IsDeleted=0
 ORDER BY T.TabName


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetTabPaths' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetTabPaths]
 @PortalID int
AS
 SELECT
  TabID,
  PortalID,
  TabPath
 FROM dbo.Tabs
 WHERE PortalID = @PortalID OR @PortalID Is NULL


System.Data.SqlClient.SqlException: Löschen des Prozedur-Objekts 'dbo.AddSearchItem' ist nicht möglich, weil das Objekt nicht vorhanden ist oder Sie nicht die erforderliche Berechtigung haben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Update AddSearchItem Procedure */
/**********************************/

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddSearchItem]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.[AddSearchItem]


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddSearchItem' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddSearchItem]
   @Title       NVARCHAR(200),
   @Description NVARCHAR(2000),
   @Author      INT,
   @PubDate     DATETIME,
   @ModuleId    INT,
   @SearchKey   NVARCHAR(100),
   @Guid        NVARCHAR(200),
   @ImageFileId INT
AS
  DECLARE  @ID INT
  SELECT @ID = SearchItemId
  FROM   dbo.SearchItem
  WHERE  ModuleId = @ModuleID
         AND SearchKey = @SearchKey
  IF @ID IS NULL
    BEGIN
      INSERT INTO dbo.SearchItem
                 ([Title],
                  [Description],
                  [Author],
                  [PubDate],
                  [ModuleId],
                  [SearchKey],
                  [guId],
                  [HitCount],
                  [ImageFileId])
      VALUES     (@Title,
                  @Description,
                  @Author,
                  @PubDate,
                  @ModuleId,
                  @SearchKey,
                  @Guid,
                  0,
                  @ImageFileId)
      SELECT Scope_identity()
    END
  ELSE
    BEGIN
      UPDATE dbo.SearchItem
      SET    [Title] = @Title,
             [Description] = @Description,
             [Author] = @Author,
             [PubDate] = @PubDate,
             [ModuleId] = @ModuleId,
             [SearchKey] = @SearchKey,
             [guId] = @Guid,
             [HitCount] = [HitCount] + 1,
             [ImageFileId] = @ImageFileId
      WHERE  SearchItemId = @ID
      SELECT @ID
    END


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'AddSearchItemWord' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[AddSearchItemWord]
   @SearchItemID  INT,
   @SearchWordsID INT,
   @Occurrences   INT
AS
  DECLARE  @ID INT
  SELECT @id = SearchItemWordId
  FROM   dbo.SearchItemWord
  WHERE  SearchItemId = @SearchItemID
         AND SearchWordsId = @SearchWordsID
  IF @ID IS NULL
    BEGIN
      INSERT INTO dbo.SearchItemWord
                 ([SearchItemId],
                  [SearchWordsId],
                  [Occurrences])
      VALUES     (@SearchItemID,
                  @SearchWordsID,
                  @Occurrences)
      SELECT Scope_identity()
    END
  ELSE
    BEGIN
      UPDATE dbo.SearchItemWord
      SET    Occurrences = @Occurrences
      WHERE  SearchItemWordId = @id
             AND Occurrences <> @Occurrences
      SELECT @id
    END


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'Dashboard_GetInstalledModules' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[Dashboard_GetInstalledModules]
AS
 SELECT  
  DesktopModuleID,
  ModuleName,
  FriendlyName,
  Version,
  (SELECT     COUNT(*) AS Instances
   FROM          dbo.DesktopModules
    INNER JOIN dbo.ModuleDefinitions ON dbo.DesktopModules.DesktopModuleID = dbo.ModuleDefinitions.DesktopModuleID
    INNER JOIN dbo.Modules ON dbo.ModuleDefinitions.ModuleDefID = dbo.Modules.ModuleDefID
   WHERE      (dbo.DesktopModules.DesktopModuleID = DM.DesktopModuleID)) AS Instances
 FROM dbo.DesktopModules AS DM
 WHERE (IsAdmin = 0)
 ORDER BY ModuleName


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetPackageByName' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetPackageByName]
    @PortalID   int,
 @Name  nvarchar(128)
AS
 SELECT *
  FROM   dbo.Packages
  WHERE  [Name] = @Name
      AND (PortalID = @PortalID OR @PortalID IS NULL)


System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetUsersByRolename' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetUsersByRolename]
 @PortalID int,
 @Rolename nvarchar(50)
AS
 SELECT    
  U.*,
  UP.PortalId,
  UP.Authorised,
  UP.IsDeleted,
  UP.RefreshRoles
 FROM dbo.UserPortals AS UP
   RIGHT OUTER JOIN dbo.UserRoles  UR
   INNER JOIN dbo.Roles R ON UR.RoleID = R.RoleID
   RIGHT OUTER JOIN dbo.Users AS U ON UR.UserID = U.UserID
  ON UP.UserId = U.UserID 
 WHERE ( UP.PortalId = @PortalID OR @PortalID IS Null )
  AND (UP.IsDeleted = 0 OR UP.IsDeleted Is NULL)
  AND (R.RoleName = @Rolename)
  AND (R.PortalId = @PortalID OR @PortalID IS Null )
 ORDER BY U.FirstName + ' ' + U.LastName

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetUsers' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetUsers]
 @PortalID int
AS
 SELECT
   U.*,
   UP.PortalId,
   UP.Authorised,
   UP.IsDeleted,
   UP.RefreshRoles
 FROM dbo.Users U
  LEFT JOIN dbo.UserPortals UP on U.UserId = UP.UserId
 WHERE ( UP.PortalId = @PortalID or @PortalID is null )
 ORDER BY U.FirstName + ' ' + U.LastName  

 

System.Data.SqlClient.SqlException: In der Datenbank ist bereits ein Objekt mit dem Namen 'GetUserCountByPortal' vorhanden.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

CREATE PROCEDURE dbo.[GetUserCountByPortal]
 @PortalId int
AS
 SELECT COUNT(*) FROM dbo.vw_Users
  WHERE PortalID = @PortalID And IsDeleted = 0

 

System.Data.SqlClient.SqlException: Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'LogEventID' wurde in der 'dbo.EventLog'-Tabelle mehrmals angegeben.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Change primary key of EventLog Table */
/****************************************/

IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
 BEGIN
  --Note this name does NOT have an object qualifier in 4.x upgrades
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLogMaster

  --Note this name does have an object qualifier in 5.x installs
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLogMaster

  --Some scenarios have the primary key as PK_EventLog
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLog'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLog

  ALTER TABLE dbo.EventLog
   ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
   
  ALTER TABLE dbo.EventLog
   ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )  
 END

 

 

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
9/12/2009 5:21 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

Matthias,

usually this is caused by a failed previous upgrade attempt combined with a missing conditional delete preceding the sproc creation. Please report this in Gemini. Thanks. 

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL DataProvider05.01.00 issue on upgrade from DNN 5.0.1 to 5.1.2SQL DataProvider05.01.00 issue on upgrade from DNN 5.0.1 to 5.1.2


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out