Upgrading SQL

What is the difference between SQL 2005 Express and SQL Enterprise.

Can I make Unlimited amount of sales transaction using SQL 2005 Express???? Does SQL 2005 Express have a limit amount of transactions??????

Reply to
Trinidave
Loading thread data ...

I don't think you need to worry about a transaction limit. The limit to be worried about is the database size with SQL Express. If you regularly purge logs and journals, it would take a LOT of transactions to meet the limits.

How many transactions are you talking about? "Unlimited" is a little open ended.

Reply to
Jason

Reply to
Cribstoteens

There would be a way to do this but it is way beyond my sql knowledge, someone else may be able to help you.

The simple way is to backup your database before delet> Is there any way to write a query to archive the journals, or can you only

Reply to
Gaz

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.