('_productiondb%','','') - renamed local db Also, allow multiple replaces at once with a temp table (please replace the values in the "insert into #Replacements" section with the replacements you want to make): create table #Replacements SELECT TOP 1 = a change to 's answer to fix synonyms whose local name is different from the object they are referencing. SET = N'create synonym ' + + N' for ' + + N'.'+ + N'.'+ sp_executesql 'GO' WHERE NAME = schema_id = N'drop synonym ' + sp_executesql create the synonym SET = N'.' + delete the synonym if it exists set the schema and name for the synonym The following changes are possible for a synonym: Create Synonym Change textual information / Edit Synonym Remove Synonym The change requests for the. WHERE base_object_name LIKE '!.!%' ESCAPE ('!') 116 synonyms for change: alteration, innovation, transformation, modification, mutation, metamorphosis. To these high-quality synthetic base oils we add our proprietary Active Cleansing Technology to create a motor oil that helps provide superior cleansing. There is no change in T1 but the interaction produces T2 relaxation. Shell Helix fully synthetic oils are manufactured from 100 synthetic base stock and high quality additives to achieve higher performance levels than both synthetic technology and mineral oils. Harvard Law School provides unparalleled opportunities to study law with extraordinary colleagues in a rigorous, vibrant, and collaborative environment. ,SUBSTRING(name,CHARINDEX('.',name,0)+1,CHARINDEX('.',name,CHARINDEX('.',name,0)+1)-CHARINDEX('.',name,0)-1) Synonyms for T2 relaxation are transverse relaxation and spin-spin relaxation. INSERT INTO (table_name,dest_table_name,dest_schema_name) Furthermore, there are dictionaries of synonyms that pair words that have. create a synonym for these tables (insert each table) change 1 alter, convert, diversify, fluctuate, metamorphose, moderate, modify, mutate, reform, remodel, reorganize, restyle, shift, transform, transmute. have come to him from contemplating puzzles such as Change one letter in. WHERE NAME = TABLE (table_name SYSNAME,dest_table_name sysname,dest_schema_name sysname) Here's something I used to remap all synonyms to a new database on the same server (based on Tobsey's suggestion) SET NOCOUNT ON