We do have a CMS server today. There are two primary challenges with a CMS server. The first challenge is a CMS server only works with Windows authentication....

I just tested creating a SYNONYM and it worked exactly as I needed. Thank you very much for your help!

Creating an alias sounds like a brilliant idea. However, I am not familiar with creating a table based alias. Can you include some instructions to point me in...

Thank you both for your responses. That helps clear things up immensely.

Chuck, as you suggested, I tried the following.

SET @PersonID = SCOPE_IDENTITY()

instead of

SET @PersonID = (SELECT SCOPE_IDENTITY() PersonID)

Unfortunately, both styles produced the same results.

Steve, it appears that we are able...

Although we have several tables that have sufficiently unique data, the People table is a perfect example of a table where that is not the case. Thank you for...

We have tried the following two approaches without any success. Each of the following approaches works when run via Query Analyzer, but not when executed via an ODBC call....

Chuck, unfortunately a stored procedure yields the same results. The insert in the stored procedure passes directly to the SQL server whereas the following SELECT statement in the stored...

For reference, we are not able to use either @@IDENTITY or IDENT_CURRENT('TableName') for the following reasons.

@@IDENTITY - We have triggers on all of our tables to log all inserts, updates,...