Skip to main content
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.

edited tags
Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663
Tweeted twitter.com/StackDBAs/status/670148855997034496
edited body
Source Link
Brandon
  • 618
  • 2
  • 7
  • 17

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

added 221 characters in body
Source Link
Brandon
  • 618
  • 2
  • 7
  • 17
Loading
added 44 characters in body
Source Link
Brandon
  • 618
  • 2
  • 7
  • 17
Loading
Source Link
Brandon
  • 618
  • 2
  • 7
  • 17
Loading