Hello dear,

ram usage in server is 2.75 of 4G (1.8 used by sqlserver2008 r2)

cpu usage 20 - 50%

all database 'Auto update statistics' is false

but when connect by application (asp classic)...

Dears All,

thanks for you comments.

My Company bought a accounting software which need "sa" user for config software and need x-cmdShell sp for some actions.

i am DBA of my...

hello Dear,

you can use AppexSQLLog for Compare data in 2 table and find difference beteen.

Best Regards,

zohreh

Can I Define Job for Restore a Backup and DBCC Check?

with which Syntax?

only DBCC Check is enough.

i should not check data in Tables?

off course, but when i install sqlserver200o on a PC with 4G RAM, Available memory equal 3.5G and when stop MSSQLServer available memory equal 3.3G .

both SQL Config...

yes, and i want know why this happen?

I Fixed it.

1- My sa password had ; charecter . i change it.

2- register dts.dll in C:\Program Files\Microsoft SQL Server\100\DTS\binn. I register it by regsrv32 ...

excuse me . my means was maitenance plan in sqlserver2000

some people in my office ,have access to sqlserver as admin and can change execution plan.

today i found some ones add new databases to weekly plan and cause my plan...

hnow can delete a backup file in sqlserver2000?