Let me repost my question again.

From my understanding, databases with a high number of users use a single login to gain access to the database then reference a user table...

Btw, I finally got it to connect.  I added the Identity line in Web Config to Inpersonate my network logon, and set the ISS Anynomous Access account = my network logon.

Thanks for...

Ok, I changed the anonymous access back to the default: IUSER_Workstation and then added this account to sql server.

This is the message I get now:

An error has occurred while establishing...

I doubled checked and tested connecting w/ Query Analyzer successfully.

.Net 1.1 & SQL 2000

server does not exist or access denied. (This is the error)

IIS:  Intergrated Windows Authencation is checked.  I...

Connection String that is generated:

workstation id=xxxxxxx;packet size=4096;integrated security=SSPI;data source=ServerName;persist security info=False;initial catalog=Test_Database

I have tried this with VB.Net & C# (Visual Studio 2003). I have also tried...

Got it.... Thanks.

How will I assign a Value to @X without a select statement in the remote SP??

MarkusB,

Thanks for the reply. Where do you access Triggers for Views.  I can't seem to find it.

Thanks. 

Sorry,

I am not sure what I did the first time I ran the update code with the query analyzer, but I tried it again and got the same error mentioned...

Thanks for the responses.  As it turned out I will have to reference fields for WHERE conditions in most of the tables that I would  be split.  Therefore, I...

Another developer made a comment about reducing the size of that table for performance reasons.  The data inside the table makes up a 'Project', but is kind of made of...