Hey I knew that.

Hey I got it right.

I knew about SQL Server 2005. But was not sure about other versions .:-)

I knew Database mail was not available in 2005 Express editions, but I thought they might have added this feature in 2008 Express Edition.

Good Q.

Learned something new today.

Yeap, I got it!

It was easy one!:-)

I was lucky :hehe: I got it right!

hey, this was tricky one!

Piece of cake buddy! ;-).

This was easy one. You can find more about wildcard use with LIKE search condition at below mentioned link:

http://bhaveshgpatel.wordpress.com/2009/10/03/sql-server-select-statement-with-where-like-clause/

Hey this was easy one. Hope for more such easy Q's in future! 😀

That was tricky one.

I didn't knew that when a number is casted to DATETIME, that number is added '1/1/1900' and returns the resulting date.

Hey, it works now. The new user can restore the database after being assigning 'dbcreater' server role.

But is this the optimal solution?

Because I want to give the user bare minimum...

Hi Pradeep,

If I give user 'db_backupoperator' database role, it allows the user to take backup. -- Half the Problem solved.

But It does not allow the user to Restore the Database!...