sys-fn-servershareddrives-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sys.fn_servershareddrives (Transact-SQL)	sys.fn_servershareddrives (Transact-SQL)	rwestMSFT	randolphwest	03/14/2017	sql	system-objects	reference	fn_servershareddrives fn_servershareddrives_TSQL	fn_servershareddrives function shared drives [SQL Server] names [SQL Server], shared drives sys.fn_serversharedrives function	TSQL

sys.fn_servershareddrives (Transact-SQL)

[!INCLUDE SQL Server]

Returns the names of shared drives used by the clustered server.

Important

This [!INCLUDEssNoVersion] system function is included for backward compatibility. We recommend that you use sys.dm_io_cluster_valid_path_names (Transact-SQL) instead.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

  
fn_servershareddrives()  

Tables Returned

If the current server is a clustered server, fn_servershareddrives returns the drive name of the shared drives.

If the current server instance is not a clustered server, fn_servershareddrives returns an empty rowset.

Remarks

fn_servershareddrives returns a list of shared drives used by this clustered server. These shared drives belong to the same cluster group as the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] resource. Further, the [!INCLUDEssNoVersion] resource is dependent on these drives.

This function is helpful in identifying drives available to users.

Permissions

The user must have VIEW SERVER STATE permission for the [!INCLUDEssNoVersion] instance.

Examples

The following example uses fn_servershareddrives to query on a clustered server instance:

SELECT * FROM fn_servershareddrives();  

[!INCLUDEssResult]

DriveName

--------

m

n

See Also

sys.dm_io_cluster_valid_path_names (Transact-SQL)
sys.dm_io_cluster_shared_drives (Transact-SQL)
sys.fn_virtualservernodes (Transact-SQL)