You may use following query to analyze all these aspects

select hostname, program_name, loginame, cpu, physical_io, memusage, login_time, last_batch, status

from master.dbo.sysprocesses

order by hostname

Further modify the query according...

Index scan is same as table scan that it scans all values. It usually occurs when optimizer determines that it will be quicker to simply scan all values in index...

Thank you very much

if i cast it to varchar in case portion , even then it picks single value.

i tried this statement standalone in SSMS. Database compatibility level is 80.

yes it is at compatability level 80. So that may be reason?

Now it worked in following syntax, but i wonder that why it did not work in previous syntax

alter table tableName

disable trigger TriggerName

i have confirmed the highlight and syntax but can not find the reason 😉

Thanks for all

Thanks alot

i have sql server 2000 with SP4, it was working fine but after uninstallation of antivirus the problem occurred. Now i want to recover the problem.

If you have configured the option then your back up server will automatically take over the primary server.

It is sybase inherited syntax, avoid it as it is not standard from microsoft.

OK. thanks. Please also tell some more important differences.

AOA

beside sugestions from my other twof friends,i have following sugestions

- Take backups on mapped network drives or copy backup to some other location regularly, after backup completion.

- Periodically restore the...