Probleme mit SQL- Anbindung

  • Hallo zusammen,


    wir haben bei einem Kunden folgende Meldungen im Archiv Ereignisse und vermuten, dass die SQL- Anbindung fehlerhaft ist. Haben Ihr einen Tip wie wir hier am besten vorgehen bzw. was diese Meldungen bedeuten?
    --------------------------------------------------------------------------------------------------------------------------------------------
    Subject: SQL Error 80040e14 (15-Feb-2011 3:01)
    From: David Service Layer
    To:

    SQL Error 80040e14
    Code80040e14
    Code meaningIDispatch error #3092
    SourceMicrosoft OLE DB Provider for SQL Server
    DescriptionThere is already an object named 'fn_getarcids_with_shortcuts' in the database.
    Functionm_Connection->Execute
    CommandCREATE FUNCTION [dbo].[fn_getarcids_with_shortcuts] ( @PatH VARCHAR(500))
    RETURNS @IDS TABLE (
    id INT,
    recLevel INT)
    AS
    BEGIN
    DECLARE @recLevel INT
    DECLARE @rows INT
    SET @recLevel=1
    INSERT INTO @IDS (id, recLevel) SELECT ID, @recLevel FROM arc WHERE [Path] LIKE @PatH
    SET @rows=ROWCOUNT

    WHILE @rows>0 BEGIN
    SET @rows
    User IDffffffff

    -----------------------------------------------------------------------------------------------------------------------------------
    SQL Error 80040e14 (15-Feb-2011 3:01)
    From:

    David Service Layer
    To:

    SQL Error 80040e14
    Code 80040e14
    Code meaning IDispatch error #3092
    Source Microsoft OLE DB Provider for SQL Server
    Description There is already an object named 'shortcuts' in the database.
    Function m_Connection->Execute
    Command CREATE TABLE [shortcuts] (
    [ID] INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_shortcuts PRIMARY KEY,
    [arcID] INTEGER CONSTRAINT FK_shortcuts_arc FOREIGN KEY REFERENCES arc ([ID]) ON DELETE CASCADE ON UPDATE CASCADE NOT NULL,
    [shortcutID] INT NOT NULL
    );CREATE UNIQUE INDEX idx_shortcuts_arcidshortcutid ON shortcuts ([arcID], [shortcutID]);
    User ID ffffffff
    ------------------------------------------------------------------------------------------------------------------------------------
    Original Message

    processed by David.fx
    Subject:

    SQL Error 80040e14 (15-Feb-2011 3:01)
    From:

    David Service Layer
    To:

    SQL Error 80040e14
    Code 80040e14
    Code meaning IDispatch error #3092
    Source Microsoft OLE DB Provider for SQL Server
    Description The type 'udt_search_path_arcids' already exists, or you do not have permission to create it.
    Function m_Connection->Execute
    Command CREATE TYPE udt_search_path_arcids AS TABLE (id INT NOT NULL PRIMARY KEY);
    User ID ffffffff

Jetzt mitmachen!

Du hast noch kein Benutzerkonto auf unserer Seite? Registriere dich kostenlos und nimm an unserer Community teil!