Thanks Greg Charles,

for your alternative suggestion, Now /!x /!c works in my case

Output is same in both the solution.

Regards

Shashi Kant chauhan

Thanks to both of you,

The first reply is only applicable when you use the name as an unencrypted form...

The second reply i check and tried before my testing but i...

Try through using CUI not through GUI

ex.

Alter Table Person

Alter Column Person_Add nVarchar(100) not null

in my example Person_add is having a datatype varchar(100)

so i modify it

regards

shashi kant chauhan

Hi Lynn Pettis

the same post i sended with the different name.

I even tried it but not succeded, so any budy have some other alternative to achive the same task...

CREATE TABLE [ReserveStock] (

 [DeptMainCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [DeptSubCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [TitleId] [int] NOT NULL ,

 [DateofEntry] [datetime] NOT NULL ,

 [COId] [int] NOT NULL ,

 [OpeningReserveStock]...

no dear

i am not using any trigger in this table.

i got the solution from Ist reply

thanx for reminding me for the trigger

thanx perter larsson

for your valuable solution

i got the result as no of rows get effected using this upper case /lower case

but please describe more about why case sensitive collation occurs..

regards...

       AND [dateentered] BETWEEN ((YEAR([dateentered]) = 2006

                                   AND MONTH([dateentered]) = 12

                                   AND DAY([dateentered]) = 12)

                                  AND (YEAR([dateentered]) = 2007

                                       AND MONTH([dateentered]) = 12

                                       AND DAY([dateentered])...

Hi Mathew Leigh

I try your problem

but i don't face any such order by problem , as i do the following test

create view shashi as

select top 10 Persent *...

Hi Srivathsani ,

It is very good article u send about log file , this tool is good i already used it.

for checking the log . Is there any other tool...

Andy,

Excellent Article by u ,

But how to overcome or increase the maximum size of row ??

Regards,

shashi kant

Thanx for This Valuable SP

I got the Result i Needed , Is This sp works for the sql server 2005....

regards

shashi kant

Try this  .............

Select DISTINCT

A.CompanyName

FROM Leads A ,  dbo.LeadBase B 

where LTRIM(RTRIM(ISNULL(A.CompanyName,'-'))) = LTRIM(RTRIM(ISNULL(C.CompanyName,'-')))

check it how many rows u got......

thanx David Burrows

i got the same result which I needed....

thanks

GilaMonster 

your suggestion is great and i check this. i clear my doubt so i can say 100% to some one about...