Can't auto or manual backup sql.When open networker module for sql,get some error:The objects "master.sys.databases" and "master..sysdatabases" in the FROM clause have the same exposed names. Use correlation names to distinguish them.(Translated from Chinese)
I found the error is for my sql 2008 can't run the query:
SELECT master..sysdatabases.name, master..sysdatabases.status FROM master..sysdatabases INNER JOIN master.sys.databases ON master..sysdatabases.name = master.sys.databases.name WHERE source_database_id is NULL
BSequeira
30 Posts
547
0
Posted February 20th, 2010 04:00
Hi,
This issue is fixed in NMSQL 5.2 sp1 build 320 and higher. (latest 334)
After the upgrade, the error will go away.
Hope this helps.
Regards
Bruno