@Dscheypie -  Agreed. Master key password can be different from the one mentioned in data source. However, the secret in database scoped credential and the connection options in...

• This reply was modified 4 years, 6 months ago by  ramya.sqlservr.

I wonder if the link is working for others... I can't get to the link and I don't see number of reads either on the homepage...
But, very interested to...

Ed Wagner (1/19/2016)

---

ramya.sqlservr (1/19/2016)

---

Does this work for mounted volumes as well?

We have mounted volumes on our servers and I generally use fsutil to get free space. I want to know...

Does this work for mounted volumes as well?

We have mounted volumes on our servers and I generally use fsutil to get free space. I want to know if this procedure...

Jeff Moden (6/9/2015)

---

The scenario descriptions in the final chart of the article also don't seem to match the actual scenario descriptions in the text of the article. That also...

TheSQLGuru (6/9/2015)

---

I think you missed a VERY important type of test in your examples: 1M row inserts at a time, in discreet transactions. Please try that (primarily for the insert...

dbishop (6/9/2015)

---

I'm sorry if I am being too critical, but this seemed like more of an article to provide a lot of screen shots, and not a lot of substance....

JoeS 3024 (6/9/2015)

---

So for those of us who aren't DBA experts does this mean that choosing between a SELECT INTO and INSERT INTO is one of those "It Depends" choices?...

You are right. We can use either of the approaches for small tables because it doesn't make much difference. But, for large tables, insert into is better when select into...

Are both the servers running on same service account? Could you please paste the query that is giving this error?

Thanks!

I was setting up a new server and this was the only job accessing the user database at that point of time. When I was making sure all the setup...

You are right. I might have missed this point in the article - the problem here is the job worked fine when run on other databases (master,msdb etc.,) but failed...

This issue is resolved in CU6 for SQL Server 2014.

http://support.microsoft.com/kb/3031047/en-us

Thanks,

Ramya Makam