I think there is a script here in http://www.sqlservercentral.com that make this log (History) table and make Trigers on all table.. Search for it on this site.

what about making table and insert wanted Rows in it ..  and Give numbers beside it (1,2,3) .. and loop through it ...

by the way , i think that reindex DB make backup file after it bigger in size ..

do u do this?

by the way, the best way to remove SQL Server is to :

1- Put your Setup CD of your SQL Server Enterprise Ed.

2- make a steps as you install a...

do u append on your backup File ? this may be the reason of your problem

Also .. try to Shrink your Db ... and everything will be fine after that

I...

First try to shrink Db (with Log also)

second it is recommended to make backup due to your Insertion and updates time .. for me :

1- i make full backup everyday

2-...

Please read this carefully:

When you want a report which based on complicated queries joined from several tables, These tables are updated frequently, then you lock these tables (or you will...

I want to ask you a question

do you intend to migrate from Enterprise to Standard in the same Cmputer ?

by the way make a backup of your working Database...

what about writing

 Begin TRANSACTION

and

 Commit TRANSACTION

and

 ROLLBACK TRANSACTION

without giving name and transaction (Trans1)

and in inner Transaction .. just make an outer parameter (@err) that is 1 if Roll back happened .....

do u have SP3a installed ? it solve many problems in replications

also install MDAC 2.7 SP1 on all clients and cerver machines.

I hope this help u

what about going to EM .. then right click on your DB .. then choose (All Tasks) >> (Shronk DB)

then click on files and choose shrink file too the percentage...

try to install SP3a on server

and install MDAC 2.7 SP1 on both clients and server machines .. and this may solve most of your problems

why not to use DTS ... it will be more simple (from SQL Server) ?

why don't you store its path only (nvarchar) and then appear that image found in that path later.

also install :

1- MDAC 2.7 SP1 on server and clent machines

2- SQL Server SP3a on server machine

3- Jet SP8 on client machines

I hope this help u.