Please run the below query to get specific details about a table. SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH FROM [DATABASE_NAME].INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N’TABLE_NAME’ Other Database Objects that can be used: – CONSTRAINT_COLUMN_USAGE – CONSTRAINT_TABLE_USAGE – DOMAIN_CONSTRAINTS – DOMAINS –
How to change SVN bindings – (Tortoise SVN)
Recently our SVN server location was moved to a new location. As a part of this migration developers were supposed to change their svn bindings. For source control, we use Tortoise SVN in our company. Developers use Visual SVN plugin
How to Setup SQL Server 2012 SP3 and SSMS (SQL Server Management Studio) on Windows Server 2012 R2
In order to set up SQL Server 2012 SP3 – I downloaded the files using Microsoft Subscription. Please follow below steps to run the installation. Please make sure to install .Net Framework versions 2.0 and 3.5 from Server Manager. Download
How to solve SMTP Service issue: 5.7.1 Client was not authenticated on Windows 2012 R2
After configuring email server on Windows 2012 R2. There is a possibility that emails might not be sent to addresses outside your domain. When I was using Pickup Directory option to send emails outside our network, I was constantly getting
How to setup enterprise Geodatabase in ArcGIS using ArcCatalog
Setting up Geodatabase is an easy task from ArcCatalog. Please follow the below instructions to setup a Geodatabase. Open ArcCatalog and find the search icon from your toolbar(shown below) or press ctrl + f to open search window. Search for text
How to setup and Configure SMTP Server on Windows 2012 R2
Below are the steps to setup and configure SMTP server on Windows 2012 R2. Installing SMTP Feature Click Server Manager icon which is displayed on the bottom left corner to open Server Manager. Click on the Add roles and features
How to Bulk upload SQL Server Reports (version ssrs 2008 r2)
Recently, I ran into an issue where we have to upgrade our servers to accommodate better hardware. As a part of this migration, one of the task was to upload SSRS reports (rdl) files to the new server. I found
How to enable File Stream on SQL Server Database
For one of my web project, we were asked to implement a functionality for Document upload and let the users upload and store the documents via the site. One of the requirement was to store the document in BLOB format.
How to add Images to PDF using iTextSharp
Most recently I used iTextSharp a lot for a lot of my projects. I personally like the library because of the fact it is free and open source. In this post I will try to explain how to manipulate and
How to view TCP / UDP statistics using command prompt
Recently I ran into issue with WCF services. Instead of http port, I was using tcp port to host my wcf services. One of the challange for me to find out how many calls were being made to the services.