Tuesday, July 27, 2010

How to add new user in sql server management studio 2008

Hei guys,
I was also suffering from this problem and finally I got succeeded so i am sharing my experience here.

Steps:
(This is a experience of doing it in windows 7 but should work in xp, vista and 2000 as well)

1. Open SQL management studio and log in
first as windows authentication mode.
(choose proper server name in which you want to add user)
as shown in figure










2. Extend security folder content which is located in right side if window. Right click on login tab (as shown in figure) and add new user.










3. put login name, click radio button to SQL Authencation,
put password
uncheck enforce password policy and select database as master as shown in figure










4. click on user mapping tab and click on master database and make it owner of database as shown in figure.

















5. Now you completed the process click ok and restart computer then try to login with your new user account. For sure it will work.

If you have any problem please feel free to ask me :)

Thank you
mebalkrishna@gmail.com

Tuesday, July 20, 2010

Difference between Stack and Heap

Stack

It used by value type. It can store fixed amout of data and stored in RAM.

Stack is used by Int, Array, Enumerator, Struct. Memory management is automatically done by program so we dont need to create desctructor.

Heap

It is Used by reference type. It has unlimited size. Data whose size can not be determined before execution of program and need to allocate dynamically in run time are fall in this category. For example if we need to read data of file then it may have any size so this type of date are stored in heap. It is stored in secondary memory i.e. harddisk.

String, Classes use heap for storing data. Program doesnot about memory status of heap so programmar him/herself need to destruct it.