Thanks...

But the problem is that there's no space now. Hence manager asked me to reduce the log size..pls guide what to do now..?

shall I truncate it ..?

Yes...have done that...but size doesn't reduce..It shows me the same size

It's same app_name no..?. Thanks I got it.

Well, wot about host_name()..? which one is better .?

Can you pls explain it in details...

I usualy assign database rights to SQL login...

How can I do the same with windows..?

Yeah..Thanks...Got the informations.

Hi,

I have Micorsoft SQL server 2005 standard edition. 32 bit.

After installing it I UNINSTALLED SQL Server 2000 which was already there.

Yes.. Only that much.

When I tried the same in my office PC it works.

One more thing I noticed that the COLOR of words like

'Alter', 'Database' etc, is blue but...

Sorry, There was a mistake.

I installed SQL 2005 without UNINSTALLING SQL 2000.

Wel, I was just practising Backup, Restore etc.

I just tried to chage the recovery mode of database and I...

Thank You.

Errr, those are pretty trivial questions. If you don't know the answers, how well do you really know backups? Concentrate on improving your knowledge of the product, not on specific...

You are right..but there might...

Please Send it ....I will find the answers..

Thanks.

I am in India, but ready to relocate to anywhere in the world.

I would be more than happy if I can get some job in Australia or Japan as I...

Hi,

I sent the script using 'nText' already..Actualy the problem was that, user copy and paste some values from some files. It cause problem while saving...it...

There is enough space in D:\. I will check the log and revert back.By the way, am doing it in sql express...does it make any diff..?