Dear Sisi,

I checked the Statistics  it is ok as i scheduled a job for reindexing.

Also executes DBCC checkdb  so if there is so problem with database.

It is fine. no Errors.

When...

Hi,

I had not recommended to use the ip address , i had given u an example

u have to use the name of linked server.it may be ipaddress or anyother name

from

Killer

Hi Nitin ,

If u had looked into the question then u might not give me an answer as u had given me.

You need to modify boot.ini by /PAE switch

hi,

Sql listens to number of port a part from default.

It is not possible to configure sq server to listen on dynamic port numbers.

HTH

from

Killer

HI,

I use this query

insert into dbo.inventsum select *

from [172.16.0.16].aicnav.dbo.INVENTSUM h

WHERE h.recid NOT IN

   (SELECT d.recid

   FROM dbo.INVENTsum d

   )

there is not error when i execute the procedure but...

Hi,

Sorry for late reply

TO start Sql agent in yukon u can do it in the same way in sql 2000 u do.

If u are not getting the option to stat...