Here some info from MS.

http://support.microsoft.com/kb/309422

Ok, thank you sir, I'll continue to explore this. My primary goal is to minimize the potential impacts to the application using the primary database from my reporting and ad...

Ok let me refine my question. If I redirect select statements to the replicated database would the performance of the primary possibly be be improved. Sure at the server level...

>>One way that might work is to do the data entry GUI in Access and then use Reporting Services

I concur.

If you can't use Reporting Services and must or want...

I think this was actually low C drive space. Once this was rectified the phantom failures stopped. I did educate myself on performance monitor and SQL counters for future...

Am I over complicating the string extraction? I want the text between the first and second occurrences of '.'

DECLARE @paths TABLE(path varchar(50))

INSERT INTO @paths

SELECT '.ab.qwer.poi' UNION

SELECT '.1.qwerty.ab' UNION

SELECT '.1234567890.asd.a'

SELECT

path,

LEFT

(

RIGHT

(

path,LEN(path)-1

)

,

charindex('.',RIGHT(path,LEN(path)-2)

)

)...

Access has had master/detail or parent/child forms since at least Access 97.

http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx

So after gleaning that this problem may be solved by a recursive CTE I landed here.

http://stackoverflow.com/questions/6224564/flattening-out-a-group-membership-tree-in-sql-with-cyclic-references

The following seems to work. I am still studying this solution since it...

This is what I have tried but this won't handle multiple levels. Is this the recursion rabbit hole?

DECLARE @GroupCode varchar(20)

SET @GroupCode = 'A'

SELECT DISTINCT

Member

FROM

(

SELECT

Member

FROM Groups G

INNER JOIN GroupMembers GM

ON...

Thanks for your response. My procedure has two result sets. Each result set has a different structure. My temp table is matching the first structure. Shouldn't the second result set...

It's still hard to beat Access as rapid application development environment for building data entry forms. If your access tables are properly normalized and have proper keys you can import...

Yes, its called a data driven subscription.

http://msdn.microsoft.com/en-us/library/ms169673.aspx

I believe you need Enterprise Edition for this.

If I understand correctly the procedure is called multiple times until all rows are processed. Every time its called it needs to join with the large remote data set. I...

Can you put the procedure on the remote server and call it from your primary? That has worked fro me in some scenarios.

EXEC RemoteServer.RemoteDB.dbo.MyProc

Thank you all once again.