Access to a SQL Server in some other Domain from SQL Server Management Studio

Senario in brief: My normal working domain is DomainA. But i have to connect to a sql server in DomainB. Administrators have given me remote desktop connection to the server which has sql server in DomainB but not to direct access from my SQL Server management studio.Following is the solution. runas /netonly /user:DomainB\sqladmin "C:\Program Files (x86)\Microsoft …

SQL Server function to get Business Unit Guid by Name

This will be very useful when you are migrating data to CRM database from some other system database. Specially when filling base tables we should give business unit guid to it.You can use following function and I have given the way that you should use it in your data migration scripts.CREATE FUNCTION dmfx_GetBusinessUnit(        @businessUnitName …