It really is a slowly changing dimension, but in an OLTP system, I think it fits more as an auditing item as Jeff mentioned.

I'd store it separately as it's entered...

varchar is not Unicode.

You can change the data type, but any unicode data would be lost or cause errors during the conversion. Only the N data types (ntext, nvarchar, nchar)...

I have seen this before and it is frustrating. Try a stored procedure and see if you can get it to behave better. Also, are you executing the same query,...

Very interesting link. Did it help? Are you XP -> XP?

I haven't seen this error, but the guest user makes some sense.

Or let us know what ytou are trying to achieve. Are you looking to admin? develop software? What areas are you thinking you need to learn.

If it's true/false, then don't allow NULLs. confuses things.

I'd still recommend going with tinyint, gives you more options down the road. I've often seen someone define something a boolean, only...

I was thinking that the only way to do this was to query for known user and then strip out the domain name.

There are some AD stored procedures, but they...

Thanks for the update and glad it appears to be working.

And kudos again for using SQL Server at UCF!

You don't need the ELSE clause. If the parameter is not null, it's value will be already assigned.

Do you care which 4000?

You could insert 4000 PKs from the patient table into some new table, then set up a replication that filters based on those PKs. Or copy...

You might run PRofiler and filter based on the db, table, or some other object that you think is involved. Or just run it and then stop it when you...

Try this: http://www.sqlservercentral.com/articles/Integration+Services/61619/

I think this is a distributed transaction problem. Is there any reason you have it wrapped in a transaction there? Any error should throw a rollback anyway.

Does it complete? Could...

Almost went to Earl for an old car, but couldn't bring myself to do it.

We're POTS here (With DSL riding along). Still find uses for the line, especially as so...

clustered keys and primary keys have nothing to do with each other. the PK can be clustered or non-clustered and if someone thinks it's always clustered, either he doesn't understand...