What is the structure of your tables?

You could import all of the zip codes into a temp table and then use a join to determin which zip codes needed to...

For your first situation, if you are only interested in a few tables which are updated at one site only, transaction replication sounds best.

If your data is being updated at...

How about creating your DTS job, creating a SQL Agent job for it with no schedule, and then using sp_start_job to execute?

I know that it's more work to maintain, but I prefer to get scripts from vendors. Of course if all of the databases are on your server and not...

Sounds like you want to use replication, probably log shipping.

Assuming that you have only 2 Subject Texts for each PubID:

select PubID, min(SubjectText), max(SubjectText)

From TableA

Group by PubID

use sp_executesql with an output parameter, like this:

declare @sqlstr nvarchar(4000)

declare @params nvarchar(4000)

declare @total_rows numeric(12,0)

declare @percent numeric(10,2)

select @sqlstr = 'select @total_rows=count(*) from master.dbo.sysobjects'

select @params = '@total_rows varchar(255)...

Just an aside. You would have to have some roles affected for the trigger to be fired, would you not? You could never have a count(*) = 0...

I think that it is worth mentioning that you should not use cursors in triggers. The reason is that you want triggers to complete their actions as quickly as...

I don't consider that large either. I only made the mention of threads to partially answer your question about io. It's purely academic.

Frankly, I wouldn't consider splitting it...

Sub queries shouldn't make a difference. This query should return a single result set, not two result sets which are processed on the client.

Another consideration is that the more files you use, the more threads SQL Server uses to peform reads of the files. Thus if you have very large tables, you...

Ideally, you should have at least four partitions: system, swap space (virtual memory), SQL log and SQL data. Data should be RAID 5. The others should be...

Why does each account need its own database?

Killing the Backup Exec process (restarting the service) on the other machine should take care of it. If there is a SQL Server scheduled task, restarting SQL Agent should...