SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

Exporting Data From SQL Server to Script File

SQL Server provides the ability to generate scripts for creating databases, tables, stored procedures, functions, views and inserting data. For Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are Read More …

Triggers – SQL Server

In SQL Server, a trigger is a special type of stored procedure which will run automatically in response to some Read More …

Export table to CSV file (SQL Server Management Studio)

A very common requirement with SQL Server is to export a table to a CSV file. It’s actually an easy Read More …