All are backups are done via maintenace plans and the files have the format of

<dbname><yearmonthday><hourminutesecond>.BAK. 

I am using sp_start_job to use the maintenance plan backup.

Steve

Thanks for the input.  I am trying to create a stored procedure to restore a database under a new name using the last backup.  I need to access that information...

OK I wrote a function that returns the information.  Thanks to my colleague the trick was OPENROWSET.

Here is the function

CREATE FUNCTION dbo.FN_JobCurrentExecutionStatus  (@jobname sysname)

RETURNS int

/***********************************************************************************************************

Purpose: This function returns the current_execution_status

  The results...

OK I changed my script and received these results, which I think indicate that the UNION has less Logical reads.  HMMM?

Always learning...

Steve

Select a.[ID],...

I created the following script

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLEA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TABLEA]

GO

CREATE TABLE [dbo].[TABLEA] (

 [ID] [int] NOT NULL

) ON [PRIMARY]

GO

ALTER...

Could you post the explanation of why left Joins is better than UNION?

Thanks

Always learning,

Steve

Thanks for the help.  Perhaps I wasn't clear...

I have restored the master from the cluster at home to the recovery server replacing master.  So the paths for master and error...

Could you give me an example of the subquery?

Thanks for all the good information (and congratulations on 150!)

How does one turn it off?

Steve

What is the point of a trick question?

or should I say

What is NOT the point?

Here is what I am doing.  I am creating a job that will backup the log of two databases (A and B) and do a complete backups.  When these complete successfully I...

OK I tried creating a table but sp_help_job must create a table wothin the procedure because I am getting "An INSERT EXEC statement cannot be nested".

So let me ask my...

Yes, I would agree that documented outcomes that are not expected are not a bug.  It might be nice if a message could warn the poor coder that this is happening. ...

I would like any emails to be sent to the DBA on call.  So, I Thought if I created an email group that contained the name of this week's DBA...

Jonathan

I am looking at your SP and trying to understand it. Is there any documentation on spt_values? I can't seem to find it in BOL.