The best way is to have the ASP page call a stored procedure that requires the value.

This is a SQL Server 2008 forum. I don't think you are posting in the right forum.

With that being the case, I am not sure which is best. Now you are down to which is easiest to manage and how you are going to version...

My understanding is that you want SQL2008 to be the default instance. If this is correct, you can uninstall SQL2005, install SQL2008, and attach the database. Make sure...

There is no way to delete the cache directly unless you want to develop an application that does so using the SOAP API.

If your cache is filling up quickly, I...

If you have the capability to take the production database down, detach, copy, and then attach the database on the new server, that would be fastest and safest.

Another question raised by the frequent editing is whether you need to track the file versions as changes are made.

I went with the storing of file paths in the database and then using the application to read the path and open the file. This was mostly because I...

We have many procs that need to run in multiple databases. What we do is use MultiScript to push those out to the databases.

The procs are then run by...

The catch to using both is going to be the need to track the file size and somehow let the application know where to store or get each file based...

Nothing is a clean as it should be, even when following the prescribed procedure. SQL Server is quite complicated.

Cleanest is still to uninstall and re-install SQL Server. Quite...

It almost sounds like you may want to look at the new Changed Data Capture functionality. This keeps track of changes to specific columns with a table.

Here is a...

I will see if I still have the notes on it. That was around two years ago so don't know if I can find them.

You COULD do that, and it should work most of the time. However, you will experience difficulties if any of the stored procedures need to access user-defined types and...

Just so I understand...

You are developing a financial application and want something to work for now, hoping it will work in the future? I have developed financial applications and...