I just got away from the healthcare industry.  Haven't ever slept better.  Your question reminded me of a HIPAA-compliant claims clearinghouse I built.

More exceptions than rules.

Have Fun!

jg

Yikes, this gives me nightmares.  Once again, the "patient relationship to insured" rears its ugly head. 

I would like to point out that, although Access is not a bad choice for the solution, it is a potentially dangerous tool in the wrong hands.

Clearly, you can give...

And another "bit" of useful information:

If you place an index on a bit column, the optimizer will not properly choose that index if you use a literal '0' or '1'...

Could be that you were seeing phantom errors caused by naughty behavior from caching disk controllers.

I once had a SAN, an MSA1000, to be exact.  In order to make the 605...

Aparece que la problema esta asi:

Falta uno o mas "backups" de "transaction log".

o

Que ha tratado a "restore" en orden malo los "backups" de "transaction log".

Es muy possible que no poderia entender...

I should hope not. 

Now, to rephrase it so as not to appear amusing:

If, for whatever reason, the policies in place at an organization would permit changes to a system...

Greg,

Try registering sqldmo.dll from the reinstalled binary directory. see if that does anything.

Good Luck  jg

If you have to ask the question, the O/S is the LEAST of your worries.

<insert favorite winking emoticon>

I have to agree with Ed on this.  Nobody ever got fired because they made their test environment just like production.  Or at least as close as possible.

Now, you may...

Let's play:

--begin playing

declare @Foo table

(ID

 int identity(1,1) primary key,

 --uniqueidentifier  default(NEWID()) primary key,

data char(8000))

set nocount on

Declare @bar int

Declare @bat datetime

Select @bat = getdate()

Select @bar =0

while...

Patrick.  You hit the nail on the head.  There's a new law requiring a minimum size nail in bridge construction.  What is that size?

What is happening is that the concatenation of a character type and a numeric type results in an integer type in SQL-Land.  So, as hinted in the post above, you need...

Question does not allow the correct answer, which is ZERO.

Time cannot be moved or altered.  The representation of time may be altered, but not time itself.

/disgruntled bad guesser I am

I wonder if the last date shows when the file was created -or- when the file grows.  Never checked, but that might do it as well.