Welcome to SSC Waqar

You've already got what you need in the Sales table, multiple Qty and Price, and join back to ItemPrice table to get the item description.

Increase the size of the PRIMARY filegroups files or set autogrowth to on.

Can you post the output of sp_helpfile when run inside the database context, or a screenshot...

Looks like the identity specification hasn't been set so its trying to insert UniqueID into ID.

instrument

Depends if its a named instance or not.

If its a default instance its just SERVERNAME

If its a named instance its SERVERNAME\INSTANCENAME

You will need to...

The username and password, is that purely for the VPN portal or is it a domain account on their network.  If it is only portal you need to ask them...

You need to setup a maintenance schedule.

Lots of ways to do it, write your own, use maintenance plans, Ola's maintenance solution, Minion Ware, Red-Gate tools, Quest tools, Idera...

ALTER DATABASE InstanceMonitor SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE InstanceMonitor SET ENABLE_BROKER
GO
ALTER DATABASE InstanceMonitor SET MULTI_USER
GO
USE InstanceMonitor
GO
IF OBJECT_ID('DeadlockEvents', 'U') IS NOT...

Go try it, but yes that is most likely the cause of you issue.