by the way, i also had the same job failure, but the job was working correctly before this

the problem that i discover that the server lost the comunication with out Domain...

you have to empty Log (as I think).. because If the Log is Full, there is no message will appear

First it is recommended to make backup due to your Insertion and...

what about making a Job on SQL Server that work when it starts .. and put on it the logic you want?

I don't see a problem in setting this option before calling your SP and then setting it to its default again

my question is : why you want to change...

you can insert/Change your values into the idenity column of a table by setting the IDENTITY_INSERT option ON

to make Idenity return again, set the IDENTITY_INSERT option OFF

note: I think...

also install SQL Server 2000 SP3a and MDAC 2.7 SP1 on the server.

I hope this help u

to get message when Job Failed

1- go to Enterprise manager, Expand your Sever

2- Expand (Management) >> then (SQL Server Agent) >> then (Jobs)

3- double click on the job you...

you have to install SQL Server SP3a so SQL Server can work

it is recommended to First install WIndows 2003 SP1 and all Windows Update before install SQL Server DB

I hope this...

what about freeing yourself from the identity column

and use a newe table that has the last ID number .. and when you want to insert .. get Last number...

I think you have to read more about

(Instead of Insert) Triger

and put it on the view

so when you insert your data ... you check for State and the insert...

there are some known issues between SQL Server 2000 and Windows 2003 Server ... you have to make these steps to adjust your server

so what about SQL Server 7?

I recomend...

i think you have to contact microsoft itself to help you.. 

I hope one of these e-mails helps you

SQLKB@Microsoft.com

mshelp@microsoft.com

by the way, the best way to remove SQL Server is to :

1- Put your Setup CD of your SQL Server

2- make a steps as you install a new...

do u have SP3a installed ? it solve many problems with SQL Server

also install MDAC 2.7 SP1 on all clients and server machines

also, what about drop this log shipping and...

i use norton Antivirus Corporate Edition on SQL Server and it is very nice

here is some tips you may use:

I set norton Antivirus Corporate Edition NOT to scan the...