Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Richard Douglas

Richard Douglas is a SQL Server Professional working in the UK where he recently worked as a DBA in women's clothing, not literally he hastens to add! He is certified in SQL Server 2008, runs the Maidenhead SQL Server User Group Pass Chapter and is on the organising committee for SQL Relay. In his spare time plays the trumpet in local symphony orchestras.

His online presence includes:

New Undocumented Feature in SQL Server 2014

 

Today is the eagerly anticipated launch of SQL Server 2014, I have downloaded and installed a copy of the RTM product and had a play. During some intensive testing I found that there is a new undocumented feature which will allow all registry keys to be available inside of your systems environmental variables. It also means that the default directory for databases, backups, filestreams and any other files you want to import / export will seamlessly connect and work even if you do not specify a path!

 

How do you turn this on I hear you ask?

 

Simply enter “-SatNav” as a startup parameter
or
Use traceflag -20140401

 

As you would expect from initial findings this appears to be an Enterprise only feature.

 

Comments

Leave a comment on the original post [sql.richarddouglas.co.uk, opens in a new window]

Loading comments...