How to create incremental drop script by using MS Build and SQLPackage utility
1. Background The purpose of this document is to provide a way of creating incremental drop script with respect to…
Category: SQL Server
Database Migration from SQL Server 2000 to 2008/2008 R2/2012
1. Background: The purpose of this article is to lay out the structure for database migration from SQL 2000/2005 to…
String Functions in SQL Server 2012
String functions perform an operation on an input string and return a string or numeric value: 1) ASCII (character_expression): Returns…
SQL Server- How to send Insufficient Disk Space Notification
1. Background The basic aim of this article is to describe a way of sending email notification whenever insufficient disk…
SQL Server- Implementation of Database Mail
1. Background The purpose of this article is to describe implementation of database mail configuration in SQL Server so that…
SQL Server: How to create a linked server pointing to a server different from its name
Background The purpose of this article is to provide a step-by-step method of creating a linked server that point to…