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 |
|
jazzgilbert
Starting Member
2 Posts |
 Posted - 2010-09-13 : 13:51:53
|
| We have a SQL 2000 database, Microsoft CRM, which has a view built in. I can select from that view and get records no problem from SQL Enterprise Manager on the server (SQL 2000) that hosts the database. I'm running the SQL 2008 tools on my workstation, and when I try to select from that view (even if I do select *) it runs, but returns no records. No errors either. I'm pretty sure I've ruled out permissions - I created a SQL user and kept bumping up the permissions until finally my reports account has full DB Admin rights.Any ideas here? I'm guessing it's a compatibility issue going from 2000 to 2008 issue, but don't have a 2000 client I could test from. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-09-13 : 13:58:52
|
What do you mean by SQL 2008 tools? Is it Management Studio?Be sure to connect the right server. Maybe you are connecting to a test environment or something else where is no data for the view?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
jazzgilbert
Starting Member
2 Posts |
Posted - 2010-09-13 : 15:02:03
|
| Thanks for the response.Yes, I've got the SQL 2008 Management Tools installed, so yeah, Mgmt Studio. Definitely connected to the right database - had to create a user specific for this project, and my report project couldn't access the db until I plugged in the new user creds. |
|
|
|
|
|
|
SQL 2000 view returns no records from SQL 2008