the best way to remove SQL Server is to :

1- Put your Setup CD of your SQL Server

2- make a steps as you install a new DB server .....

if you have small memory on your computer (server), the best solution is to adjust SQL Server memory and make it FIXED

so in Enterprise manager do this:

1- right clcick on...

This is a reply of Jeremy (Member of SQL Magazine Forum) whuch works best with me when I want to shrink a DB (I suugest you to Make Log Backup...

This is a reply of Jeremy (Member of SQL Magazine Forum) whuch works best with me when I want to shrink a DB (I suugest you to Make Log Backup...

by the way, I use this last option in showing data in forms and in some reports

may be i am the guy who suggest path-through queries

I use path through in dealing with reports .. that open frequently changed/ inserted data tables  .....

here is the solution of the Hang Problem between Access and SQL server 2000 or 7

When you want a report which based on...

execuse me, but what is Log Explorer for SQL Server ?

i try now to convert the column to decimal(18,0) .. but does this will be fast in inner Join (if the 2 columns are decimal) ?

i need this accuracy because it is a cheque number ..

what about if i change the column to long integer ? .. does the result will be accurate

please write down your problem

thanks babuganesh2000 very much, and also  jgoodwin for your help  

are there any other books or sites ?

restore Backup from enterprise manager

to restore many backups ,  open enterprise manager and do this :

1- Right-click on your database and choose (All tasks) >> restore Database

2- in general tape...

i think also that you can write into txt files (file for every table) ..

i also see TOAD for SQL Server Server .. it is very good but does...

what about incearseing RAM with this server and other server you query ?