Any update from anyone ??

Thanks Jack.

Can someone provide some info here (i.e.) How to convert OLDER OUTER JOIN to NEWER OUTER JOIN

Can someone please me know :

(1) Is there any utility where we can...

Thanks a lot Lowell .

fyi..

The server measures duration in microseconds.

set @bigintfilter = 15000000

FYI...

1) DELETE index_time

WHERE DumpDate < dateadd(dd, -7 getdate())

(or)

DELETE

WHERE

DumpDate <= DATEADD(day, -7, GETDATE())

2) DATEDIFF(millisecond, Startime, Endtime)

(or)

declare @start datetime, @end datetime

select @start = dateadd(mi, -12, dateadd(hh, -1,...

You hit the bird at the right spot (i.e.) no rowmodctr in SQL Server 2005.

But how is this possilbe, There should be some way where we can convert the script...

Hi Phill,

              I looked at the sql server logs, but there is nothing regarding reporting services.

But , when i saw in windows event log , i found this:

Any idea Phill.

Thanks.

Event...