There are obviously some fundamentals that I do not understand wrt VS and
server group names.  In the end it doesn't make any difference to me as long
as VS considers what I have done as orthodox and it works.  Somehow, in the
past, I got it in my mind that there was some disadvantage or there was
something wrong in having a database in my local server.  Is this OK?  Does
it have to be or should it be in something else like NetSDK?  Am I in Okey
Dokey land by accessing my database in Local?

I should add, however, that I must have something wrong because when I go
into a particular project, the computer halts for a long time and finally
comes up with a connection dialog that makes reference to the old
P3800\NetSDK.  This is strange because no such directory even exists any
more.  There used to be a dir under my Microsoft SQL Server directory called
$NetSDK but it is history now.  How can I set things up so VS is happy with
it and it works too?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
ar_cs_9i5u.asp

Hope this help

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Could you explain this to me.  I have a situation where I have a database
named Invoices.  It shows up in two different InstanceNames.  I made a
change to the database from InstanceName_A.  I switched to InstanceName_B
and the change I made in A was reflected there.  How could this be?  Is it
simply because they are both pointing to the  same database?

Thank you for help and thank you for pointing me to the web site.  It
answered a number of questions.

Woody

[If I understand, VS.net itself created this instance when I installed,
correct?  Is this true in both VS 2002 and 2003?  If you do not already
have SQL Server installed on a local machine and you install VS.net 2003 or
2003 will it automatically create this instance name?]

Yes, your are right, This incidence will installed with VS.NET 2002 and
2003 whenever we have SQL server installed before.

[Could you explain this to me.  I have a situation where I have a database
named Invoices.  It shows up in two different InstanceNames.  I made a
change to the database from InstanceName_A.  I switched to InstanceName_B
and the change I made in A was reflected there.  How could this be?  Is it
simply because they are both pointing to the  same database?]

For a SQL server database, there will be two files will be created: .mdf
and .ldf. They store the data in the database and their log information.  
For example, the database "pubs" is on the two files: pubs.mdf and
pubs_log.ldf. You may check if your two instance share these database
files.

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)