Comments
Sort by recent activity
Hi Michelle, thanks for your response.
I'm not able to provide a database or script at this time, but it is interesting that you couldn't reproduce it with your test database. It will be worth me creating my own test database, which I would then be able to send to you if I had a problem.
However, some more information for you which could highlight where the problem may be:
- The Managed Assembly was deployed to the main database from visual studio. The EXECUTE AS OWNER statement is run after this as a separate ALTER script.
- SQL Compare is run with the default set of compare options
- I 'know' it is getting the EXECUTE AS incorrect because I am looking at the SQL Differences window and seeing that it incorrectly says EXECUTE AS CALLER
If there is anything else I can tell you, let me know ... I'm not sure when I'll get the time to be able to create a test database.
Thanks. / comments
Hi Michelle, thanks for your response.
I'm not able to provide a database or script at this time, but it is interesting that you couldn't reproduce it with your test database. It will be worth me c...