Is there really no way?

I found out, that changing the default database for the user which is used with the linked server, to the database which is solves it. But still, not satisfying if...

the error I get when executing the:

SELECT @execute = 'EXEC (''USE '+@sourcedatabase+' ; ''+@trigger) AT ['+@sourceserver+']'

SELECT @param = N'@trigger nvarchar(4000)'

EXEC sp_executesql @execute,@param,@trigger

is:

EXEC ('USE SyncTestBase ; '+@trigger) AT [FEBKH03\COAS]

@trigger nvarchar(4000)

Msg 111,...

Thanks.. I went for the temp table solution.. And it worked ..

Thanks for all replies... I audited the database, and found out that someone was running a script that removed all user mappings for unknown users.

the database has been restored.. But theese users are new logins, that did not exist on the old server.

Great... It worked... The default language was english... When I changed it to Danish, it worked.. Thanks a lot...

Well that was even better...

Ahh... Got it working.. The problem was of course that I did not have an ELSE ... When the value <> 0 then Colounm1. 🙂

My problem is, that in this specific query the value is Null when it has to choose column2... (and the value is not null ;-))

Now I have.. But unfortunately without success.

Thanks very much everyone for the input... It has been very usefull...

Kind regards,

Anders Hansen

Sorry... What I would like to do is:

- To make my stored procedure return an output variable with the result of the EXEC (@query).. It returns only one value,...

It apparently had to do with that our SQL server 2008, is a SQL cluster.. When we failed over to the other node.. The error was not present...

Hi,

And as a reply to Nitin, no, this returned the same error.

I found another way to solve it.. But this is a bit stupid... The data from the @Lastrun2 is...