TechNet
Products
IT Resources
Downloads
Training
Support
Windows
Windows
Server
System
Center
Internet
Explorer
Office
Office 365
Exchange
Server
SQL Server
SharePoint
Products
Lync
See all products »
Evaluation Center
Learning Resources
Microsoft IT Camps
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
Solution Accelerators
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Networking
Cloud and Datacenter
Security
Virtualization
Service Packs
Security Bulletins
Microsoft Update
Windows Server 2012
System Center 2012 SP1
Microsoft SQL Server 2012 SP1
Windows 8 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Drivers
Compatability & Converters
Windows Sysinternals
TechNet Gallery
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
TechNet Events
Second shot for certification
Born To Learn blog
IT Camps
Exchange Server
Forefront Server
Forefront Edge Security
Forefront Server Security
Internet Explorer
Office
SharePoint
SQL Server
System Center
Windows Server
Windows XP
Windows Vista
Windows 7
Windows 8
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Microsoft Customer Support
Microsoft Community Forums
United States (English)
Sign in
Print This Topic
Print Multiple Topics
Home
2012
2008 R2
2008
Previous Versions
Library
Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Microsoft.SqlServer.Management.Smo Namespace
Database Class
Database Methods
Alter Method
ChangeMirroringState Method
CheckAllocations Method
CheckAllocationsDataOnly Method
CheckCatalog Method
CheckIdentityValues Method
CheckObjectState Method
Checkpoint Method
CheckTables Method
CheckTablesDataOnly Method
Create Method
Deny Method
DisableAllPlanGuides Method
Drop Method
DropAllPlanGuides Method
DropBackupHistory Method
EnableAllPlanGuides Method
EnumBackupSetFiles Method
EnumBackupSets Method
EnumCandidateKeys Method
EnumDatabasePermissions Method
EnumLocks Method
EnumLoginMappings Method
EnumMatchingSPs Method
EnumObjectPermissions Method
EnumObjects Method
EnumTransactions Method
EnumWindowsGroups Method
ExecuteNonQuery Method
ExecuteWithResults Method
GetBoolParameter Method
GetParameter Method
GetStringParameter Method
GetTextBody Method
GetTextForScript Method
GetTextProperty Method
GetTransactionCount Method
GetUrnRecursive Method
Grant Method
Initialize Method
IsMember Method
PrefetchObjects Method
RecalculateSpaceUsage Method
Refresh Method
RemoveFullTextCatalogs Method
Rename Method
Revoke Method
Script Method
ScriptImpl Method
SetDefaultFileGroup Method
SetDefaultFileStreamFileGroup Method
SetDefaultFullTextCatalog Method
SetOffline Method
SetOnline Method
SetOwner Method
SetSnapshotIsolation Method
Shrink Method
TruncateLog Method
UpdateIndexStatistics Method
ValidateAllPlanGuides Method
This topic has not yet been rated
-
Rate this topic
Database
.
SetDefaultFileStreamFileGroup Method
SQL Server 2008
Other Versions
SQL Server 2008 R2
SQL Server 2012
Sets the default filestream group.
Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.Smo
(in Microsoft.SqlServer.Smo.dll)
Syntax
C#
C++
F#
JScript
VB
Copy
public
void
SetDefaultFileStreamFileGroup(
string
fileGroupName )
Parameters
fileGroupName
Type:
System
.
String
String
identifying the filestream filegroup name on an NTFS file system.
See Also
Reference
Database Class
Database Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
FILESTREAM Overview
Did you find this helpful?
Yes
No
Not accurate
Not enough depth
Need more code examples
Tell us more...
(
1500
characters remaining)
Community Additions
ADD