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