Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in Azure by (13.1k points)

I want to store my pdf file to Azure SQL Db, and I get this error when I run create table query.

Msg 40517, Level 16, State 1, Line 28 Keyword or statement option 'file stream_on' is not supported in this version of SQL Server.

Can anyone help me how can I actually do this? 

1 Answer

0 votes
by (26.7k points)

Basically, FILESTREAM is not supported on Azure SQL Db. So, you can go for some alternatives to it.

Firstly, Store your whole content into in-db VARBINARY(MAX) column, this will increase your db size. and Secondly, Store your content on azure blob storage and keep the paths/url in the table, so that you can directly access blob storage via paths/url.

I hope this will work.

Want to know more about Azure Storage ? join azure certification now!

Related questions

0 votes
1 answer
asked Nov 5, 2020 in Azure by dev_sk2311 (44.2k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 5, 2020 in Azure by dev_sk2311 (44.2k points)

Browse Categories

...