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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777247 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/23/2013 4:36:39 AM
Access Restriction Public


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.
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.