Is there an alternative of using a VBScript for enabling FileStream after SQL Server installation?
Posted
by user193655
on Stack Overflow
See other posts from Stack Overflow
or by user193655
Published on 2010-05-31T09:04:30Z
Indexed on
2010/05/31
9:52 UTC
Read the original article
Hit count: 162
To use Filestream on a DB 3 steps must be done:
1) enable it a server/instance level
2) enable it (sp_configure) at DB level
3) create a varbinary(max) field that supports filestream
(2) and (3) are done easily with T-SQL
(1) is doable manually from SQL Server Configuration Manager, basically what I need is to check all the 3 checkboxes:
but how is it possible to automize it?
I found this artcile "Enabling filestream usin a VBScript", is there another way to do it than using VBScripts? May be something that is possible to do only with 2008R2?
In case it VBScript is the only solution, which are the possible downsides?
© Stack Overflow or respective owner
