I removed my reply as it was a bad recommendation by me. I misunderstood the MS engineer.

What is the status of the replication jobs? Are they executing or in failure? What does replication monitor show?

I realize that ROUND has solved your immediate issue, however make sure you understand the float data type.

The problem is with how it's stored.

That's the problem with float data type, it's just an approximation. If you want 1.25, then use decimal data type.

Or use @execute_query_database.

SELECT Name FROM YourDatabaseNameGoesHere.dbo.users

You should consider READ_COMMITTED_SNAPSHOT isolation level as well as moving your reports to a different server that gets replicated to.

If you want additional help, please post your queries...

There are lots of benefits and lots of drawbacks to it.

Here's some that I think of:

Pros:

1. Database maintenance per database will run faster against each database as there's...

You can query sp_databases for that information.

TheSQLGuru (8/5/2010)

---

I don't think it is bad code. Works fine to accomplish the objective. You may argue with the...

GilaMonster (8/4/2010)

---

Tara Kizer (8/4/2010)

---

That is only true when you pass from no rows to more than 0.

Then after the first 500 and finally when around 20% plus 500 modifications have...

The Microsoft engineer directed me to this article, which discusses the inner workings: http://msdn.microsoft.com/en-us/library/dd535534(SQL.100).aspx

I haven't read it yet.

So I was able to get a hold of Microsoft regarding this and here's what I got back:

That is only true when you pass from no rows to more than...

That is some bad code then. 😉