I would change the page to use a a stored procedure to do whatever the page is doing. Passing in data to be inserted, updated or deleted using variables will...

Does your company have a system admin. If so maybe they could help you gain access using the instructions in the link Sue H. posted. Once you have access using...

The dbo schema is a schema, the dbo user is a user that owns the dbo schema and is a member of the db_owner role by default. A user and...

What other roles does the use in question have?

Use a staging table with the date column defined as varchar to load to initially. Then use a select with a case that changes the date to something in the...

SELECT s.row_count
FROM sys.tables t
JOIN sys.dm_db_partition_stats s
ON t.object_id = s.object_id
WHERE t.name='Your table name'
AND t.schema_id=Schema_Id('Your table schema')This returns the row count of a table. I have...

Schema qualifying in your t-sql code is a best practice. I recommend getting into the the habit of specifying the schema in all your SQL.

Hello Carlton,
Please post your sample data in the form of create table and inserts scripts, what you've tried, any error messages and desired result with the sample data you...

Perhaps on your system datetime2 defaults to datetime2(2)  or (1)
SELECT Cast(SysDateTime() AS date) Dt;

SELECT Cast(SysDateTime() AS datetime) Dt;

SELECT Cast(SysDateTime() AS...

Try something like this:
WITH
 t
(ColName, ColValue)
AS
 (
  SELECT
   b
   , c
  FROM
   (
    VALUES
     ( 'itemClass'
      , 'yard'
     )
     , ( 'itemType'
      , 'SAL'
     )
     , ( 'employeeId'
      , 'tony'
     )
     , ( 'stationId'
      ,...

How many cores on the server and how many files does tempdb have? I'm wondering if this could be related to allocation page contention.

At a command prompt:
setspn -A MSSQLSvc/myhost.redmond.microsoft.com redmond\accountname
Of course replace the myhost.redmond.microsoft.com with the name used in the connection string used by the application and redmond\accountname with the domain account.
If...

Register an SPN under the domain account for the name the application is using in it's connection string.

Please post create table an inserts with sample data for both tables.

A computed column can't access the data in another table in the computation. You need a view, table valued function or a procedure.