Tuesday, 28 July 2015

Move System Databases

Open SQL
Select DB Name
Right click on DB
Select properties
Click on Files
You will find where .mdf .ldf files are located in the server.
Now you need to move this files in to another drive.
Step1:
Select DB
Right click -->Tasks-->Detach
Check Drop, Update check boxes in the new window
Ok
Now you have Detached DBs from SQL
Step 2:
Move .mdf .ldf files to another location.
Cut from current location and paste another location.Ex: form c to D
Step 3:
Attach the DB
Right click on database
Click Attach
Select .mdf file from your new location
Ok

Done..

Wednesday, 22 July 2015

How To Get Compare Plugin Back Into Notepad++


Go to notepad++ plugins from below site
http://sourceforge.net/project/showfiles.php?group_id=189927
Download ComparePlugin from below site
http://sourceforge.net/projects/npp-plugins/files/ComparePlugin/
Inside the downloaded zip file, you will find the ComparePlugin.dll. Unzip and place this into your Notepad++ plugins directory (which is usually at C:\Program Files (x86)\Notepad++\plugins)

Now open 2 files which you want to compare using notepad++
In the Notepad++ top menu, you will see Plugins
Click Plugins-->Compare-->Compare

That's it...:)


XML tools plugin

https://sourceforge.net/projects/npp-plugins/files/XML%20Tools/Xml%20Tools%202.4.4%20Unicode/Source%20XML%20Tools%202.4.4%20Unicode.zip/download

Monday, 20 July 2015

SQL Server Management Studio Local path

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2\SQL Server Management Studio

Monday, 6 July 2015

One of the BEST msg I have come across:Worth reading-


A group of friends visited their old university professor.
Conversation soon turned to complaints about
'STRESS' & 'TENSION' in Life.
Professor offered them Coffee & returned from kitchen with Coffee in different kinds of cups !!!
(Glass Cups, Crystal Cups, Shining Ones, Some Plain Looking, Some Ordinary & Some Expensive Ones......)
When all of them had a Cup in Hand,
the professor said:-
"If you noticed-
all the Nice Looking & Expensive Cups are taken up,
leaving behind the ordinary ones !!
Everyone of you wanted the Best CUPS,
&
that is the source of your STRESS & TENSION !!
What you really wanted was
"Coffee", not the "Cup" !
But you still went for the Best Cup.
If Life is Coffee ;
Then Jobs, Money, Status & Love etc. are the Cups !!!
They are just TOOLS to hold and contain Life.
Please Don't Let the CUPS Drive you !!
Enjoy the COFFEE ......!!!
What is life ?
They say its from B to D...from Birthday to Death..But what's between B and D?
Its a " C " Choice ...
Our life is a matter of choices...
Live well and it will never go wrong....

Wednesday, 1 July 2015

.Net how to prevent client sessions

Ans) Change connection string in web config
restart the w3svc service Or IIS