.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL2008 Filestream Column Issue

Posted By:      Posted Date: October 10, 2010    Points: 0   Category :Sql Server
I've got a table that uses the SQL 2008 FILESTREAM feature for storing binary data within a filegroup.
This feature is not supported by Management Studio so any designer modification will remove the feature from the column.

My question is, how would one recover from this? Reattaching the attribute and the binary data link to the filegroup? It doesn’t seem possible?
With thousands of records this could mean massive data issues should someone modify the table with the GUI.


View Complete Post

More Related Resource Links

Datasheet view lookup column issue


When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.


Any ideas how to get this resolved?

Weird Date vs Date/Time issue using a calculated column

I'm attempting to use the fab 40 attendance template. I don't need the time to show - Im able to hide that on the forms with jquery (endusersharepoint.com thank you!!) I WAS ATTEMPTING to create a calculated column called Start Date where the formula simply reads '=[Start Time]' When it's set to display 'Date Only' the date is off by a day. If I switch it to 'Date & Time' I get the correct date. Huh?

WPF DataGrid Column Width issue

I have a simple window with 2 tabs, and 4 datagrids.  I set up each one with similar, if not identical settings.  They all get their own DataSet based binding, and have standard Text columns, and combo box columns.  Recently (past week) of development, while I was adding filtering/sorting/grouping features to my program, the column widths have begun to ingore my settings.  By collapsed I mean approx 20 pixels wide (just enough for the sorting Icon). Contacts datagrid, works great in run time, but in design time the columns are all collapsed. ContactsToClients data grid has no abnormal issues Clients datagrid AND Clients to Contacts datagrid look great in design time, but show collapsed columns in run time. How do I hunt down the problem?  I've tried removing all the temporary code, and rebuilding, closing Visual Studio and reopening.  I've remmed out the sorting code.  None of these have any affect.  It appears that my settings are all being ignored.  Here is the XAML code:   <Window x:Class="wdContacts" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:my

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

Listview column issue??

Hello.      i have a listview with around 9 column and in that i have column as Address.Now everything works fine....Now suppose lots of character in Address then my css breaks...Is it possible to display few characters of the address followed by .....  ??? i have seen in few site but no clue how to implement...like instead of          Abhishek,House No.30,Middle Lane,Arizon.i want just        Abhishek,House No.30,Middle ......and i would like to implemet mouse hover extender later to display full address but i am not able to implement first part only...Can any one guide me on this??? and i have used this link for my css. http://mattberseth.com/blog/2008/05/modifying_data_with_the_listvi.htmlThanks.

Filestream column

Hello, On a Visual Studio 2010 database project I created the following table: CREATE TABLE [dbo].[Resources] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Content] VARBINARY (MAX) FILESTREAM NULL, [Description] NVARCHAR (800) NULL, [Key] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL, [Locked] BIT NOT NULL, [Name] NVARCHAR (100) NOT NULL ); I keep having the error: SQL04141: A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column. But I do have such a column: Key What am I doing wrong? Thanks, Miguel  

Content Types: Title Column Rename Issue


Hi All

i have created Custom Content Type.
Name: TestCP
Desc: Testcp
Select parent Content type from: List Content Types
Parent Content Type: Task
existing Group; Custom Centent Types.
Clicked Ok

-- Custom Content type successfully created. Now i clicked on Title column name and renamed To Action Title.
Radio button was seledted(Required(must Contain information))
Radio button was seledted(Update all content types inheriting from this type? Yes)

Clicked Ok.

it has remaned all the title columns of site collection.

Now when iam trying to rename it back its giving an error "The column name that you entered is already in use or reserved. Choose another name"

Please help me out to get it back.

thanks in Advance.

SSRS Word Export Issue- Last Column Data getting Trim


We are exporting a SSRS report in Word. The last colum is getting displayed without its right side vertical bar. Data is also getting trim. Please let us know the solution on this.


Datagrid: Rendering issue with Star-Column




if i define a usercontrol with datagrid on it, which has one star column in the middle, it has a ugly rendering issue when its resized/shown. it seems that the calculation of star column's width is asynchronous started in OnRender.

here is the repro xaml code:


<UserControl x:Class="DatagridTest.UserControl1"
       d:DesignHeight="300" d:DesignWidth="300">

  <Grid DataContext="{Binding Source={StaticResource SampleDataSource}}">
    <DataGrid x:Name="dGrid" ItemsSource="{Binding Collection}" AutoGenerateColumns="False" RowHeight="40" >
        <DataGridTemplateColumn Width="100">
                <Label Content="{Binding Property1}" Height="30"/>

New column issue - Error number: MSSQL_REPL-2147199478



In merge replication we have following issue which appears from time to time in few subscriptions.

When I added new column to table by using following procedure:


sp_repladdcolumn @source_object = N'TABLE_NAME'

,@column = N'NEW_COLUMN_NAME'

, @typetext =N'tinyint null'  

, @publication_to_add = N'PUBLICATION_NAME'

, @from_agent = 0

, @schema_change_script = null

, @force_invalidate_snapshot = 0 

, @force_reinit_subscription = 0


replication for few subscriptions gets following error:

The schema definition of the destination table 'dbo'.'TABLE_NAME' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot

How to add FILESTREAM attribute to an existing column?

I have a table that uses the FILESTREAM attribute for SQL Server 2008. If I edit it in the 2008 SSMS table designer, the FILESTREAM attribute is lost. Most folks say to use ALTER to put it back. Problem is that every example I see shows creating a brand new table or brand new column. I can drop and re-add the column but then I lose my data. What happens if I have a table in production with existing filestream data and need to put the FILESTREAM attribute back on the column without losing the data in the column?

I tried and get this:

Cannot alter column 'Data' in table 'accnt_attachment' to add or remove the FILESTREAM column attribute.

Obviously I do not have the correct syntax. An example would be greatly appreciated.


Issue with row and column Grouping

In my report I have two row groups one below the other that belong to the same parent group. I also have a column group. What happens is until I have only one row group and one column group the report works fine. When I add a second row group below the first one the values are displayed correct for this second row grouping but the values for the first row group which were earlier correct are not shown. The display for those values is blank. Can anyone help with why this is happening? 

Excel column issue reading


Hi Experts,

We have excel with one column which is actually Custom column and type is h:mm:ss (when I right click and seleting format cells).

So when I'm selecting any of the cell into the excel file, it has values in the for of h:mm:ss but when I look above the value "fx" it is different some thing like date + time + AM/PM ( for the same seleted cell ) ---- which means two different values for the same selected cell.

Now we need to load this excel file using SSIS to our DB table, I tried but it is loading upper value ( date + time + AM/PM ) and not the value which the selected cell is having h:mm:ss.

Suppose for an example I have selected on cell whose value is 41:48:57 but when I see above near by to fx it is having 1/1/1900 4:14:40 AM and SSIS is loading this value and not the actual value ( 41:48:57 "h:mm:ss" format).

So how to tell SSIS to load value in the form of h:mm:ss and not the date+time+AM/PM value? Tried my best to explain you guys.

Please let me know if you have any specific quesiton.



Issue with People and Groups type of column in datasheet view of shrepoint list.


We have a list created in MOSS 2007 which has a column of type people and groups. When we open the list in datasheet view and try to add records for people and groups type of column the column shows only records from All People section of the site collection. I have verified this for another site collection within the same web application where I am able to see all the users though they are not in the All people section of site collection.
Could anyone please let me know if I am missing any setting or if there is any change required to see all the user names in the people and groups type of column in datasheet view.

Thanks ,

Null Value/ create new column issue in SQL


Hi, I have a database with year, month, area1, area2.  Area2 has null values in them, and i want to create a 3rd column that takes area2 value as default, but if there is a null value in the column, then it looks at taking the value from area1. 

The Third column is the kind of column that i would like to produce, but i am not sure how to write it.

See example below:

year month area1 area2

Memory issue vith SQL2008 SP2 on a 64 bits W2008


Hi to all !

Sometimes, my production system crashes, and a "memory status" is displayed in my errorlog.

I suspect that a stored procedure could be responsible...

Is anybody can tell me what pool is concerned by the issue ?

There is no message before the memory status, and just after it, i have :

2010-10-27 16:40:26.46 spid117     Error: 701, Severity: 17, State: 123.
2010-10-27 16:40:26.46 spid117     There is insufficient system memory in resource pool 'internal' to run this query.

Thanks for help !



Memory Manager                                   KB
---------------------------------------- ----------
VM Reserved                                 4311480
VM Committed                                4287208
Locked Pages Allocated    

Buffer issue on one particular column in an SSIS package

I have an SSIS package with a) Sharepoint List Source, b) Data Conversion, c) OLE DB destination.  

I had to use the data conversion component in order to change the string data from Unicode.

All fields come over fine except for a column that basically contains some HTML code.  It comes in as a 4000 character field, and I get this error even if I truncate the data in the conversion component.  

Here's the error:  

[SharePoint List Source [1]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.    at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value)    at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket)

Here's what the data in field looks like:

<div class=ExternalClass27637224667E4692AA7B7B0B2059FBE0><div id="_Note_9023a1eb-e648-4fac-aaa6-b7b5e38a628f" class="mmt_noteItem"><div class=
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend