Case sensitive query ?

How do I make a case sensitive query.
For e.g
Select * from myTable where Password='AaBb'
and
Select * from myTable where Password='aabb'
returns same records.
How do I make a case sensitive query so that 'AaBb' and 'aabb' are different(a) collate the column as case sensitive (see collate in books online, 2000
only)
(b) make the entire database case sensitive
(c) convert each side of the comparison to varbinary
"Arsalan" <arsalan_aslam@.hotmail.com> wrote in message
news:eWJg9y$aDHA.384@.TK2MSFTNGP12.phx.gbl...
> How do I make a case sensitive query.
> For e.g
> Select * from myTable where Password='AaBb'
> and
> Select * from myTable where Password='aabb'
> returns same records.
> How do I make a case sensitive query so that 'AaBb' and 'aabb' are
different
>
>sql

careless to remove data

I am careless to 'delete from myTable'
any other method to recover the data ?
thanks a lot..If you have not truncate your log, the data should be stay in the log
file and you should be able to restore from the log file.
Agnes wrote:
> I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..|||Restore from your most recent backup...
If it just happened and your db is in "Full Recovery" mode, backup the tran
log now
You can then RESTORE with STOPAT to do a point in time recovery
HTH. Ryan
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:emI3qwzUGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..
>|||Hopefully his db wasn't in "Simple" recovery..
HTH. Ryan
<stanleycn@.gmail.com> wrote in message
news:1143642476.867540.66940@.g10g2000cwb.googlegroups.com...
> If you have not truncate your log, the data should be stay in the log
> file and you should be able to restore from the log file.
>
> Agnes wrote:
>