Activity overview
Latest activity by pureblue
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...
EXECUTE AS OWNER always shows as EXECUTE AS CALLER
Hi,
I have a problem when comparing databases that have managed stored procedures. Some of our stored procedures are catalogued as “EXECUTE AS OWNERâ€, rather than the default “EXECUTE AS CALLE...