First off it is a myth that changing datatypes will have any significant size impact, unless you make a significant change in the total average length of a row. However if...

btnpress_click

conn.open

try

 (process to do)

Catch ex As Exception

finally

 (check conn state to make sure not closed already for cleaner exit)

 conn.close

end try

end sub (btnpress_click)

Use finally (which vb.net does not add for you) to...

Just another option

SELECT

 A.PATIENT,

 A.PROV

FROM

 @Appt A

INNER JOIN

 (

  SELECT

   PATIENT,

   MIN(SER_DT) SER_DT

  FROM

   @Appt oX

  WHERE

    (SELECT COUNT(DISTINCT PROV) FROM (SELECT TOP 3 PROV, SER_DT FROM @appt iX WHERE iX.PATIENT = oX.PATIENT AND iX.SER_DT >= oX.SER_DT...

Do you have a datetime column to time stamp the rows at entry so they can be identified or do you have some other way to identify the records as...

In that scenario a new connection will be generated for all concurrent needs. So if all 200 hit at the same exact moment you get 2000 connections but say your...

Could be but what I refer to is that say for instance you have these 25 connections (which could be pooled btw way so don't assume it is actively open...

As I recall it is in the registry not in SQL Server.

Actually this could be pointing to a connection issue related to number of open connections. Remember each connection takes roughly 50k to 100k of memory when created, check the number...

OK here are my thoughts first you are talking about people some being customers and some as contacts for those customers.

But I ask this,

 Can a customer have more...

I would never assume it worked. Instead if possible do a test restore somewhere else to make sure. If is then you need to figure out why this message is...

Was the database in read only before doing this? If so you cannot do it as the server cannot load sever related data into the database at the same time...

What error do you get? And what version of SQL are you runing this against?

Depended on the version of SQL Server 7 you were after.

The only one I can remember for sure was the Desktop edition which could handle 5 concurrent connections was...

1) The answer is no.

2) It should have the same password. But I don't have my test server configured in a way here I can use the task. Simply create...

You'll forget, lord knows I do almost everytime.