sql server - Do SQL synonyms work ok in multi user environment -


using mssql 2008 - have regular , archive table, same structure. depending on date range create synonym 1 or other table inside stored proc, use synonym further data processing. when 2 (or more) users concurently use stored procedure uses synonym different table, second user overwrite global synonym pointing fist user or synonym first user unchanged during execution of stored procedure? if second version true, synonyms not seem suited multi user , dynamic synonym creation environment or missing something?

a synonym merely way have 1 name point @ another. don't know you're expecting, user accesses synonym name accessing underlying object synonym points to. which, in interpretation of "working in multi-user environment", means works.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -