Everyday we come across some problem for which we try, research for hours and once solved, looks so easy in MS Excel.I like to keep a note of it and share with others, so people can use them.These notes are not necessarily my own writing but are the one which I came accross during my research over the net to find out solutions.
Go To SQL Enterprise Manager >>> Select Server >>>Open DB >>>>Tools >>> Export.. and it will guide you through from there.Don't remember, you probably have to disconnect as well. Try disconnecting and then, don't forget to connect back. :)
