Also, if that insert statement is commented out, you'll never enter the WHILE loop.

Thanks, and good work 🙂

I think you need to look where your final SUM is, compared to ninja's original solution.

Hi Robin,

A standard restore would attempt to create the database files at the same paths as the original files.

You can use the WITH MOVE option in the RESTORE statement to...

Perhaps set up another job that runs at or just before the cut off time, which determines current activity & stops where necessary then disables?

You could use sp_help_jobactivity,

or a query...

You can set up an SSIS Transfer Jobs task to do this, then run it as a scheduled job or on demand as necessary.

You can also do the same for...

You could fail over to partner, change owner at mirror, fail back to principal.

Assuming you'd be allowed to do that given the disruption during fail over!

Barkingdog (12/4/2011)

1. I can't figure our for the life of me where the actual hourly snapshot job is stored in SnapManager. I want to "edit" that existing backup...

Yeah did the same myself, the prompt looked like it was expecting a machine name.

Good luck with the rest!

No, it allows you to proceed with the installation even if no users selected.

Haven't tried the workaround to add users afterwards yet.

Yeah I hit this too.

There's a workaround on MS Connect - don't add any users at install time! 🙂

Apparently you can sort the permissions for it afterwards - will lookup...

I saved time by not using the code tags 😀

Bad form by me there!

And of course if Credit_ID is nullable then they're not the same code!

Ha sorry I've just done your original function again. Home time I think!

Maybe this:

RETURN ( CASE WHEN

(SELECT COUNT(Credit_ID)

FROM

(

SELECT Credit_ID

FROM DIP.dbo.ProgramCredit

WHERE Program_ID = @ProgramID1

INTERSECT

SELECT Credit_ID

FROM DIP.dbo.ProgramCredit

WHERE Program_ID = @ProgramID2

) z

) >...

The function doesn't know the selects are only used to get a rowcount, so tries to return the results -> error.

Something like

CREATE FUNCTION dbo.CreditOverlap

(

@ProgramID1INT,

@ProgramID2INT

)

RETURNS BIT

AS

BEGIN

DECLARE @Count INT

SET @Count =...

Just to add my own version of the same code 😀

Edit: this of course being the version that doesn't work... :Whistling:

DECLARE @CurrentDatePart INT, @ThisBillingPeriodDate DATE, @ThisBillingPeriodEndDate DATE, @LastBillingPeriodDate DATE, @LastBillingPeriodEndDate...