Unless you have a powerful server, I suspect "loads all the tables data into memory" may be a problem. You may be better off exporting the data to flat files,...

SSMS doesn't know you want to exclude copy-only backups when you are doing a restore using the GUI. It is allowable/valid to restore a copy-only backup. It might be nice...

Use DelimitedSplitN4K, instead

I started to suggest STRING_SPLIT until I noticed 2014. Definitely DelimitedSplitN4K over that loop.

krypto69: Is that function call only used once for a title, or are you using...

Google Search returned a couple of posts indicating it seemed to be SSRS error.

Check the install log files for details in cases of install errors. You might find more information...

No, don't mess w/ the system table.

Just use your own table, function, or hard-coded case statement for Creole -- or other unsupported languages (don't use a comma-delimited list -- use...

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: