what operating system are you running on ?

has this problem just recently started happening and it was fine before ? or has it been since you changed the account?

from books on-line

Before performing a log shipping role change, a maintenance plan for this log shipping pair must exist on the secondary server. A maintenance plan can be created using...

store them in a char(5) field???

i take it you want to make a change to the design of the database after you recover it, then you want to apply transactions from your old database.....?

i don't...

are there any notifications to operators on job completion/failure/success? - if so - is the exchange server available at that time?

if it's not then SQL Mail throws a wobbly can...

open up query analyzer and run the query

select @@version

make sure you run it with the output to text (not grid) and you'll see your version number

are there any other jobs running against that database ?

what size is the database? and does sp_who2 give you any info on whether there are locks ?

i agree, if your security settings aren't 100% correct you could get in real trouble with this.

but in basic form your sp would have the following

declare @strsql nvarchar(1000)

set @strsql='select...

is the database in simple or full recovery mode ? if it's full then you need to set up a transaction log backup job.

then when the t-log has been...

you can just install the client tools from the SQL CD.

although the protected item behaviour sounds similar to a problem i've seen on web servers before - user get the...

is it the database backup, or the t-log backup?

is the database in simple or full restore mode.

also

have a look as DBCC opentran to see if there are any...

use dateadd, if it's the 61st day of the year add 60 days to jan 1st

DATEADD (d ,(61-1),'01/01/2004' )

jsut remember to make sure you select the correct primary key when you link the tables (or views).

and if you do change the tables then you need to refresh...

have you run a DBCC CheckDb on the database recently ?

no problem,

but just out of interest, why are you migrating from oracle??

not that i'm biased or anything, but most oracle DBA's see SQL as a toy database (i know my...