That's your answer. There's a problem with the share, nothing to do with SQL Server. Maybe there's a firewall in front of the server? Perhaps the share...

This...

where p.DivisionCode in ('$','1','2','{','#','L','6','t','[')

and p.PSIKey in ('1','2','3','4' ,'5','6','7','8','12','13','14','15','16','17','18','19','20','21')

... is turning your outer join into an inner join. Try putting those two conditions in the join predicate instead.

John

Don't use the administrative share. Can you map a drive to \\BRANCHSERVER2\Backup?

John

Same error message?

Can you map a drive to that folder from your desktop? The (original) error message was that the network path isn't found, so I would start by...

Have you looked at the new LAG and LEAD windowing functions?

John

You're connecting to the E$ administrative share on remotesqlserve, which is only available to local admins. Assuming your Backup folder is shared as Backup, use this path:

[font="Courier New"]\\remotesqlserver\Backup\databasename.bak[/font]

John

This is the problem with scalar functions. They run once for every row. If you convert to a table valued function, you'd probably see a significant improvement in...

Have you tried explicitly specifying the server with the SourceServer parameter?

John

Make sure you read and understand this before you try anything like that.

John

I can't really visualise your package, but try looking at the properties of your precedence constraint and make sure you've got the correct "Logical AND" or "Logical OR" chosen.

John

Maybe somebody or something keeps changing the default schema so that sometimes you're looking for the procedure in the dbo schema, and sometimes you're looking for it in a different...

That sounds interesting. Do you have any further reading on...

Uwe Ricken (12/6/2013)

---

jayant-479472 (10/16/2008)

---

I think my question is little confusing, let me make it more clear

If we have a table with cluster index then by simply recreating the clustered index...

OK, fine, but what I said still stands. Did you try what I suggested?

By the way, there are much better ways of getting the first day of the month...

If you add [font="Courier New"]SELECT @dt[/font] to your code, you'll see why it's failing.

John