not as far as i'm aware.

but what you could do is set the idle state in SQL AGENT as below 80% for 2 minutes.

what you can then do is perform...

from books on-line

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

SQL Server Agent polls the performance counters at 20-second intervals.

Important Using a frequency higher than 20 seconds increases the processing overhead for SQL Server.

If a counter...

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...