my new job work fine.

this particulare job give us a error, there is any way we find out the cause of this error

My job was working fine with svcAdm account, but today I got the error with same account

Thanks Muthukkumaran,

what can I do now, link didn't give me any information

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790:...

An exception occurred while executing a Transact-SQL statement or batch.

Thanks, I will try.

hi,

Thanks for the reply, i have to run this for 20 db's, and create a .txt file

use Dynamics

DBCC Checkdb

use Dynamics

DBCC CheckCatalog

print 'Finished Dynamics'

----

use INTL

DBCC Checkdb

use INTL

DBCC CheckCatalog

print 'Finished...

Thanks for the replay, i already have a group and every one receving an email, but my question is how to send a auto email when job is start, when...

I am a numeric filed,

column I want to change to time

0 ...

Thanks, but there is any other script to get only particular index dependence

Hi Thansk for help,

I am still getting following error

I am getting following error, when I pick up the option initinalize

The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.

Hi I am getting following error, when I pick up the option initinalize

The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.

How to run the log reader

hi I recreate the subscriber with initianilaze, now I am getting following error

The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.

also when I check the properties of Subscriber...

No, do I have to initialize that, I restore the last night data and just create a subscriber with out initialize.