Well do the tables have the same structure, or does the retrieved information have the same structure?

Can you make your SELECT statements so that they do return same structured recordsets?

You...

I would be tempted to have a category table with:

• CategoryId
• ParentCategoryId
• CategoryName
• ...etc

This means that your category table becomes an extensible tree so when when a marketing type decides they want sub-sub-sub-sub categories...

It has been a while since I did old fashioned ASP but there was a NextRecordSet method on a RecordSet object.

FirstRs.Open "YourProc"

Set SecondRs = FirstRs.NextRecordset

I tend to have the SA as the explicit dbo user. It is the one login that is common across all servers.

You also have the db_owner role which multiple...

We have something called the data protection act in the UK which is a toothless attempt to block this sort of thing.

Why toothless? Because the government decided to allow...

My experience is that database servers tend to have more robust perimeter security than other servers.

IIS on the other hand is more likely to be public facing and therefore be...

Not least because the blasted thing locks records blocking other processes as a result

Try RESTORE VERIFYONLY FROM

What tool are you using to enter the information?

AN INSERT or UPDATE statement will allow the full 8,000 however I think there is a limit on the datagrid used by...

Well if your 3 databases are on one server I am not sure that it makes a difference.

My personal preference from the information given would be to place the proc...

Thanks to everyone who has posted.

One feature I would really like to see on SQL Server Central (but it is in the big bucks content management arean) is the ability...

I've done a lot of work with web CMS and doc management systems and many of those store binary objects in the DB.

This is done so that those systems can...

I must admit I didn't look at the possibility of a high initial value but with a small range.

Following it through logically all the selects would come into play so...

Certain facilities (such as full text indexes) require there to be a primary key on a table.

Quickest way, without indexes or scripting is

SELECT * INTO tblReturn FROM tblDelivery WHERE 1=0

not sure why you are getting the error you mention. If you are doing a search/replace...