Windows apps
Collapse the table of content
Expand the table of content
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlFunctionAttribute::DataAccess Property

 

Indicates whether the function involves access to user data stored in the local instance of SQL Server.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public:
property DataAccessKind DataAccess {
	DataAccessKind get();
	void set(DataAccessKind value);
}

Property Value

Type: Microsoft.SqlServer.Server::DataAccessKind

DataAccessKind.None: Does not access data. DataAccessKind.Read: Only reads user data.

The default is None.DataAccess is also required when connecting to remote servers if transactions integration is required (the default).

If a Transact-SQL query is executed from inside a table-valued function (TVF), the DataAccessKind.Read property should be set.

.NET Framework
Available since 2.0
Return to top
Show:
© 2017 Microsoft