Personaly I had the oportunity to work with a billion row (1000000000) database tables before. Yes Partitioning was used but on the SAME Server!

 Becareful with splitting that into multiple servers and...

Dynamic Search Conditions

do you mind to write: SET NOCOUNT ON at the begining of the procedure ? 

I don't use NetApp but as far as I know NAS has very limmited support in SQL Server!

Take a look  at: Support for Network Database...

The alternate background is very easy to create by simply specifying in the format event the background color. In your case all you need to do to  keep a boolean...

Don't have a lot of time to speed this up but at least is going to give you what you need:

select item_id,( select  count(distinct prod_id )

    from prod p1

    where...

Robert,

1. Triggers should ALWAYS be coded to handle Multiple row insertion/delete/update

2. I see a pattern in your code so I believe you can probably arrive to formulas directly from the...

Or use an SP instead of a trigger

Happy to Help

USE MSDE!

1. Its free

2. Link each mdb as linked servers

3. Write your queries in sql !

DBCC USEROPTIONS

Just check the procedure:

css_ety_id_children

If if uses an insert exec in it you can't nested on the outer like:

insert into #tmpgetety01 exec css_ety_id_children  ...

The error is pretty clear:

You Can not nest insert exec commands

In other words: if p1 uses insert exec in it the following is not allowed

create proc p2 as

insert exec...

Definitely the Driver Manager you have is OLD!

You need to Apply the latest MDAC if Possible!

exec sp_helprolemember @rolename = 'db_owner'

exec sp_helpsrvrolmember @srvrolename ='sysadmin'

exec sp_helpsrvrolmember @srvrolename ='dbcreator'