Knowledge Share 2014-07


  • SYNONYM is used to reference an object in usable format.
  • Syntax: create synonym UsableName for Server.DBName.SchemaName.TableName
  • Note: The base object need not exist at synonym create time. SQL Server checks for the existence of the base object at run time.
  • Reference:
create synonym UsableName for Server.DBName.SchemaName.TableName

Windows OS Architecture

  • While downloading/installing .msi on remote client I am not sure about the architecture confused to choose right one between _86.msi or _ai64.msi or _x64.msi.
    You may run msinfo32.exe on your system (in Command prompt), check System type under System Summary;
This entry was posted in knowledge, SQL, Windows Server and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s