Activity overview
Latest activity by ptracey
OK, I have solved the problem. My database was in SQL 2000 compatibility mode. This was intentional, due to some non-ANSI joins, but I had forgotten. I would still have expected this tool to recognise this fact and generate a working script, or at least alert me to this, but, anyway, problem solved.
P / comments
OK, I have solved the problem. My database was in SQL 2000 compatibility mode. This was intentional, due to some non-ANSI joins, but I had forgotten. I would still have expected this tool to recogn...
Smart Rename - Schema change error
I am using the smart rename feature. It works fine until I try and change the schema for a table.
It generates code like:EXEC sp_changeobjectowner N'[dbo].[FRED]',N'NewSchema'
but...