Thanks Grant .. I will check it out

Thanks for reply .

is there any chance to replace charindex function.

The SP which I run is

exec Proc_GetCRFActivityStatusReport_BABE ',0000001611,0000001637,0000001460,0000001461,0000001747,0000001751,0000001445,0000001748,0000001877,0000001922,','',',TL11-00012,AH11-00514,TL10-00003,TL10-00004,PA11-00003,SU11-00032,TL10-00001,NA11-00020,SU11-00008,PA11-00001,PA11-00002,SU11-00009,NA12-00001,TL10-00002,SU11-00033,PA11-00005,TL10-00005,AH11-00518,TL11-00013,TL11-00014,AH11-00562,TL10-00006,PA11-00013,SU11-00034,NA12-00002,SU11-00010,SU11-00035,PA11-00014,TL11-00001,AH11-00563,TL11-00017,TL11-00018,AH11-00564,TL11-00002,PA11-00015,SU11-00036,SU11-00037,PA11-00018,TL11-00003,AH11-00565,TL11-00022,TL11-00023,AH11-00566,TL11-00004,PA11-00019,SU11-00084,SU11-00085,PA11-00020,TL11-00005,AH11-00567,TL11-00083,TL11-00085,AH11-00568,TL11-00006,SU11-00086,TL11-00007,AH11-00569,TL11-00092,TL11-00093,AH11-00571,TL11-00008,TL11-00009,AH11-00572,TL11-00094,TL11-00095,AH11-00604,TL11-00010,TL11-00011,AH11-00802,TL11-00103,TL11-00104,AH11-01349,AH11-01559,TL11-00105,TL11-00027,TL11-00028,TL11-00029,TL11-00030,TL11-00031,TL11-00033,TL11-00034,','','','Y','',''

...

In execution plan I can see Hatsh Match

is taking 35% (which is...

yes..

Backup log dbname to disk ='path' with norecovery

can u please explain how ?

because for excel 2007 ,row limit is...

GilaMonster (12/13/2012)

DBCC ShrinkFile. There's no other way (other than copying the data to a new DB and dropping the old one)

Let...

good question to learn .I got it wrong,

test it after on 2000 box its showing error in insert statement..

I really need to upgrade servers 😉

Hi Steve,

Restore Verifyonly will tell you whether backup file is valid or not ,so no doubt its best option to check whether your backup files are restorable or not...

telnet serverIP 1433

you are migrating database to which version?

You planning for in-place or side by side up-gradation ?

Just keep in mind few steps

Run upgrade adviser to check for...

declare @txt varchar (50)= 'Sett_FY_Mast_2012'

select stuff(@txt,8,0,'_Pooled')

How to modify SP name in Alter Proc script ?

1) Distributor_admin -

Replication Linked server login ,created while configuring Replication

2) Excelserver

Its User login ,asked who created it .

3)...

without DDL and Execution plan its difficult to say anything.

but still check the Estimated Cost in execution plan.

Run both the queries in single batch and compare execution plan

check which query...

please don't stop posting your questions..

Just follow some rules ..People are happy to help you here

Don't take anything Personally 🙂

Please Post both the queries along with the table structure and execution plan .. it will be more helpfull