sys-fn-servershareddrives-transact-sql.md

title	sys.fn_servershareddrives (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	fn_servershareddrives fn_servershareddrives_TSQL
dev_langs	TSQL
helpviewer_keywords	fn_servershareddrives function shared drives [SQL Server] names [SQL Server], shared drives sys.fn_serversharedrives function
ms.assetid	ff01eff7-8cb6-460c-ba7a-6a52bda6d471
author	rothja
ms.author	jroth

sys.fn_servershareddrives (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

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)