You searched for the word(s): userid:188471

More Search Options

RSS Available

• Can you perform a full postback from one button in an Atlas Update Panel?

  I have a control that has many buttons on it, I can configure the button properties in the control. I want to put the control in an Atlas Update Panel, but is there a way that I can have one of the controls buttons perform a full standard postback and the rest trigger an atlas postback?

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by Philotech on 1/4/2007

• Errors in SQL Server 2005 Profiler

  I notice this running the SQL Server Profiler under the application name Report Server. Every time it runs, it reports an error (in the Error field of Profiler). Does anyone know what this is? declare @p1 nvarchar(64) set @p1=NULL exec GetDBVersion @DBVersion=@p1 output select @p1

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/27/2006

• Re: Cannot compare NVarChar(Max) fields over 4000 chars

  Application is already live

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/25/2006

• Re: Cannot compare NVarChar(Max) fields over 4000 chars

  Okay, Caddre thank you. Before I converted from ntext to nvarchar(max) I used sp_tableoption 'dbo.Orders', 'text in row', 'off' (Which did nothing)Then I changed to NVarChar(Max) and was told that large value types out of row was on by default and not to do anything with it. I just did it anyway, and that fixed it. Why would this default to off? or is this person just wrong? No I pray this works in the live databse...

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/25/2006

• Re: Cannot compare NVarChar(Max) fields over 4000 chars

  Everything that the profiler is passing in is fine, I checked all the values and they have the correct length. Does 'Print' have a max number of chars that it can output? I was trying to print the value of @o_Comments and SELECT Comments From Orders WHERE OrderID = '7468985', but that appear to truncate. Just to update, I no longer have any ntext fields in the database, I updated them all to NVarCharMax. As per the Profiler, everything is being sent from the application to the SQL

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/25/2006

• Re: Cannot compare NVarChar(Max) fields over 4000 chars

  I can't... The customer requires those fields to be over 4000 chars... how can I compare them to see if they have been changed? Is there a way to generate a has on a NVarChar(MAX) over 4000 chars? There has to be a way to handle it? right?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/25/2006

• Cannot compare NVarChar(Max) fields over 4000 chars

  I had a post a week or so ago with this issue, I found the cause, but cannot figure out how to fix it... The problem is the comparison on the NVarChar(Max) fields when one of them exceeds 4000 chars. If I comment out the following lines of the stored proc, everything works. I tested without using COALESCE and it still does not work. COALESCE ( Comments , '' ) = COALESCE ( @o_Comments , '' ) AND COALESCE ( SpecialNotes , '' ) = COALESCE ( @o_SpecialNotes , '' ) AND

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/24/2006

• Re: Change ntext to nvarchar(max) in a live database

  Actually it was a problem upgrading a SQL 2000 database to SQL 2005 then modifying it, I had to recreate the table. Once I recreated the table and did a Select Into, the problem was resolved. And I created another thread because I wanted to change the datatypes from ntext to nvarchar(max) in a live database and wanted to know if it was going to have any ill effects. In my experience, when you ask a different question in an existing thread, you do not get an answer for both questions, so I wanted

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/20/2006

• Re: Change ntext to nvarchar(max) in a live database

  Where and how do I do this? Also I changed the ntext fields in the database to NVarChar(MAX), so now I can modify the values in the database directly, but when I do it through the application and the VarChar(MAX) fields are over 4000 it does not save the changes, but does not return an error either. It returns as if the stored procedure executed successfully.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/20/2006

• Re: ntext over 4000 chars causes 'Data in row (n) was not update... string or binary data would be truncated...'

  I am making the changes directly in SSMS, so the application has nothing to do with the problem.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Philotech on 10/19/2006