Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaveBF
Yak Posting Veteran
89 Posts |
 Posted - 2012-08-14 : 13:14:31
|
| I have a table with some varbinary(max) columns. How can I tell if filestream is being used for these items? Is there something I should see when I do a Select * from the table? What if I double click on the column name in SSMS? -thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-14 : 13:20:11
|
| you need to search for column in catalog view sys.columns and look for is_filestream column valueselect name,is_filestreamfrom sys.columnswhere OBJECT_NAME(object_id)='your table'------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How can I tell if Filestream is being used