Thank you very much John. One coffee later and I was just about to post back that I had worked it out along the same lines.

I think that this is what the OP is after - not some complex forensic solution. Time will tell.

Why are you doing this?

deebabat (4/25/2012)

---

when i ran the select count (*) statement of the where clause, i got this error message: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar...

Any reason why you wouldn't shrink it? There might be a...

david.alcock (4/25/2012)

---

Just wanted to ask, if a log file has got too big and then subsequently a log backup has been taken, the recovery mode switched to simple but the...

You need to remember that SQL Server is a server tool and MS Access primarily a client tool.

It sounds like you will be able to get a long way towards...

Seriously? How about adding "rows > 1000" (assuming you...

kiran 4243 (4/24/2012)

---

Hi,

Can you please explain how i can create a lookup in sql server like the one in ms access. Is it possible in sql server ?

Please help with...

Helpful as always...

If you check out the OP's other posts (try this link), you'll rapidly come to the conclusion that the answer is 'no'.

shailesh.thapliyal (4/23/2012)

---

Status bar color seems to be best possible solution but I would like you to tell me how can I move my status bar on top of screen, currently...

shailesh.thapliyal (4/23/2012)

---

Thanks for your response Phil.

I think status bar is the only possible solution we have.

Just wanted to try this in order to avoid human errors like truncting the...

No. Status bar colours are the best you can get, as far as I know.

This reminds me of another tantalising, yet effectively useless, quote:

I have a truly marvellous demonstration of...