6 replaced http://stackoverflow.com/ with https://stackoverflow.com/
source | link

The procedure migrate_staging_data is the one that contains the synonym usage to the Production database. I'm excluding it because it's very large and generating a MCVEMCVE will be time consuming for not much gain.

The procedure migrate_staging_data is the one that contains the synonym usage to the Production database. I'm excluding it because it's very large and generating a MCVE will be time consuming for not much gain.

The procedure migrate_staging_data is the one that contains the synonym usage to the Production database. I'm excluding it because it's very large and generating a MCVE will be time consuming for not much gain.

5 edited tags
| link
    Tweeted twitter.com/StackDBAs/status/670148855997034496
4 edited body
source | link

I've tried adding 'WITH EXECUTE AS SELF'WITH EXECUTE AS SELF TO the migrate_staging_data procedure based on some research, to no avail. I've also tried changing the ALTER QUEUE My_MigrationQueue statement to include EXECUTE AS SELF

I've tried adding 'WITH EXECUTE AS SELF' TO the migrate_staging_data procedure based on some research, to no avail. I've also tried changing the ALTER QUEUE My_MigrationQueue statement to include EXECUTE AS SELF

I've tried adding WITH EXECUTE AS SELF TO the migrate_staging_data procedure based on some research, to no avail. I've also tried changing the ALTER QUEUE My_MigrationQueue statement to include EXECUTE AS SELF

3 added 221 characters in body
source | link
2 added 44 characters in body
source | link
1
source | link