Posts: 10,222. Grill marks have been discussed many times over the years. Sure, they are pretty and make a really strong statement about the meat, but many high-dollar restaurants reportedly draw their grill marks on with a meat-marker, while others brush on a coat of sugar water prior to it hitting the hit grill.
How to call Function ? You call a Function procedure by using the procedure name, followed by the argument list in parentheses, in an expression. You can omit the parentheses only if you are not supplying any arguments. However, your code is more readable if you always include the parentheses.
CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier) RETURNS VARCHAR(8000) AS BEGIN RETURN ASILIVE.ReportManager.dbo.UserGroupMembershipNames(@UserGUID) END. This doesn't work, as documented in PRB: User-Defined Function Call in Four-Part Linked Server Query Fails with Error Message 170. They also give a workaround: For example, instead of the following query . Select * from Linked_Server.northwind.dbo.square_value(10) run a query with the Openquery function: Select * from Openquery(Linked_Server,'select northwind.dbo.square_ value(10)') If the user-defined function takes variable or scalar parameters, you can use the sp_executesql stored procedure to avoid this behavior.