SQL Server - Tips

SQL Server

Page update date :
Page creation date :

Tips related to SQL Server.

In-page links
SQL Server Management Studio
replication
Ssis
SQL Server に SQL Server 認証で接続するためのサーバー側の設定

SQL Server に SQL Server 認証で接続するためのサーバー側の設定

SQL Server 認証で他のサーバーにある SQL Server に接続するためにはいろいろ設定を行う必要があります。
Steps to migrate all data between servers in SQL Server

Steps to migrate all data between servers in SQL Server

There are several steps you can take to migrate SQL Server data to another server.
Install SQL Server 2014 CTP2

Install SQL Server 2014 CTP2

Provides step-by-step instructions on how to install SQL Server 2014 CTP2.
Install SQL Server 2008 R2

Install SQL Server 2008 R2

Provides installation instructions for SQL Server 2008 R2.
Automatic backup of SQL Server databases

Automatic backup of SQL Server databases

Automatically back up the database by using the SQL Server maintenance plan.

SQL Server Management Studio

Change the text that appears on a tab in SQL Server Management Studio

Change the text that appears on a tab in SQL Server Management Studio

Change the tab text that appears, for example, when you enter SQL in SQL Management Studio.
Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment

Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment

Notes for connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment.
Enable table design changes in Management Studio

Enable table design changes in Management Studio

Allows SQL Server Manageement Studio to rename and type columns in a table.

replication

SQL Server 2019 でトランザクション レプリケーションの更新可能なサブスクリプションを有効にする

SQL Server 2019 でトランザクション レプリケーションの更新可能なサブスクリプションを有効にする

SQL Server 2019 ではウィザードでトランザクション レプリケーションを作成した際に更新可能なサブスクリプションを有効にできません。ここでは有効にする手順について説明します。

Ssis

Install a SQL Server 2014 CTP2-enabled SSIS build environment

Install a SQL Server 2014 CTP2-enabled SSIS build environment

Provides step-by-step instructions on how to set up SQL Server integration Services (SSIS) for SQL Server 2014 CTP2.
SSIS prints Unicode strings to a text file as shift-JIS character codes

SSIS prints Unicode strings to a text file as shift-JIS character codes

Describes how to print Unicode strings to a text file without errors as shift-JIS character codes in SQL Server Integration Service (SSIS).
メモ

メモ

SQL Server についての Tips を掲載しています