While working with ASP.NET multiline textbox I realized that MaxLength property was not working, it seems it was bypassed by ASP.NET engine. I decided to write a small JavaScript piece of code in orde...
Below is the SQL query to get all constraints: SELECT TableName = t . Name , ColumnName = c . Name , dc . Name , dc . definition FROM sys . tables t INNER JOIN sys . default_constraints dc ON t . obje...
While working with IE7 one of our pages was giving Operation Aborted error. I was getting the following screen: The reason for this error was that I was trying to add new elments to body tag via scrip...
If you want to load external JavaScript file dynamically i.e via JavaScript code you can take help from the following code: var loadJs= function (src, callback) { var s = document.createElement('s...
Below is the query which you can use to shrink the transcation log: USE AdventureWorks2008R2 ; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AdventureWorks20...