Don Urquhart (6/10/2011)

---

It looks to me like you are inserting only the ITEMNUMBER field, with no values for the key fields (tcsFLST_AttribGroup,[tcsFLST_ItemAtrib) which can not be NULL. You need to...

USE [RTW]

GO

/****** Object: Table [dbo].[tcsINVTB00026_AttribAsgn] Script Date:...

drew.allen (6/8/2011)

---

Are these columns NULLABLE? Do they have...

iTS A UNIQUE NON CLUSTERED INDEX

The index key columns are

attribgroup asc char (21)

itemattrib asc char (21)

seqnumber asc int

Non key columns to include...

I tried running this query (dummy value- 'ABCD1') :-

Insert into dbo.tcsINVTB00026_AttribAsgn(ITEMNMBR) values ('ABCD1')

And it worked fine ...( 1 row affected)

Regards,

Sushant

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I tried changing in both...

same error

The only problem i guess is that the client components are installed after the sp2/sp3 installation..

Look out this forum...it should help u:--

http://www.sqlservercentral.com/Forums/Topic353013-146-1.aspx

Regards,

Sushant

This issue happens when you RD into server or sql locally?

Check both cases

wat edition of sql server are you having,, imean enterprise/express/..?

I guess u hit the bull's eye...because I checked my...

It can be a case of sp4 not applied properly..

When we apply sp4 it asks for the areas to which it should apply...

If u can remember were all areas selected?

Regards,

Sushant

on the dev server :-

kernel memory (k):-

total 321692

paged 121144

Non paged 200548

Regards,

Sushant

Nice article...