Please .......Pleaseeeeee

Reply Please ........................

Thanks For Reply ...

I noticed that ... Not because of DELETE SCAN the Execution is SLOW ..I have some Different problem with Query ...

The Problem is like ..

Hi , I...

Hi , I am trying to Delete a record for table using one Specific Column ..

It takes large amount of Execution time .. I noticed that because of the referenial...

Hi GSquared ,

can you please tell How can i use Forcing index ...

some example please

thanks

PK_tab3_7-nonclustered, unique, primary key located on PRIMARY col4

is typing mistake -

PK_tab3-nonclustered, unique, primary key located on PRIMARY col4 is correct one ...

Here is the script file , table def , and indexes .. I modifed the actual table names,col names .. pls go through this .. Please let me know...

Thanks a Lot Matt,

I miss that Uncomment Part .. thanks It working ..

Thanks Matt ..

Yeah ! i want to execute all the objects with NULL .. the thing i want to do this is "TO check Runtime Errors "

your Script...

Thanks

Thanks for Script ..

I am very sorry to Bug you again and agian .. Actually I don't have Clear idea what i need Extractly ..

Please Can You...

It gives the table list which uses the Specific Column ..

But , It's not Listed any storeprocedures or Function or Views ..

Is anything else we need to add...

Does n't works in 2000...

What is equivalent to OBJECT_name in 2000

I can use this .. Right

But the Problems is .. Gives Error in 2000

SELECT Name, create_date,modify_date

FROM sys.procedures

WHERE OBJECT_DEFINITION(object_id) LIKE '%CDRMaster%'

AND OBJECT_DEFINITION(object_id) LIKE '%CDRID%'

Thanks ..

If you don't mind .. Can you tell me

Script to List of the Objects that uses a Specific Column name

Sorry for that , i can't post Actual code , i changed / replaced using F3 , any way ..

PortType1, PortType2 , PortType3 from @ltabel

insert into @returnInfo

select...