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 |
|
leeorp
Starting Member
4 Posts |
 Posted - 2013-12-29 : 12:28:09
|
| Hi, I recovered database created on SQL server 2005 in to SQL 2012 server.Then i created a link server between the SLQ 2005 and the database on the SQL 2012.while checking the link server i found that i can not see the tables from the recovered database on the SQL 2012, bu i can see al the tables from the databases created on the SQL 2012.Please advise.....sincerely Leeor Petrover |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-29 : 12:45:30
|
| did you created a mapped login? what all access it has on SQL 2005 instance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-29 : 12:45:31
|
| did you created a mapped login? what all access it has on SQL 2005 instance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
leeorp
Starting Member
4 Posts |
Posted - 2013-12-29 : 13:07:25
|
Yep, This is not the problem.I can not see any tables from databases i restored from SQL2005 into SQL 2012.quote:
Originally posted by visakh16
did you created a mapped login? what all access it has on SQL 2005 instance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
sincerely Leeor Petrover |
|
|
|
|
|
|
Link server between 2005 and 2012