Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deal2easy
Starting Member
2 Posts |
 Posted - 2011-11-08 : 10:16:46
|
| I have a database in sql server 2005. I took a backup and restored in a different 2008 server, to check the compatibility issues.To my horror, I found that some of the stored procedures have varying output between 2005 and 2008.For example, if I have 100,000 rows in 2005 server, when I run the same SP in 2008 server, I get 80,0000 rows.Can anyone tell me a way to figure out the differences and to find where is the difference coming from? |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-09 : 03:33:28
|
| are you sure tables on both databases are identical (same data)? |
 |
|
|
deal2easy
Starting Member
2 Posts |
Posted - 2011-11-09 : 10:07:57
|
quote:
Originally posted by vikki.seth
are you sure tables on both databases are identical (same data)?
I think, you got me wrong. I take a SP and run in the 2005 & 2008. The result should be the same on both the servers, right. But, I get 100,000 rows for the 2005 server and 80,000 rows for the 2008 server.I want to know a way, how to figure this out. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-09 : 10:20:22
|
| Are the collations the same - I would expect th enew server to have more rows if that was the issue (and the old was correct).Is anything date dependent.Are errors being trapped and handled correctly?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
comparing the output in 2005 and 2008 servers