I have used perfmon and added parameter for mssql/instancename --> memory manager --> total memory

it shows 1620352/1024/2024 = 1.54 GB.

when I have 8 GB available at a time.

I am right...

sorry this one is not required by them.......i misunderstand

I think he need third column as computed column.

like if the value column has value '10'

then he need some computation on value '10' and save it to third column.

example:

CREATE...

I have check with string of 11350 characters and its work fine...............

I cant consider what is problem with you.

why to do so many homework.........(creating tamp table take value in it then copy)

you simply select @variablename (As previously I have given )

and then take it to text editor.........

Hi Gila Monster,

Hi one thing i have noted.....

your selection for new photograph in your profile is good one.

Hi,

As per your instruction i have updated my installation with Sp3.

Now i running with following version (instead of previously mentioned/old one.)

select @@version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)...

Hi,

I am running

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT...

please note that this msg is previously before running repair option.

Hi I et following msg:

DBBC MSG:

'

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (1:42063) in object ID 485576768, index ID 1, partition ID 72057594039173120,...

I think another solution...................

select @sql

instead of print @sql.................

It will gives all characters in single line............................

Ok. fine

this link is helpful.

My company is using sql server 2005 If i go with 2005 I have to take 3 exams.

when using sql server 2008 I have...

Ok.thanks ....

after all it is good to write accurate and small queries for better performance.

I have make one Sp which takes load of 2 million records that is not daily...

I think intent exclusive lock means some has locked table for DML and the process of DML is high.

So another user are not capable to DML on same table.

Now please...

Actually I get this problem previous day.

I have seen the LCK_M_IX from profiler and get that it is intent lock but cant get how to resolve that

can I know which...