I have several servers here like that. I have SSMS on my PC and connect to them from that. If a remote connection isn't possible then probably Powershell.

https://technet.microsoft.com/en-us/library/ee441255(v=ws.10).aspx

That's an impressive list of things that it doesn't like. However, it does look very useful for guarding credit card, bank account details and suchlike.

It is possible to write all replication activity to a text file, but it can get rather large very quickly for the most detailed logging - http://wp.me/p3Vxvi-bx

This might help to...

If you want to replace the entire table contents then you could simply truncate the table beforehand.

You can import as many files as you wish and move the data to...

Here's one I've never seen before - every thread on a full page of the search started by the same person.

Someone is very busy.

Thanks Sergiy - the simplest solution of all and it simply hadn't occurred to me.

Oh, I know Tom, but I think it just touched a nerve this morning. I spent about an hour playing with the code, searching for articles related to the issue,...

I don't think that your answer is right. I believe that your answer is wrong.

I don't know what the answer is.

Helpful, so very, very helpful.

Tell me I'm wrong but...

I suspect that using the Czech character set requires that you use Unicode - NVarChar works fine, as does (on my machine)

SELECT * FROM @TESTTABLE WHERE KOD LIKE 'CI%'...

It was indeed, thank you very much.

So each year is about a week for me? Yes, that feels about right.

No it wasn't, not in the slightest. If anything I was having a dig at myself. One of the many voices in my head loves to tell me when I've...

Hence the word 'Informix' in the error message. Obvious now, thanks.

A simple issue, but I'm not having much success.

Could somebody have a look at http://www.sqlservercentral.com/Forums/Topic1740538-391-1.aspx#bm1740579 please?

Either the driver they're using doesn't allow some the solution I'm suggesting, or they're...

That was just an example, using a SQL Server date function.

What does FORMAT(create_dtim,'dd-MM-yyyy')do?