Even though doing these sorts of things are terrible to do through SQL Server, what's the actual path of batch file you're attempting to execute? It looks as though it...

There's a simple answer to this: The message about NT AUTHORITY\ANONYMOUS LOGON is because you're asking the Report Server web service to check the permissions using its account, which runs...

If you are running an Integration Services package from within Management Studio, it's going to run under the account you connect to the server with via SMSS, but when you...

Short answer: Yes, commonly poor programming.

Longer answer: If there's someone where you work, and whom you trust, that can assure you that network capacity isn't being tested, then it would...

There is another way to do it using MERGE. I actually prefer this way, because it's a little more intuitive, being able to specify WHEN MATCHED and WHEN NOT MATCHED....

Here's a script and its execution plan containing the estimated stats for testing two different ways of inserting data into a table (INSERT vs SELECT INTO). I've used SQL Sentry...