Friday, February 26, 2010

Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)

Obliviously, I deleted the database which I had set as the default database to my login in SQL Server 2008. To change it, I double-clicked on my login under Security -> Logins but it threw me an error stating unable to login to default database. After a headache of 20 minutes, I found the solution:
1. In the Connect to Server window, click on the Options button.

2. Under the Connection Properties tab, type the name of the existing database or the default database (usually 'master') at 'Connect to database:' option. (Drop-down will again try to connect so its no use of trying).

3. Then click Connect. Voila!



Thought this might be helpful than to try other sqlcmd options from the command prompt.

Tuesday, February 9, 2010

HE LOVED HER II

They were working in the same office but different project teams so he hardly noticed her but he was noticed among everyone because of his brace and charm. Her project got over and her team was dissolved. Everyone of that team was integrated to the other existing team and she was moved to his team. Only then he came to know that such a girl existed. When she started to witness his brace and charm closer every day, she longed to become his friend. And the longing grew every time she heard him joking and commenting with his peers. He never talked with her expect officially and that too happened once a while as both of their jobs were different in the team. Whenever she talked with him officially, his responses were always short and to the point and she used to wonder whether her longing would be fulfilled.

He was only aware of her presence until he saw how she behaved with others especially with the male peers. He started to respect her and admire her. When she volunteered to buy drinks for everyone during an inter-office game practice, he thought she was special. He then started sending her forwarded mails and started chatting with her using the internal jabber. She was really surprised at his initiative to talk with her because he had always spoken very little and officially. At first, she couldn’t understand him and most of the time she was confused on what he was talking about. However, their conversation over the jabber grew day by day. To certain extent, they had the same likes and dislikes. At one point, he admitted to her that he saw a mirror image of himself in her. When she heard that, she was so overjoyed that it became one of the best moments in her life. That day, her wish of becoming his friend was on the verge of being fulfilled.

Though he used to talk so much over the internal jabber but in person, he talked only official matters to her. She was always surprised how he could maintain two different behaviors, one on the chat and the other off the chat. She found the answer on the day she sat next to him in the office bus. She had changed her residence and it was on his way to home/office. In the initial days, her friend used to reserve a seat for her. Then, once her friend’s shift timings had changed, she would get the seats in the last row only since those were the least preferred ones. On that particular day, there was a seat available next to him. She first hesitated but then decided to take the seat after he acknowledged her presence with a smile. He slowly started speaking with her and on that day she came to know that he can talk non-stop. He spoke everything under the sun and she was amazed how much he knew about. Their relationship on the bus grew day by day and it became a routine for them that he started to reserve a seat for her.

To him, though he was friend to everyone in his team, he never considered anybody as his friend since he never exposed his real feelings to anybody. To her, though she had many friends and some were very close to her, she never had a friend only to herself. When these two people met, they touched each other’s longings, unconsciously.