are you doing this for log shipping ?

script out the backup and post here.

second what Msg Id, Severity, Error Message you got in error message

Your message doesnt show any thing bad here.

See the sql error log at the time when backup got failed . if you didnt get any thing there.again try to...

yes you can create

Also check the exec plan to see how indexes are playing there.

try where a.CONO = 10 and c.Branch= 43

You mean to say Key Lookup ?

But why ? , Did you get stuck somewhere ?

It will work perfectly for your...

Try to use this

CREATE FUNCTION GPDivNErr(@Val1 float, @Val2 float)

RETURNS float

AS

BEGIN

DECLARE @MyVal FLOAT

IF @Val2=0

SELECT @MyVal = 0

ELSE

SELECT @MyVal = @Val1/@Val2

RETURN @MyVal

END

--select dbo.GPDivNErr(2,2)

google it , you will get good and satisfactory link/details about it

sk.sarim (5/10/2010)

---

[font="Courier New"]I think U R using a view to query ur results.

while creating a view use nolock in ur create view statement, and then try it. for ex:

CREATE VIEW...

Well it depends. 🙂 . Better to test Vladan's query with heavy data volume on...

try to use WITH RECOMPLIE option with SP.might be OFF exec paln be reason of slowness

back up and job wil run in two different trnsactions so there would be no conflict but i am not sure that if backup is ON and job get...