Thanx for the help and support.

from

killer

Hi faisal,

For checking the real error excute

dbcc checktable(tablename)

dbcc checkalloc

hope this help u

from

killer

Hi Faisal,

Why u are using reindexing on nightly basis.Dont u know it use too much of process.

This type of error occurs When creating a high level index structure, Adaptive Server...

Hi,

As i described in my question the replication takes too much of process so i do try it.

But yes our problem sloved.

The process we applied need too much of maintinance

(1)...

Hi Julian,

Firstly u cannot use cast function like this as u have written.

Error expected As with cast

I need the execiution time of a query.Means when we execute a query in...

Hi Remi,

Why to refresh or restart.As i know i had delated the record from the sysobject and when we execute anl dml command regarding table then it checks in the...

Hi Chris,

Thanx for ur reply.

I modified and used in the process

Declare @StartQueryTime varchar(10)

Declare @EndQueryTime varchar(10)

SELECT @StartQueryTime= LTRIM(STR(DATEPART(hour, GETDATE()))) + ':' +

  LTRIM(STR(DATEPART(minute, GETDATE()))) + ':' +

  LTRIM(STR(DATEPART(second, GETDATE())))

Print @StartQueryTime

exec...

Hi,

Becareful to kill that spid that is in use

kill spid number

-------------

when u use shrink database then no user should be connected on that database.This error comes when the tables are in...

Hi Tim,

Select * into work with table

i needed with stored procedure . This help me in keeping old data copied from dbcc and extended stored procedure.

Again thanx to neol and...

Hi,

Very difficult to answer. no clue about this.

Hope this help u.

from

Killer

Hi,

Do the user by which u are running ur replication has access on that table.

hope this help

from

killer

Hi,

Ok, I will try from that but dont we another option i mean from sql server only.

Or some other way that can make my dts easy.

from

killer

Hi,

Thanks .

My tables are updated daily and we dont know what row has been updated.

so i tranfer all the records and the tables script also.

My problem is transfering the files...

HI,

Check the username permission on Ingres.

and start ur job under log on services account permisson

hope this helps u.

Killer

Hi,

use data driven query that will help u.

Hope it helps u.

from

killer