Recently Updated Pages
SQL - Try Catch Rollback
BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction ...
MsSQL - Restore Agent Jobs from Another MSDB database
This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID U...
MsSQL - Export Stored Procedures and Views to Files
Use the Generate Scripts tool in SSMS: Right Click Database in Object Explorer. Tasks -> Gene...
Log4Net - Wrapper
https://stackoverflow.com/questions/1028375/how-do-you-configure-and-enable-log4net-for-a-stand-a...
Service - Add Installer and Setup
Go to Solution Explorer and right-click on your project solution then go to the view designer the...
MsSQL - Set All User Tables to Simple on DEV/TEST Server
/* This script is to set all of the user database to simple on a DEV/TEST server Use the @U...
MsSQL - Move TempDB To Another Drive
Sometimes as a database administrator, you need to move the TempDB database and log files to a ne...
MsSQL - Create Database Table from Code
declare @TableName sysname = 'TableName' declare @Result varchar(max) = 'public class ' + @Table...
Visual Studio - Bag of Tricks
To Add underscore to fieldNames
MsSQL - SQL Reporting Services
Enable Errors Connect to the database engine in SSMS and navigate to the ReportServer databa...
Powershell - Printers
Printers Delete Printers https://community.spiceworks.com/topic/1932797-use-powershell-to-delet...
Visual Studio - Deploy to Linux
The only thing that you need to do do to deploy to Linux is too change the target runtime setting...