Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 30859

A widely-used open-source operating system that is particularly popular on servers.

15 votes
Accepted

SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

I had been researching if SQLCLR on Linux would have access to the app.Config file like it does in Windows (sadly, it does not: SQL Server 2017 on Linux ignores app config file if it exists, or sometimes …
Solomon Rutzky's user avatar
2 votes

Why does sqlcmd truncate varbinary(max)?

What you are seeing is not truncation; it must be a bug. Neither 0x4D5A90x07585 nor 0x4D5A90x075850x167D00x043CB are valid binary values. The 0x should only be present once (at most), on the far left, …
Solomon Rutzky's user avatar
7 votes
Accepted

bcp command Incorrect syntax near '�'. Character is actually: "ä"

SQL Server expects UTF-16 Little Endian, but Linux isn't using that. The default for my Linux VM is UTF-8 via en_GB.UTF-8. …
Solomon Rutzky's user avatar
5 votes
Accepted

Permissions issue in Docker SQL Server 2017 while restoring certificate

Is the code shown under "Relevant code:" (in the question) the exact code being executed, as in copied and pasted into here and not re-typed? I ask because the file extension on the sqlserver_backup_c …
Solomon Rutzky's user avatar
11 votes
Accepted

How do you directly modify the system catalogs in SQL Server 2017?

You can do this in a SQLCMD interactive session by running the following in a Command Prompt window: sqlcmd -S admin:localhost -U sa If the Linux SQLCMD doesn't support this for some reason, you can … You can enable DAC on Linux with,: EXEC sp_configure 'remote admin connections', 1; RECONFIGURE; In that DB, try something like the following: UPDATE sys. …
Solomon Rutzky's user avatar
7 votes
Accepted

Export to format compatible with SQL Server

Is there a more reliable intermediary format that could be generated from Linux/OSX? For example MySQL dump, Excel, Sqlite, XML, etc? … Seeing as how this data is coming from "Linux/OSX", I would expect the default encoding to be UTF-8. …
Solomon Rutzky's user avatar