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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-04-30 : 12:46:12
|
| We can run a query on a windows 2003 server, in sql 2005 management studio using a linked server to active directory and it will work, returns 1000 rows (which I think is a default). The same query will fail on a windows 2008 server, sql 2008 database. It gives the following message:Msg 7330, Level 16, State 2, Line 1Cannot fetch a row from OLE DB provider "ADsDSOObject" for linked server "XYZ".If I change the same query to just pull the top 901 rows, it works.Why can I pull 1000 on one server and only 901 on the other? |
|
|
dschutz
Starting Member
5 Posts |
Posted - 2009-05-15 : 14:30:01
|
| SQL 2008 only allows you to pull 1000 rows by default. Try pulling 999 rows and see if it works in 2008. |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-05-15 : 15:29:34
|
| It will pull the top 901 rows, it fails on 902 (sql 2008). It will pull 1000 on sql 2005. I've worked around it, but I would have expected it to pull 1000 on both. |
|
|
|
Robert.haack
Starting Member
2 Posts |
Posted - 2009-06-05 : 16:21:42
|
| How did you work around this issue?Thanks,R Haack |
|
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-06-16 : 12:36:55
|
| I'll have to go back and check, but I believe what we did was write several 'select' statements, filtering each 'select' statement with a 'where' clause to only pull a minimum number of records (a couple of hundred or so) and joined the individual 'select' statements together with 'union all'. |
|
|
|
|
|
|
linked server to active directory