![]() ![]() SET TABLE NAMES FOR ALL nvarchar ( 100 ), nvarchar ( 100 = 'dbo.Target_WebLinks', = 'dbo. I haven't tested this, but it seems your problem resides in the fact that you're using variables in the statement. The English language is replete with synonyms in large part because England was invaded by so many different language speakers. Testing: these return a properly formed Table Name snnm two words that can be interchanged in a context are said to be synonymous relative to that context. SET TABLE NAMES FOR ALL nvarchar ( 100 ), nvarchar ( 100 = 'dbo.Target_WebLinks', = 'dbo.Source_WebLinks' = SYNONYM TEST varchar ( 50 varchar ( 50 = 'Target.' Can this be done?Īnd does anyone know where in the sys tables are they stored so you can make the usual "if exists drop synonym then create synonym" header block for the sql files. ![]() But I want to use SQL vars and pass them into the sprocs to create the synonyms.īelow is a test run, but the create synonym fails with the variables. The news of Synonyms was exciting and could save me from a lot of DYNO SQL and duplicate versions of scripts for multilbe DBs on the same server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |