thx,

you saved my day 😀

Hi,

@grovelli-262555

here's a simple code example to add 2 values:

USE [Test01]

GO

/****** Object: UserDefinedFunction [dbo].[udf_GetStuff] Script Date: 06/19/2013 09:54:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:its me

-- Create...

hey grovelli-262555

look at the VBA-code, it works! I develop on SQL SERVER with an account at Windows Security with admin rights.

Calling

SELECT dbo.udf_GetStuff (44, 22) AS retVal

inside an Access...

Hi,

dbo is the schema owner, as all objects in SQL Server are owned by a schema (dbo = database owner). It's the usual syntax for every object in SQL Server,...

solution found:-)

SELECT dbo.udf_GetStuff (44, 22) AS retVal

Jeff Moden (2/26/2013)

candide (2/26/2013)

Thank you for the kind feedback. I just want to make sure because you're the one that will have to support it. Do you understand...

Hi,

Jeff's solution works great:-P

exactly what I needed

thanx

well, I read "Configuring Linked Servers for Delegation"

and can't understand:

I ran

EXEC sp_addlinkedserver 'SQLSERVER2', N'SQL Server'

EXEC sp_addlinkedsrvlogin 'SQLSERVER2', 'true'

Only when I have sp_addlinkedsrvlogin run with user "sa" it works. 😎

But...

thanks HowardW for your answer

I just need readonly access to one table which will grow silently to some hundred rows.

SSIS seems not to be the way because table updates should...

Hello,

I found out it's not connecting to SQL-Server whats the problem and I was searching in wrong direction.

I talked with another developer and he gave me the right hint. So...