Hi,
I get the following error message during the installation of DUD. I'm quite (but not absolutely) sure, that I've not installed DUD before. Now i wonder, if it's something serious.
Thanks in advance for your answers, Sven
Die SQL-Ausführung hat folgende Fehler verursacht:
System.Data.SqlClient.SqlException: There is already an object named
'DataSprings_DUD_GetUserRoles' in the database.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
bei
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
bei
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
CREATE FUNCTION dbo.[DataSprings_DUD_GetUserRoles] (@UserID int)
RETURNS nvarchar(2000)
AS
BEGIN
Declare @UserRoles nvarchar(2000)
declare @RoleName nvarchar(500)
declare RoleList cursor for
Select B.RoleName from dbo.[Userroles] A Inner Join dbo.[Roles] B on
A.RoleID = B.RoleID
Where (UserID = @UserID) AND (ExpiryDate >= GetDate() OR
ExpiryDate Is Null) AND (EffectiveDate <= GetDate() OR EffectiveDate
Is Null)
OPEN RoleList
FETCH NEXT FROM RoleList
INTO @RoleName
Set @UserRoles = ''
WHILE @@FETCH_STATUS = 0
BEGIN
set @UserRoles = @UserRoles + @RoleName + '
'
FETCH NEXT FROM RoleList INTO @RoleName
END
CLOSE RoleList
DEALLOCATE RoleList
Return @UserRoles
END
.