BI_NewBie (9/7/2016)

---

Thanks a lot for your reply.

I have given permission to user in Home--> Folder setting. If I try to remove user from Home page folder setting and directly...

swoozie (9/6/2016)

---

I know this is an older thread, was wondering if you found a resolution. I am experiencing the same thing.

We moved from 2005 to 2014 AG and...

I think it's just the difference...

What is the compatibility level of the database where this happens? Any chance this is an upgrade from SQL 2008?

Sue

Kind of like all the scripts that accidentally get run in master...."I can't find the table I created in my database".

Thanks for posting back Chitown - really helps others...

kweiskittel (9/6/2016)

---

Yes Sue, it's a 2012 back-end. You're exactly right, as that was our issue.

I don't think we uncovered this in the past, I guess because previous users with the...

kweiskittel (9/6/2016)

---

Our problem was just solved by merely installing SQL 2012 Management Studio; previously we had SQL 2008 version and from the install path, I'd even say SQLExpress was involved....

Stripathydba (9/6/2016)

---

Hi All,

My client has come up with a requirement wherein we need to monitor a job(XYZ), and in case it runs beyond a certain time(specified by the business, lets...

Permissions in SSRS are by default inherited from the parent. The chaining of permissions can be broken by granting item level permissions - you get a pop up warning, can't...

lohithkschalam 92184 (9/6/2016)

---

As I mentioned above, the SQL server service and SQL server agent is running under same account, I observed from the SQL server error log that the SQL...

And did you check all of the users other permissions as well? If they have a deny view somewhere individually or through a role, deny takes precedence. If you did...

Not the best way to approach auditing if that's what this is for.

To do such on multiple tables, you'd need dynamic sql, multiple alter statements or else use one...

That is weird but there isn't much for referential integrity in msdb so I'm not surprised.

Glad it's working though - thanks for posting back!

Sue

You need to do the Run As Administrator - it doesn't matter if you are an administrator on the box or if you are in the Administrators group. All three...

The problem could be the code page you're specifying. 65001 CP is no longer supported.

Sue