If you are only storing the XML and not querying it or manipulating it in SQL Server, then I suggest you should use VARBINARY(MAX) rather than the XML data...

> Quick question, if you are using the XML within SQL Server, why do you need the version/encoding header element?

Via the frontend, the data is loaded into an editor. Once the...

Hello Mr. Fritchey

Thank you for the confirmation and summary for my questions.

The XML documents - better say snippets - are validated in the software, not on the SQL server as...

I think...

Hello Phil!

This is not correct, as you'll see from this page: " The Integration Services service ... is not required to create, save,...

I'm pretty sure that SSDT does...

@Lynn Pettis: Thank you for the explanation of the PLC, I should have added the explanation in my first post.

@john-2 Mitchell-245523

Once they're in there,...

I think I found a solution for my problem

SET NOCOUNT ON

DECLARE @userHost varchar(50)

DECLARE @hostName varchar(50)

DECLARE @result bit

CREATE TABLE #sp_who2

(

SPID INT,

Status VARCHAR(1000)...

Found a solution for this in the configuration of the sqlsrv.

Before the connection is opened via sqlsrv_connect i execute "sqlsrv_configure('WarningsReturnAsErrors', 0)";

Now I get the result from the SP that...

I apologize if it was not clear in my first post.

The central server (standard edition) would be the publisher.

Sql Server Express edition would be the subscriber.

Hello Steve!

Thank you for the reply.

Your suggestion is a way I already thought about. But I do not know if using replication and triggers is accepted by the client....

Hello Erland!

I have to admit that I am only working <1% of my time on administrative tasks within the SQL server. The temptation to use the GUI is to big...

Hello GilaMonster!

Thank you very much for your help.

I have already considered to build a test lab.

Hello GilaMonster!

Thank you for the fast answer.

The key values are not updated. Local inserts will not be allowed. It is no problem if the local changes are overwritten by...