Duplicate of https://www.sqlservercentral.com/Forums/2011336/How-to-run-procedure-from-remote-server-without-linked-server. Please direct answers there.

Technically, no, however, the latter is the ANSI-89 syntax and some features of it are no longer supported (OUTER joins for example). The other is the ANSI-92 and you should...

Without that sample data I can only throw out ideas. Maybe a candidate for an EXISTS clause in the WHERE.

I'm afraid your statement doesn't made much sense. Maybe you mean DISTINCT, maybe you mean the latest entry, maybe something else?

There appears to be a language barrier here,...

This is difficult in envisage based on your limit sample. The 3rd option appear to be the normalised option however. The 1st one will be awful to work with (you'll...

If you're on the local host, then the only reason you can't connect with the sa password is 1 of a few reasons:

• You entered the wrong address for the server...

Personally, rather than using a Script Task and coding manually, I would use a For Each Loop. Then, if you enter the loop, you know that there are files. If...

Your query (below) is in the right format:
Delete From where DateID >= (Convert (char(8) ,?, 112))
If, however, you are storing your DateID as a...

If you can't ser the attempt, this strongly suggest that the connection attempt never reached the server. Have you tried connecting again after the browser has been enabled?

Can you post some sampel data which we can consume please (with DDL and DML statements) please? I doubt you need to nested sub queries here, so if we can...

Would still be nice if STRING_SPLIT had the ordinal value; a guaranteed method of getting the result set in the same order it was supplied in often really important. It's...