I had aproblem that i have solved but did to know why that problem occurred.
I have two servers with the same database stored on them seperately. I also had asp pages pulling information from these pages.
I also had store procedures used within the database and my asp pages. When i pull results out of the pages one of the server with the same database pulls the same information from the database but in different order.
1. Is it because i order by the id which is auto increment.
2. Is it because i took a back up from one of the server and restored it on another server. will that make a auto increment different.
Thanks
Stephen
I have two servers with the same database stored on them seperately. I also had asp pages pulling information from these pages.
I also had store procedures used within the database and my asp pages. When i pull results out of the pages one of the server with the same database pulls the same information from the database but in different order.
1. Is it because i order by the id which is auto increment.
2. Is it because i took a back up from one of the server and restored it on another server. will that make a auto increment different.
Thanks
Stephen