MSOLEDBSQL is the recommended provider. SQL Server Native Client is deprecated, apparently since 2014.

Microsoft has been vacillating on data provider recommendations since at least the introduction of .NET.

SQL Server...

That doesn't look like SQL Server error message or syntax. What database system are you using?

(Always best to identify the system when you're posting a question that might require that...

In windows, you'd use ODBC Data Sources or ODBC Administrator (32 bit or 64 bit).

System ODBC data sources are stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC. INI .

User ODBC data sources are stored in HKEY_CURRENT_USER\Software\ODBC\ODBC

File DSN data...

The conceptual model is too high level for data dictionary -- it's just a definition of entities. You'll often find that evaluating attributes sometimes leads to a better understanding of...

"You may find, for example, that many users require detailed information to perform their work, whereas others need only summary information to help them make strategic decisions for the organisation....

"5. Determine and define business rules. You conduct interviews with users and management to identify constraints that must be imposed upon the data in the database. The manner in which...

ratbak wrote:Why are you using both Ticket ID & Ticket Number as primary key for both Ticket & Response, and as the foreign key between the two?

The idea is that they...

If you mean don't show what is in the temp table, then just don't select from the temp table.

If you mean something else, please explain..

What is Ticket ID, and why is it a tinyint? The name implies it's a unique ID. A tinyint would only allow 256 tickets (0-255). If it's a type or...

Do you mean that with dynamic SQL it is somehow possible to do FOREACH or write less code?

Dynamic SQL could achieve the "writing less code" goal using something like this:

No, SQL Server doesn't let you pass tables or columns as parameters. You could derive something like this using dynamic SQL.

But I might also we concerned about protentional blocking when...

You have no indexes, so you are forcing the query engine to scan the entire tables.

Yes, not equals/not in/not exists can be less efficient than equals/in/exists, but with proper indexing...

One True Lookup Table:

https://www.sqlservercentral.com/forums/topic/is-having-a-lookup-table-that-is-for-multiple-entities-a-common-practice

In addition to other concerns, to me, I tend to view lookup tables themselves as an entity. If they contain unrelated "things", they are not normalized. And...

You would have to use a user-defined function to reference columns in other tables (which could have performance impacts).

Your table design may be wrong if you have a column value...

Hosts file alias?

SQL Native client alias?

CNAME or AD computer name alias?