web analytics

TechnoBlogy Blog

Tracking object (Table, SP etc) changes in SQL Server 2005 0

Tracking object (Table, SP etc) changes in SQL Server 2005

Reading Time: 1 minuteDBA’s often need to track the changes being made to database objects such as tables, user defined functions and store procedures etc. Following article aims at providing the readers on how the changes being...

Debugging Stored Procedures in SQL Serrver 2005 0

Debugging Stored Procedures in SQL Serrver 2005

Reading Time: 2 minutesPre-requisites 1. Find the .exe file under the directory, C:\Program Files\Microsoft SQL Server\90\Shared\1033\rdbgsetup.exe or similar path where the SQL Server was installed. The file rdbgsetup.exe stands for ‘RemoteDeBuGsetup’. Look for the emphasis on letters....

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML 6

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML

Reading Time: 5 minutesIntroduction DataTable is a central object in the ADO.NET library. If you are working with ADO.NET – accessing data from database, you can not escape from DataTable. Other objects that use DataTable are DataSet...

Delete duplicate rows from table 1

Delete duplicate rows from table

Reading Time: 1 minuteIn the above line we are inserting all the distinct row of the "EmployeeTable" to another table "Emp_Temp_Table" (Emp_Temp_Table will create automatically when you use the above query.) Actuall the above query create clone...

CSS – Conditional Statements 0

CSS – Conditional Statements

Reading Time: 1 minuteFor CSS to work in cross browser environment, we have to write some conditional statements to make our styles look same in all the browsers. Below is the sample code that demonstrate how to...

Publish a ASP.NET website from command line 0

Publish a ASP.NET website from command line

Reading Time: 1 minuteIn case of an automatic build/deployment process it might be a request to precompile the web application after building it. Since .NET Framework 2.0 there is a tool called aspnet_compiler.exe. You can use it...

Change default browser in Visual Studio 0

Change default browser in Visual Studio

Reading Time: 1 minuteVisual Studio opens a web project for debugging in the default browser. This might not be the Internet Explorer. To change this behavior stop debugging and open a ASPX File from your web solution....

Add an entry to event log in C# 2

Add an entry to event log in C#

Reading Time: 1 minuteEventLog is a good place to write your applications log. Here is an example to show how to do this: If ( !EventLog.SourceExists("TestCategory")) EventLog.CreateEventSource("TestCategory","TestLog"); EventLog evtLog = new EventLog(); evtLog.Source = "TestCategory"; evtLog.WriteEntry("This is...