Viewing 15 posts - 196 through 210 (of 782 total)
Don Urquhart (6/10/2011)
June 10, 2011 at 1:44 pm
ALZDBA (6/9/2011)
Please post the full ddl of your object tcsINVTB00026_AttribAsgn(i.e. script its create statement including all indexes and constraints )
USE [RTW]
GO
/****** Object: Table [dbo].[tcsINVTB00026_AttribAsgn] Script Date:...
June 9, 2011 at 7:28 am
drew.allen (6/8/2011)
SKYBVI (6/8/2011)
The index key columns areattribgroup asc char (21)
itemattrib asc char (21)
seqnumber asc int
Are these columns NULLABLE? Do they have...
June 9, 2011 at 7:26 am
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...
June 8, 2011 at 2:22 pm
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
June 8, 2011 at 1:50 pm
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
June 8, 2011 at 8:14 am
drew.allen (6/7/2011)
Did you change this in the main query or the subquery? Changing this in the subquery won't have any real effect on the outcome.Drew
I tried changing in both...
June 7, 2011 at 2:48 pm
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
June 3, 2011 at 9:29 am
This issue happens when you RD into server or sql locally?
Check both cases
June 3, 2011 at 8:43 am
wat edition of sql server are you having,, imean enterprise/express/..?
June 3, 2011 at 8:28 am
forsqlserver (6/2/2011)
Dear Sushant,Ypur paged memory is 120 MB Please increase it upto 170 MB then u will not face this error.
I guess u hit the bull's eye...because I checked my...
June 3, 2011 at 7:49 am
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
June 3, 2011 at 7:46 am
on the dev server :-
kernel memory (k):-
total 321692
paged 121144
Non paged 200548
Regards,
Sushant
June 2, 2011 at 7:46 am
forsqlserver (6/1/2011)
Please refer the link....for error 1130 which clearly says the dependency of 160 MB of paged memory if server is 2003.
June 2, 2011 at 7:33 am
Viewing 15 posts - 196 through 210 (of 782 total)