Thanks for the link..

Thank you..:)

I use dbcc loginfo('database')

to see the status...

i want to see vlf status....

Thanks..

ya i am taking log backups too..

I know shrinking is a bad practice...but the log files have grown tooo much..i need to get the space free... I have seen gail's link too...while i am doing it...

what all i need is left outer join ...

Thanks..

No, i tried checking the code and replaced "where"

Worked out...

thanks..

Now it's successful... i repalced 'and ' with 'where'

It worked...

thanks..

If i do normal inner join removing the left outer join , the query runs good...

what might be the problem?

Left outer join is failing..

And giving the error:

Conversion failed when converting the varchar value 'No ...

left outer join is getting the error..

m.acctid(PK,int,not null)

m.MPLMerchantNumber(char,null)

m.MPLStoreNumber(char,null)

m.MPLRegisterNumber(char,null)

c.lutdescription(char,null)

m.MPLMerchantLevel(int,null)

m.parent01aid(int,null)

m.parent02aid(int,null)

a.AddressType(char,null)

a.addressline1(varchar,null)

a.addressline2(varchar,null)

a.POBox(varchar,null)

a.city(varchar,null)

a.StateorProvince(char,null),

a.Country(char,null),

a.postalcode(char,null)

c.lutid(pk,char,not null)

Thanks...

i am trying to run the following script...

Select m.acctid, m.MPLMerchantNumber, m.MPLStoreNumber,

m.MPLRegisterNumber,

c.lutdescription,

...