Was it perhaps granted only on the database level security then?

I.E., try opening up the Database, going to Security, and adding a new user via the GUI.

If that doesn't work,...

What is the business need to use a schema object to prevent this?

Oh, for heaven's sake. After all this grief with the job and the task, it turns out the problem is the file isn't zipping up properly because a .lst file...

Did you upgrade from SQL 2005 or SQL 2000? It might be a holdover from one of those.

Also, it is entirely possible the login was orphaned (the server level login...

I calculate it based on what the database seems to need.

Are you creating new databases or trying to calculate this for existing databases?

Also, what you really need to know is...

Eric M Russell (12/10/2014)

---

lshanahan (11/26/2014)

---

Markus (11/25/2014)

---

You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have...

William Assaf (12/9/2014)

---

I know this is delayed, but I just tangentially heard about this problem.

I bet it's permissions.

From MSDN:

http://msdn.microsoft.com/en-us/library/ms187354.aspx

"Only members of sysadmin can modify a schedule owned by another...

That's not what he is doing,...

psc032802 (12/5/2014)

---

Yes, I see the viewer installed on my computer.

I do not have much access overall. Just read access to one database and I cannot see what...

Ed Wagner (12/5/2014)

---

Brandie Tarvin (12/5/2014)

---

Here's a bit of easy...

psc032802 (12/4/2014)

---

Thanks for the good info. If data profile tasks is all I need, then I ask the DBA to have it run on regular schedule. If they...

Here's a bit of easy code to solve the...

Eric M Russell (12/4/2014)

---

I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public permissions, can...

Ville-Pekka Vahteala (12/3/2014)

---

ScottPletcher (12/2/2014)

---

eric.notheisen (12/2/2014)

---

In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our...

jliu 81028 (12/3/2014)

---

Your number 3 option should work for me:

3) Ask to have the SQL Server client tools installed on your machine (including BIDS) and create the package yourself. Ask...