add the user to the role db_datawriter.

Though not provided as an answer, sp_refreshsqlmodule can also refresh views;

sp_refreshsqlmodule

when the backup job fails, what are the error messages?

I have no idea what Venus is. However, you need to ensure that appropriate permissions are in place. Here's a simple way to find out:

Login to the...

ChrisM@Work (6/25/2015)

---

g.britton (6/24/2015)

---

Consider using CROSS...

Have you followed this:

If the SQL Server service account on your primary server runs under the local system account, you must create your backup folder on the primary server and...

run it a section at a time and verify the results at each step. You'll likely have an "aha!" moment.

Have you set up a proxy account for the job(s)?

You can't. The job needs to run with an agent proxy account that uses a Windows domain account with appropriate access.

Did you try Suggest Types under the Advanced in the Flat File Connection Manager Editor?

Interesting article though I wonder about a few things:

1. Using a recursive CTE to populate your test table is probably not the best idea. At least, I wouldn't want...

SQLArnold (6/25/2015)

---

I had the same concern, our team was also using this feature and when I researched and found the same warning on MSDN, Do not use this feature. This...

You missed a few things! (What's new in Sql server 2014

•Database Engine Feature Enhancements

?Memory-Optimized Tables (OK, you got this one!)

?SQL Server Data Files in Windows Azure

?Host a SQL Server...

I did some digging on this. Using 2012, this...

David Rueter (6/25/2015)

---

But don't you see...it is the Microsoft tools...