you should also make regular backup for your mdf and ldf files (Full SQL Backup and Incremental SQL Backup) you these 2 files will grow with Very small size

what is your total RAM? because 40 M is so so little for SQL Server

I don't think that there is something like That in SQL Server.

I think you have to Make Audit Table in your Database and in every trigger in all tables, add...

it is recommended not to use any other program on the SQL Server machine.

because SQL Server is monster in dealing with data ...

if there is any other program...

I am sorry there is no Encrypt for Tables in SQL Server 2000 !!

you can use stored procedures, views, and functions and apply "With Encryption" to them.

Also there is a...

I think there is a problem with SQL Server Provider on your machine

first install MDAC 2.7 and its SP1

then install SQL Server SP3a

I hope this help u

what about deattaching the db .. and then attaching it (from query analyzer) and supply a new name in your code ?

do u apply SQL Server SP3a on the server?.. also apply MDAC 2.7 SP1 (if you want )

i hope this solve the problem

what about encryption the whole table ?

do you test to do this with making Full bckup then make a restore from this full backup ..?

what is the programming language you use in your Application ?

try to use (NOLOCK) in table hint when you select data from table

I hope this help u

here is SP_who3 which may help u more

sp_who3

By: racosta

Like sp_who2 but this one let's you specify to filter by spid, login, hostname and dbname.

Like any system procedure, can be...

if you are using MDAC 2.7 then install MDAC 2.7 RTM refresh SP1 on both servers and restart them.

I hope this help u.

hoe do u call this stored procedure in Access Data project ?

you have to use an Anti-virus program to check if there any virus hit the server (if this happened, regestery may be affested, some files may be deleted, Memory will...