This compiles OK in my QA.. but I can't test without the tables so tell me how it goes.

UPDATE tblSchedule

    SET tblSchedule.HomeScore = 14,

     tblSchedule.AwayScore = 17

FROM tblSchedule

    INNER...

Assuming the previous idea works (make sure you test first).

Script all the tables but only the clustered index.

Do a search and replace to set the new filegroup and add the...

Can you post your new version pls?

Move the clustered index into the new group... AFAIK, all the rest will follow along with it.

I can't see how it won't lock... the constraint will have to validate all the data somehow.

Maybe one workaround would be to add a unique column (like identity), add the...

Backup msdb and restore it on a developpement server (that will remain online).

I'll let you figure it out... but here's the main problem :

UPDATE Sched SET Sched.HomeScore = 14...

FROM dbo.TblSchedule Sched INNER JOIN ....

The rest seems ok.  The only thing I'd...

NP.

Even better to solve it at work .

Never heard that one... what does it mean?

You've already had your answer here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=390201

Please do not cross-post, we monitor all questions all the time.

Maybe...

So you'd run a select in a view, then select * from vwRowcount after that instead of SET @@ROWCOUNT??

If you run the view, you'll notice that @@rowcount is populated only...

Ya the old if it ain't broke, don't fix it .

Thanks for the follow up.

Hai .

So how did you solve the problem?