Transaction Flow in Sql Server 2005

Every transaction moves through the various checks and code in the following order:

1. Identity insert check.
2. Nullability constraint.
3. Data-type check.
4. Instead of trigger execution. If an instead of trigger exists, execution of the DML
stops here. Instead of triggers are not recursive. Therefore, if the insert trigger executes
a DML command that fires the same event (insert, update or delete), then the
instead of trigger will be ignored the second time around.
5. Primary-key constraint.
6. Check constraints.
7. Foreign-key constraint.
8. DML execution and update to the transaction log.
9. After trigger execution.
10. Commit transaction.
11. Writing the data file.

Hope it Helps .

Happy Coding!!!

Enter Key Solutions in ASP.net - MUST READ

hi! Friends
Many times u must have faced a problem with ASP.net Form on making the Default Buttons...
(submit a form when visitor hit an Enter key... )
Suppose we have two submit buttons on a Page

1. In the Master Page - Infront of a Search TextBox - "GO" Button
2. In the Content Place Holder - Below a Login Form - "Login" Button

Now the problem is u can make only one default defaultbutton out of these two????
But what if u need to make both????

Below is the Code enabling u to do the Same....

TextBox1.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('"+Button1.UniqueID+"').click();return false;}} else {return true}; ");


Just write this Code on as many as TextBox Controls u want. This way you can "connect" as many text boxes and buttons as you want.

Happy Coding :)

Windows Service

hi! All this article which i found on web has described windows service very nicely.

http://www.developer.com/net/csharp/article.php/10918_2173801_3

Interviewing SQL Server DBA

hi! i found this link while surfing the web contains good questions about sql serer 2000 click here

Watch Out for this Site

Hey its a must visit site... My friend has made it with much effort. Let me some of the highlights of this site.

http://www.lordjagannath.com is the first ORIYA spiritual website, fully
dedicated to Lord Jagannath, Puri, Orissa, India.

You can find more about Lord Jagannath, the history, about temple, deities,
costumes, nabakalebara, servitors & interesting facts about Lord Jagannath &
Jagannath Temple. You can also find information, jokes, facts, quotes etc.

You can download Screen Saver, Wallpaper, Software, Horoscope for Free.

so just Enjoy!!!

PAGE Re-Direction

hi! Below is the code which allows you to redirect the page without using Javascript or ASP or asp.net

HTML

Place the following HTML redirect code between the HEAD tags of your HTML code.

meta HTTP-EQUIV="REFRESH" content="0; url=http://www.yourdomain.com/index.html"

The above HTML redirect code will redirect your visitors to another web page instantly. The content="0; may be changed to the number of seconds you want the browser to wait before redirecting.

Checking File Type Upload in Javascript !!!

hi!

Many times we need to check the file types a user is uploading.

Below is the code Written in Javascript where you can check the type of file user uploading and Alerting the user so was to upload only the allowed file type.

function check()
{

if(this.document.Form1.fImage.value !="" && this.document.Form1.fImage.value.toUpperCase().indexOf(".JPG") == - 1 && this.document.Form1.fImage.value.toUpperCase().indexOf(".GIF") == -1)
{
alert("Image should be in gif or jpg format");
this.document.Form1.fImage.focus();
return false;
}
return true;
}


Above Code will alert the user if the file type is not in jpg or gif format.....