Viewing 15 posts - 196 through 210 (of 783 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 paste the paged memory of Dev server.Please refer the link....for error 1130 which clearly says the dependency of 160 MB of paged memory if server is 2003.
Nice article...
June 2, 2011 at 7:33 am
Viewing 15 posts - 196 through 210 (of 783 total)