There could be two reasons for deleting problem:

1. SET IMPLICIT_TRANSACTIONS { ON | OFF } setting in set to "on" and you are not commiting the transaction

2. You are...

Or in query analyzer you can select "result in text" option to show full field value....

Cheers,

Prakash

This is the best book for the purpose.....

No other book covers the topics that well as covered here......

I would say I liked this book as it solves a lot of...

DBCC LOG

This command is used to view the transaction log for the specified database.

Syntax:

DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

where:

dbid or dbname - Enter either the dbid or the name...

Try doing dbcc checktable or dbcc reindex on 844530042 object_id......

Well I don't know what is the equilent commands in sql6.5....

Now copy it I think it should work.......

Cheers,

Prakash

Well it was simple now the question is there is any limitation of using exec method?????

DECLARE

@abc VARCHAR(8000),

@ABCD VARCHAR(8000),

@ABCDE VARCHAR(8000),

@ABCDEF VARCHAR(8000)

SET @abc = 'SELECT '

SET...

If you wanna do it programatically then use this to get all procedure names

select name from sysobjects where xtype = 'p'

now get the procedure definition from syscomments table

Cheers,

Prakash

log explorer is the one tool can help in that

or

I don't remember offhand but there is a undocumented dbcc command to see transaction log you can use that.

Cheers,

Prakash

Confused, can you explain what exactly are you trying?

Finding newly added records or for each combination of (fld1 + fld2 + fld3) latest records........

Cheers,

Prakash

Select the execution plans that will show on which table scan is happening........

Cheers,

Prakash

A different thought.....

Apprently there is not much can be done but if you follow this method performance will certainly improve......

SP_PH_WHO2

SELECT

FIELD1 + FIELD3 + FIELD3 AS COMB_FIELDS,

FIELD1,

FIELD3,

FIELD3,

TRANS_DATE

INTO...

try this command.....

DBCC DBREINDEX (authors, '', 70)

it will reindex the data on clustered index with fill factor

One more thing even problem exists then

run dbcc showcontig statement on that...

Hi Karthik,

Well table sizes vary from 2 GB to 9 GB and as one stored procedure is accessing two three tables and putting them in temp tables and process the...

Thanks Thanks Thanks you all......

sjcsystems,

Yes we are talking with microsoft but before implementing it we need to test this scnerio for proof of concept. It's our company product Flexcube information...

do you have clustered index on it? if yes than did u recreated clustered index after loading data?

any field is having data type as text or image?

did u run dbcc...