Yes GilaMonster..

I removed that check from repair minor error option as u said..

Now it works properly..

Thank u sir..

I have checked by using above dbcc command & it works fine..

And I also ran the job by writing the result in a file. then it shows the below result..

********************************************

Job...

I execute the command given by u. It gives me below message..

Volume in drive C has no label.

Volume Serial Number is 58F8-2401

Directory of C:\WINNT\system32

03/26/2008 01:53a ...

When I checked Application logs in Event viewer, it shows me below error message.

18210

BackupMedium::ReportIoError: write failure on backup device 'M:\Database backup\Walker_vendorData\Walkers_vendorData_200408.bak'. Operating system error 112(There is not enough space on...

hi,

I just replaced xptar.dll with existing one.

It solved my problem.

Thanks for help..

Regards

Majid jafar

Yes dear,

it's possible.

I deleted as u said.

Thanks a lot..

Regards

Majid Jafar

ok..ok..

got it..

I will use DBCC dbreindex once a week..

Thanks a lot Gail for guidance.

If dbcc dbreindex rebuilds indexes also defragment the data then is it necessary to use DBCC INDEXDEFRAG ?

If I am using DBCC INDEXDEFRAG & after that dbcc dbreindex then is...

For rebuilding indexing I used DBCC DBREINDEX and for defragmentation DBCC INDEXDEFRAG

Is it necessary to use both commands or just using DBCC DBREINDEX i can do reindexing as well as...

where could I found the script & what it contains..

plz give me path or script.

Regards

Majid

By mistake,

I place this message in SQL 2005 forum.

Actually my server is SQL server 2000 Enteprise edition.

So my query is about to SQL server 2000 databases..

yes u r right..

I am trying to save stored proc of wrbeta owner login using walkers login.

Is it possible to update & save stored proc with different login.

If yes plz...

Actually stored procedure has been created with wrbeta login name(ownership).

But I have register/logged to database server using walkers.

Right now I m trying to change stored proc & at the...

Yes we r taking backup .

Right now I have full backup of last Sunday

Differential backup of todays morning and current log backup.

What is meaning of ''Then import the original...

Yes jeff.

U are right.

I use the same query & again I face same the problem.

Acually I m updating few(245 records) records on 'X' database which is on one server...