I played around with database encryption some time ago.  You don't encrypt a column, per se.  You encrypt the data before you insert it into the table.  Check for varbinary...

Heh.  Doing all the calculations on the front end reminds me of how many applications I have encountered where the quote was "We maintain referential integrity in the application."

Thank you, all.  I'll see if I can dredge up more.

Most likely not.  The application would have to pass the (web) user's name to the SQL Layer.  SQL Server can only see the communication between the web server and the...

What I am getting out of the listing above, is that you have two instances of the procedure KSE.dbo.DequeueOrders running at the same time.  These two procedures are colliding on...

What is it that you would like to change?  Can you connect to the SQL Server?  If not, then you can use SQL Configuration Manager to set the right IP...

I am a little confused.  You started with a linked server named RefreshDB, but it morphed into RefreshDatabases, or was that another test? 

Also, ServerA was the server...

No, it is OK.  All null means no database is currently mirrored.

Have you tried doing this with the commands?  The commands are actually fairly simple.  Once the database...

Thanks, Steve.  I will submit the draft, now.  If anything looks out of line, feel free to let me know.

I can see a non-update like that being optimized to a NOP.  You may need to use a function or two in a non-intrusive way to get the updates across. ...

The command you would be looking for is DBCC CHECKIDENT.  Here is the link: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkident-transact-sql.  Best bet would be to run something like:
select 'dbcc checkident(''' +...

The normal culprits for this sort of thing are pop-up boxes, and prompts for user input.  I am assuming there are none of these, as you have run the packages...

That is expected for the standby copy of the database.  What do you get for the database in
select *
from sys.database_mirroring

You can add a case statement that checks for blue or red.  Something like:

case when t1.cardescription like '% blue %' then 'Blue'
     when t1.cardescription...

If I recall (I don't have a test setup for this), you just need to grant CREATE TABLE (PROCEDURE, VIEW, etc.) to the login, then grant CONTROL on the schemas...