We have been investigating setting up an active/active cluster. We have identified that cross database chaining is not intended to work across two separate servers. This may be an issue,...

I do have linked servers and I believe that the account delegation commands have been performed, but I will now check this further. I know that the setspn -L command...

Thanks for these.

The ASPNET login is configured to have EXEC permissions. Our policy is to prevent direct access to SQL statements, except through SP's.

This all works correctly if the...

SP called from ASP appl using ASPNET and system configured to use localhost/ASPNET user through all connections.

Password is the same on Web and both SQL servers in the cluste.

There is...

SP called from ASP appl using ASPNET and system configured to use localhost/ASPNET user through all connections.

Password is the same on Web and both SQL servers in the cluste.

There is...

Procedure is as follows

=====================================

CREATE PROCEDURE [dbo].[usp_SBIR_GetUnReconciledInvoiceCustomerName]

@RequestingUser NVARCHAR(50), @ApplicationID INT

AS

BEGIN

SET NOCOUNT ON

/*

' usp_SBIR_GetUnReconciledInvoiceCustomerName

'----------------------------------------------------------------

' Description:

' Returns All Customer Names who have Unreconciled invoices

'

' In:

' @RequestingUser NVARCHAR(50), @ApplicationID INT

'----------------------------------------------------------------

*/

DECLARE @ErrorNb...

There are no odd characters.

I have tried manipulating the package and by splitting the update and inserts into 2 sql tasks I have managed to get it to work without...

The procedure performs the following

CREATE PROCEDURE usp_translatetext

@tablename sysname,

@keyname sysname,

@languageID int,

@entityID int,

@Description nvarchar(50) OUTPUT,

@PopupText nvarchar(300) OUTPUT

AS

BEGIN

SET NOCOUNT ON

DECLARE @sqlstr nvarchar(2000)

SET @sqlstr = 'if exists (SELECT [Description], PopupText FROM EDB.dbo.' + @tablename...

Unfortunately I cannot convert this to a UDF because the SELECT statement is parameterised and is run using the SP_EXECUTESQL command.

This cannot be run from within a function.

I cannot return...

The logic is in an sp because it is performing a parameterised lookup where the tablename, keyfield name,keyfield value are passed in and the text values are passed out. The...

Thanks Antares for all your help

There's an extra space beteween @tablename and Translation on one of the selects - i've resolved that and it's now working ok.

Thanks for that -

it's now complaining about an invalid column

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'LanguageID'.

This column is correctly defined in tblIANMAinTranslation table

I've just run the amended statement, but this still returns the same errors

When I run this as a procedure

declare @out1 varchar(50)

declare @out2 varchar(300)

exec usp_GetDesAndPopup tblIANMain,64,1,@out1,@out2

it gives errors

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near '='.

Server: Msg...

And here are the statements :-

DECLARE @tablename char(30)

DECLARE @languageID int

DECLARE @entityID int

SET @tablename='tblIANMain'

SET @languageID=64

SET @entityID=1

DECLARE @selectstring nvarchar(500)

SET @selectstring='SELECT [Description],PopupText FROM EDB.dbo.' +

rtrim(ltrim(@tablename)) + 'Translation WHERE EntityID = ' + cast(@entityID...