Try this:

where col1 like 'abc'def'

or

where col1 like '%abc'def%'

Jagan

Try Log Explorer from  Lumigent Technologies.

Jagan 

01. Select All Stored Procedures

02. Right Click, All Tasks, Generate SQL

03. Find and replace xxx_ori to xxx

04. Delete all the Stored Procedures

05. Execute the modified script from QA

Jagan

USE

master

GO

select

'Select '''+name+''' ,name, size*8/1024

from '

+name+

This Query gave me the Process and I killed the same which resolved my problem

SELECT spid, waittime, lastwaittype, waitresource

FROM master..sysprocesses

WHERE waittime > 10000

AND spid > 50

Thanks

I am not able to find any link from MS website regarding any benchmark results for both SQL 2000 & 2005 Indexed Views since they are talking big about it.

I am only asking if there are any standard statistics available handy with the group since I am not in a position to do this testing because of time.

I want some rough timings for all the four operations. For example if I run Select/Insert/Update.Delete Query on the original Table and if it takes 1 Hour to Run that...

BINGO.. Here is the DSQL which did my JOB:

USE master

GO

select 'ALTER DATABASE '+ name + ' MODIFY FILE  ( name = ' +name+'_Log, FILEGROWTH = 100MB)'  

from master..sysdatabases

where (name like...

Friends,

I got out of this error by creating a INSTEAD OF INSERT TRIGGER.

Thanks

I am using SQL2000. All Check Constraints are correct. I have PK with 3 columns and the check constraint is the 3rd column. I have specified all the columns in...

Can You explain what is presentation format ?

Jagan

We have to use VARCHAR instead of Datetime.

SELECT GETDATE(),

  CONVERT(datetime, GETDATE(), 101)

This has no effect on output

SELECT GETDATE(),

  CONVERT(VARCHAR(20), GETDATE(), 101)

Giving the exact output.

I am trying the same in this way which fails.

SELECT GETDATE(),

  CONVERT(datetime, GETDATE(), 101)

Thanks All

Jagan

Extract_Date+Order_No+Line_No is the PK but Extract_Date is the only Check Consraint. All Columns in all the Tables are part of view with UNION ALL.