sys-fn-servershareddrives-transact-sql.md

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