when executing a sql file getting "system.outofmemoryexception" in sql server 2005

hi dears
today i m face a very interesting problem is that in our erp system we gnerate .sql file from database publishing wizard and server genrate .sql file successfully . but when i am execute that file on our local system in sql server 2005 we will get error that "system.outofmemoryexception" .i google it and found the solution that this problem is related to sql server memory configuration
. actually default setting of sql server use 2 gb memory for executing the any query in database sql server 2005
then there is two option
1-first one is suggested by msdn is that expand your memory from 2gb to 3 gb

2- second which i try and got success which is dont execute query at once , divide ur query in bunch of some lines so you can execute them.and after one by one execute all bunch of sql queries

i know that my solution is temporary but its work for me..

how to Show HTML/JavaScript Code inside Blogger Blog Posts on your blog

as you read different posts on my blog you see that there are many post in which there should be some code but its not show . why is there is a reason behind this which is in detail show below

"The Blogspot’s XML parser takes it as a code, and shows the result whatever is written in the code you pasted… Its only you who knows that you wanted to show the code deliberately without wanting it to be parsed automatically ."



so now as always solution in problem it self . so in this our problem the solution is that our code should not be parsed automatically for this ...........



Google’s Blogger Team realized this, and have added a solution for this in Blogger’s settings.

1. Login to your blogger account
2. Go to Settings.
3. Go down to the page.
4. Under “Select Post Editor”, choose “Updated Editor”.
5. Save the Settings.

after this setting for a new post which have code use following

Now Go and make a post, click “Post Options” below the post editor, and select “show HTML Literally”.

Insert any HTML codes in the post and preview or publish it.

how to Change the Authentication Mode of the SQL server 2005 from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Au

hi to all ,

today i face a problem that is at the time of installation of slq server 2005 i have choosen window authentication except

Mixed Mode (Windows Authentication and SQL Server Authentication)", and now i want to change it because when i create any new

login and try to connect with the new login credentials it will show error that "user is not associated with trusted sql

server connection" and this error due to i have choosen window authentication . so i have to change this mode in sql server.
for this it is simple connect ur server with window aunthetication and right click on server name in object explorer and

choose properties -> a window will open and in side pane choose security page there is a option to change mode , now press ok
now u can login with sql server authentication mode.

how to set default browser ?

today i face a problem , actually when i am login in gtalk and want to click on mail button in my gtalk it will open my gmail

account in internet explorer , but i want that it should open in mozilla firefox, the problem is understandable that mozilla

is currently not my default browser ? then i how can set it default browser ?
i google on this topic and find solution on mozilla website that you can go throught tools menu and choos options and in

option dialog box choose advanced tab there is a subtab general at first no my there is option to check default browser and

if u press it then it will ask to set mozilla set as default so u can make mozilla firefox as default browser from here .


but the problem is still that if i want to set any other browser so i need a solution from which i can set any browser as

default browser.
and problem solution exists in window settings that is sure. and finally i got the solution that is go to your control

panel and in add or remove programs there is a option for "set program access and defualts" in side bar of dialog box where u can find the set the default for any program u want . there u can set any browser as your default browser......

keyboard with new rupees sign

hi dear
after launching new rupee sign by govt. of india the keyboard which have new rupee sign is launched , the details information is avaliable on below link

http://www.techtree.com/India/News/First_Keyboard_with_the_New_Rupee_Sign_Arrives/551-112580-581.html

Deciding When to Create an MVC Application

You must consider carefully whether to implement a Web application by using either the ASP.NET MVC framework or the ASP.NET Web Forms model. The MVC framework does not replace the Web Forms model; you can use either framework for Web applications. (If you have existing Web Forms-based applications, these continue to work exactly as they always have.)

Before you decide to use the MVC framework or the Web Forms model for a specific Web site, weigh the advantages of each approach.

Advantages of an MVC-Based Web Application

The ASP.NET MVC framework offers the following advantages:

* It makes it easier to manage complexity by dividing an application into the model, the view, and the controller.
* It does not use view state or server-based forms. This makes the MVC framework ideal for developers who want full control over the behavior of an application.
* It uses a Front Controller pattern that processes Web application requests through a single controller. This enables you to design an application that supports a rich routing infrastructure. For more information, see Front Controller on the MSDN Web site.
* It provides better support for test-driven development (TDD).
* It works well for Web applications that are supported by large teams of developers and Web designers who need a high degree of control over the application behavior.


Advantages of a Web Forms-Based Web Application

The Web Forms-based framework offers the following advantages:

* It supports an event model that preserves state over HTTP, which benefits line-of-business Web application development. The Web Forms-based application provides dozens of events that are supported in hundreds of server controls.
* It uses a Page Controller pattern that adds functionality to individual pages. For more information, see Page Controller on the MSDN Web site.
* It uses view state or server-based forms, which can make managing state information easier.
* It works well for small teams of Web developers and designers who want to take advantage of the large number of components available for rapid application development.
* In general, it is less complex for application development, because the components (the Page class, controls, and so on) are tightly integrated and usually require less code than the MVC model.