Author: Sugeshkumar Rajendran

  • Creating user defined System Objects in SQL Server

    You can create an object in SQL Server and convert it to a system object just by marking the object as given below. By doing so you will be able to call the procedure from any db context

  • Determine which objects exist in a particular filegroup

    This script will help you to determine the objects existence in a filegroup. You can get on which file group does a object exists. Change dbname before using the script.

  • Migrating Access Database to SQL Server

    I recently received a call from one of my friend asking me, what is the easiest way to migrate a database from ACCESS to SQL Server? I was curious on answering his question and just went for a search in internet to find it was much simple than what I expected. This article describes the…

  • Cross Domain Windows Authentication for SQL Server databases

    There are many acquisitions these days and the DBA and sysadmins have a great tasks of doing a cross-domain authentication to their servers and databases. System admins have various options to connect interdomain where as DBA has to look up for it. Here is a solution that one can try using to access databases in…

  • Validating Replication Subscriber using TSQL

    Last post from me on SQL Server replication was on How to validate subscribers in SQL Server Replication. This article shows how the same can be done using TSQL. sp_publication_validation: This system stored procedure does a validation for each and all articles in the specified publication in transactional replication. This stored procedure is executed against…