EM acting funny all of a sudden
-
This morning my EM began acting different than it had before. I used to be able to update data in columns and move to the next row and it would post the data with no need for a confirmation. Now all of a sudden it asks everytime i change a record and move to another. This is quite troublesome. I also seem to have lost the ability to update a certain column in one table???
CREATE TABLE [dbo].[Test] (
[Index] [int] IDENTITY (1, 1) NOT NULL ,
[CallIndex] [int] NOT NULL ,
[Title] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Resolution] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Issue_Topic] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Product] [int] NOT NULL ,
[FromVersion] [int] NOT NULL ,
[ToVersion] [int] NULL ,
[Category] [int] NOT NULL ,
[SubmitBy] [int] NOT NULL ,
[PublishedDate] [smalldatetime] NOT NULL ,
[LastModifiedDate] [smalldatetime] NOT NULL ,
[LastViewedDate] [smalldatetime] NULL ,
[TimesViewed] [int] NOT NULL
) ON [PRIMARY]
GO
Its [Resolution] that i cannot update all of a sudden. I am the dbo so i should be able to do as i wish. I don't get it. Any ideas on the sudden change of behavior or why i cannot update the field as desired?
Think great, be great!
-
Your table structure slightly exceeds the max pagesize of SQL Server, which might be a reason that rows won't get updated.
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp might clear things up a bit.
Anyway, using EM to update data is not the best solution at all. You might want to get used to Query Analyzer.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I went back and changed the size of the [Resolution] field to varchar(5000) and i still get the same results. Any other suggestions?
Think great, be great!
-
Do you get the same results when using Query Analyzer?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
No the query runs with no problem in QA. Does your EM ask for confirmation when a change has been made to a record before moving on to another record? I know mine has not done that in the 6-7 months i have been working on this.
UPDATE KnowledgeBase
SET Resolution = '"To prin port fr Carie fllw ths stps; Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care view reports Printing Care '
WHERE [Index] = 5
All i'm trying to do is misspell some words in the long text so that i can execute a spellcheck, from my application, against the column's value.
Think great, be great!
-
Actually I've never tried it.
I guess most guys here would stay away from using EM wherever they can. Sometimes it seems to have a mind of its own. If the update viy QA works, I would stick to it.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply