Microsoft SQL Server Hosting : MSSQL/Great Plains using DEX_ROW_ID to sort

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by monicas 0n 20 April 2009

We are using MSSQL to manage different systems, we use the input from Great Plains and then we post some information to other systems.

I started having some problems and we post a big invoice, the order was not correct. If I print the invoice the order was the correct one but if I open the MSSQL table, the order was not correct. After several test I found that if I sort using DEX_ROW_ID, I’ll get the order order. Is this correct?

What is the best way to sort the table in base of the time when the row was created?

Learn more Microsoft SQL Server databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting