No issues. The statement only informs you that you will have stale data if there are very frequent changes :p. From where you got this statement by the way?

-LK

One small question... why do we have 10, 1); in following code. Is this mandatory to have 10, 1); or 20, 3); or anything will also work fine?

ENABLE TRIGGER trg_protect_sensitivetables...

How can you skip collation setting when you are installing sql server 2005. Last but one option asks you to confirm collation setting........... I am confused Randy because of your...

Sanjay this was a nice response

Also tell me when you tried to migrate the data from one collation to another... would not that gave you some issues?

-Lk

I have read many books and blogs on sql server. Everywhere this is written that we need to reinstall if need to change the collation setting. IN sql server 2005...

But this creates the file in the hard disk. Do you mean that this file is not useful in any of other servers?

-Lucky

Paste your code

You are correct. My OS is windows Vista home premium. Plz provide me info to get this worked.

-LK

/console means Connect to the console of a server (NT/XP). One small question to all. What is the exact meaning of connecting to the console of a system. I...

I am not sure but I read somewhere that we can make some change in the database property and then .mdf and .ldf can be copied without taking DB offline....

You want to copy .mdf and .ldf then make it offline

Any other link... I downloaded from here only and my sqlwb got corrupted... I won't do that again

-Lucky

Do following give any information?

faulting module ntdll.dll, version 6.0.6001.18000

exception code 0x80000003, fault offset 0x00047dfe, process id 0x850

🙁

I don't think that it is possible

Thanks Gila. Is column statistics also needful? MS should remove sysindexes otherwise.

-Lucky