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?

So the script was something along the lines of this :

SELECT 'DROP TABLE [' + USER_NAME(uid) + '].[' + Name + ']' AS DropCMD FROM dbo.SysObjects WHERE XType =...

HTH.

Good night.

Nah, I'm more of a Bon Jovi fan .