I have a database created in SQL Server 2014 x64 express edition with SSMS 2014 and have some table in the database. I backup the database with this tsql
BACKUP DATABASE dbFile
TO DISK='D:\dbFile_170125.bak' WITH FORMAT;
In other computer, i have SQL Server 2016 x64 express edition with SSMS 2016. I create new database, then i restore database from file "dbFile_170125.bak" with replace option. The restore is success.
The problem is when i expand the Tables in Object Explorer in SSMS 2016, it show error :
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (Microsoft SQL Server, Error:512)
In SSMS 2014, there is no problem like that. Perhaps someone can help me. Thanks.