FILESTREAM Error - Default FILESTREAM filegroup is not available in database "dbname"

I see this error reported many times in the online forums. This usually happens if you try to create a FILESTREAM enabled table in a database that is not configured for FILESTREAM usage. To be able to store FILESTREAM data in a database, the database...

How to query the auto-growth properties of a SQL Server database using TSQL?

I saw this question recently in one of the forums and wrote a small piece of code to retrieve this. SELECT name, CASE WHEN is_percent_growth = 0 THEN LTRIM(STR(growth * 8.0 / 1024,10,1)) + ' MB, ' ELSE 'By ' + CAST (growth AS VARCHAR ...