information_schema
: Grant read access permissions to the tables within MSSQL as well as the information_schema
schema. This allows Databrain to retrieve necessary information and replicate data accurately. You can assign appropriate permissions to the user or role accessing MSSQL to enable reading from tables and accessing metadata stored in the information_schema
.information_schema
.SELECT SERVERPROPERTY('MachineName')
to retrieve the server name.SELECT SERVERPROPERTY('Port')
to check the port MSSQL is running on.SELECT SYSTEM_USER
to display the current user.