Steve

Try something like this, but bear in mind:

(1) I don't recommend you use this in your application - just for the stopgap period

(2) I haven't included any WHERE clause logic,...

No, that's for client applications on the server. Go to SQL Server Network Configuration -> Protocols...

Does db_name exist on the remote server? Does table_name exist in the dbo schema in db_name? What happens if you go to the remote server and run the...

Ragu

Care to post the query, please? I'm guessing it's got a syntax error or something else that prevents it from compiling. Do you have direct access to the...

If you want to concentrate on connections, monitor the performance counter SQLServer: General Statistics – User Connections. For a more sophisticated analysis, you might also include other counters such...

Yes, the 2 is converted into a date - 3rd January 1900, so you'll always get Wednesday for that, no matter what your language settings.

John

Well, it works for me if I convert to nvarchar(23) instead of datetime, and make a couple of other minor tweaks, thus:

set @SQLQuery = 'SELECT RequestDate, IP, RequestID, CustomerID, LoanID,...

Why do you have [font="Courier New"]cast(@RequestDate as datetime)[/font] when @RequestDate is already datetime? Do you not want to cast it to nvarchar(23) or something like that? Better still...

Sounds like a job for the MERGE statement (although make sure you understand the pitfalls before you use it). I can't be any more specific, though, without table DDL...

It's just an alias for the virtual table [font="Courier...

Talib123 (6/10/2016)

---

Sounds more like a political issue rather than technical. It would seem you don't have the authority to govern the server in question.

You need to play a...

With that example there's no difference, so my advice would be to go with what's simplest. But if you were to put the dynamic SQL version into a stored...

Write a script in Powershell (or your favourite scripting language) that will take the most recent file and copy it to its destination. Alternatively, there's probably a task in...

No, I don't think so, unless you've already got something set up to track changes like that.

John

If n is small, it can be more efficient to use char(n). The storage requirement for varchar(n) includes a two-byte overhead to handle the variable length.

John