Could it be the double-hop issue?

John

Don't do this. It just wastes resources and causes fragmentation. If your log files are getting large, then back up your transaction log more frequently. Bear in...

What you're seeing is a cardinality error, and it's why you should be careful when using the UPDATE...FROM syntax. It occurs when the value you're updating in table a...

Search for "managing transaction logs". There's loads of stuff out there.

To add...

BWFC (6/18/2014)

---

I disagree there. It doesn't say that all on site databases are 2012, it says that uses 2012. That doesn't preclude there being 2000...

Precisely. All on-site databases are 2012, meaning 2000 can't be the answer. And since an Azure...

Well, the best way to find out is to try it!

John

IF NOT EXISTS (

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME = 'USA_RFORIGEM '

AND TABLE_NAME = 'CONFIGURACAO'

)

ALTER...

Sean Lange (6/16/2014)

---

It is only a game but at the level we are talking about it has serious financial implications to the nations involved. I too really dislike the attitude...

Yes, he has had some pretty barmy ideas in the past,...

You can set up your own auditing on your database, for example using triggers to write to audit tables whenever any changes are made to data in any tables. ...

If you don't have any auditing set up then you're not going to be able to find out much. For DDL changes, you can try the default trace.

If you...

Probably not - it's not something that SQL Server controls. You'd be better off speaking to your AD administrator.

John

Then you'll need to explain your requirement better, please. Perhaps you could post some sample data and expected results based on that data?

Thanks

John

If all you're trying to do is return the whole result set in pages of @PageSize rows, just remove the PARTITION BY clause from your ROW_NUMBER function.

John