Home Dashboard Directory Help
Search

Inaccuries in topic for ALTER DATABASE File and Filegroup Options by Erland Sommarskog


Status: 

Resolved
 as Fixed Help for as Fixed


1
0
Sign in
to vote
Type: Bug
ID: 777247
Opened: 1/23/2013 4:36:39 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Under FILENAME 'filestreampath' it says:

    The filegroup and file ( <filespec>) must be created in the same statement.

This is incorrect. You cannot even have ADD FILEGROUP and ADD FILE in the same statement, and example I uses two statements. Also, note that in this example "database" is in lowercase.
Details
Sign in to post a comment.
Posted by Microsoft on 8/9/2013 at 10:12 AM
Removed the note and fixed the last example in both SQL Server 2012 and SQL Server 2014 documentation. This will appear online as they are refreshed. Thank you for bringing this to our attention.
Posted by Microsoft on 1/29/2013 at 12:40 PM
Thank you for submitting this. I'll take a look at it.
Sign in to post a workaround.