Thanks for the responses.  I will put it use asap.

It would be easier for a region table in this example, but all organizations will need to be in the same table for other reasons.

Thanks

Thanks for the replys.

I had changed the default port in the past, but it wouldn't let me the other day.  When I would Restart the SQL Sevice Mgr it would...

John,  

Host_Name() comes the closest, but it only gives me the PC name.

Thanks for the responses.

John,

That gives me the database user, which all of the users will be using the same one.  I would like to capture their Windows Login Name so the DB can...

Goce....I like it.  It is much more clean and less complicated than trying to build the dynamic string.  I will give it a try.

Thanks.

Just to update those who replied.  The database runs faster than I would have thought.  The design that I came up with was to only pull in the Main text...

I will have 4 fields that have open text, which I plan on making a varchar type and limit to 8000 chars. One of these fields is a 'Notes' field...

Noel/John,

Thanks for the advice I will implement your suggestions.  That may explain the odd behavior with the @@rowcount value that I received as well.

BTW Noel, could you be more specific...

Problem Solved.

***Double Post****

Thanks for the replys.

Bimal your not exists statement might just me the answer to this problem as well as some others...Thanks.

Thanks Brian!

I did not realize the builtin\Administrators used the operating system Administrator's Group.  I guess it shows I have a lot to learn about managing roles, among other things.

You certainly...

Can't find the user anywhere on the server.(Roles, Logins, Groups or System tables)  Wouldn't they have to be in some system table????

Thanks you all for the Help.

Grasshopper:

 I tried using the DateADD Function but I couldn't get it to subtract days.  Maybe there is a better way to do what I am...