Silverkight Viewer for Reporting Services
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

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

Copyright © Beyondrelational.com