How To Create and Configure a Linked Server in SQL Server Management Studio? How do we do?

How To Create Linked Servers in SQL Server Database Engine?

What Is a linked Server in SQL Server?

The SQL Linked Servers allows us to connect to other database on another machine or another remote server’s database tables, procedures or other instances.

The Following Steps To Create and Configure a Linked Server -

ü In SQL Server Management Studio

ü Open Object Explorer

ü Expand Server Objects

ü Right click Linked Servers

ü And then click “New Linked Server” link

o After clicked on New Linked Server, Select General Tab

o In the Linked Server Box

o Type the name of the Instance of SQL Server

ü After clicked on New Linked Server, Select Security Tab

o Add the local server login to remote server login mappings

o Select the local login and checked to impersonate check box

o And Select Be made without using the security context

o Press OK

ü Finally Right click on CREATED linked Server and Select Test Connection

ü If everything is OK, then return a success popup message - “The test connection to the linked server succeeded”.

SQL Query Looks like –

-- Creating Linked Servers (SQL Server Database Engine)

-- SQL QUERY

SELECT TOP 1000 [APP_LOG_ID]

,[DATE_TIME]

,[HOST_NAME]

,[HOST_ADDRESS]

,[BROWSERS]

,[MESSAGE]

FROM [VIASERVER\SS_DE_2014].[DEMO_DEV].[dbo].[APP_LOG]

-- Linked Server Name - [VIASERVER\SS_DE_2014]

-- Database Name - [DEMO_DEV]

-- Table - [dbo].[APP_LOG]

See and learn the Steps in the below Video –

I hope you are enjoying with this post! Please share with you friends!! Thank you!!!

By Anil Singh | Rating of this article (*****)

React | Encryption and Decryption Data/Text using CryptoJs

To encrypt and decrypt data, simply use encrypt () and decrypt () function from an instance of crypto-js. Node.js (Install) Requirements: 1. Node.js 2. npm (Node.js package manager) 3. npm install crypto-js npm install crypto - js Usage - Step 1 - Import var CryptoJS = require ( "crypto-js" ); Step 2 - Encrypt // Encrypt var ciphertext = CryptoJS . AES . encrypt ( JSON . stringify ( data ), 'my-secret-key@123' ). toString (); Step 3 -Decrypt // Decrypt var bytes = CryptoJS . AES . decrypt ( ciphertext , 'my-secret-key@123' ); var decryptedData = JSON . parse ( bytes . toString ( CryptoJS . enc . Utf8 )); As an Example, import React from 'react' ; import './App.css' ; //Including all libraries, for access to extra methods. var CryptoJS = require ( "crypto-js" ); function App () { var data

List of Countries, Nationalities and their Code In Excel File

Download JSON file for this List - Click on JSON file Countries List, Nationalities and Code Excel ID Country Country Code Nationality Person 1 UNITED KINGDOM GB British a Briton 2 ARGENTINA AR Argentinian an Argentinian 3 AUSTRALIA AU Australian an Australian 4 BAHAMAS BS Bahamian a Bahamian 5 BELGIUM BE Belgian a Belgian 6 BRAZIL BR Brazilian a Brazilian 7 CANADA CA Canadian a Canadian 8 CHINA CN Chinese a Chinese 9 COLOMBIA CO Colombian a Colombian 10 CUBA CU Cuban a Cuban 11 DOMINICAN REPUBLIC DO Dominican a Dominican 12 ECUADOR EC Ecuadorean an Ecuadorean 13 EL SALVADOR

Angular 7 and 8 Validate Two Dates - Start Date & End Date

In this example, I am sharing “ How to compare or validate two dates in Angular? ” using custom validation function in Angular 7 and Angular 8 . Here, I’m validating the two dates - a start date and end date. The end date should be greater than the Start date”. Let’s see the example :- import { Component , OnInit } from '@angular/core' ; import { UserRequest } from '../model/user' ; @ Component ({ selector: 'User_Cal' , templateUrl: './usercal.component.html' , styleUrls: [ './usercal.component.css' ] }) export class UserCalComponent implements OnInit { constructor ( private EncrDecr : EncrDecrService , private http : HttpClient , private datePipe : DatePipe ) { } //model class model = new UserRequest ( null , null , null , null , null ); //Error Display error : any ={ isError: false , errorMessage: '' }; isValid

Encryption and Decryption Data/Password in Angular

You can use crypto.js to encrypt data. We have used 'crypto-js'. Follow the below steps, Steps 1 – Install CryptoJS using below NPM commands in your project directory npm install crypto-js --save npm install @types/crypto-js –save After installing both above commands it looks like – NPM Command 1 -> npm install crypto-js --save NPM Command 2 -> npm install @types/crypto-js --save Steps 2 - Add the script path in “ angular.json ” file. "scripts" : [ "../node_modules/crypto-js/crypto-js.js" ] Steps 3 – Create a service class “ EncrDecrService ” for encrypts and decrypts get/set methods . Import “ CryptoJS ” in the service for using encrypt and decrypt get/set methods . import { Injectable } from '@angular/core' ; import * as CryptoJS from 'crypto-js' ; @ Injectable ({ providedIn: 'root' }) export class EncrDecrS

23 Best Key Features of MVC 6 and MVC 5

What’s new In MVC 6? The Added Key Features as following as, 1. The Microsoft makes a bundle of MVC, Web API, WebPages, SignalR, that bundle we called MVC6 . 2. The MVC 6 added new cloud computing optimization system of MVC, web API, SignalR and entity framework. 3. In MVC 6, Microsoft removed the dependency of system.web.dll from MVC 6 because it's so expensive. Typically it consumes 30K memory per request/response. 4. Right now, in MVC 6 consume 2K memory per request response. It's too small memory consume. 5. Most of the problem solved using the Roslyn Compiler . 6 . It’s added a Start-up class that replaces to global.asax file. 7. The Session state and caching adjusts our behavior depending on your hosting environment. 8. Host agnostic and its true side-by-side deployment 9. The vNext is a cross platform and open source and it's also supported to Mac, Linux, etc. 10. It’s also added to TagHeaplers use to creating an

Anil Singh | Code-sample.com

Search This Blog