The disadvantages of setting Max Degree of Parallelism to 1 is that queries that would have benefited from executing with a parallel plan will not be able to and that...

You have numerous configuration management options in SSIS. Personally I like using XML Package Configuration files for this kind of work. When I deploy a package to 'dev' or am...

Is the SQL Server Browser service running?

Sorry, that was an extension of my view and your position. By willfully enabling xp_cmdshell, your position, you have made it easier to be attacked, my view, therefore you are...

This describes what you're running into:

Connect > Default Schema for Windows Group

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Yikes. The more we talk about this the more your approach to security sounds like 'why bother.'

I am actually becoming quite astonished that...

I am running out of ideas so I re-read the whole thread. Something says to me this is related to Windows Group membership and possibly membership in multiple groups.

I know...

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Yikes. The more we talk about this the more your approach to security sounds like 'why bother.'

I am actually becoming quite astonished that you're trying to...

Forgive me if we're covering already covered ground. I am trying to follow along.

Is it to say that you created a new login on the named instance for domain\user3?...

FEL will operate sequentially. You could add additional FELs and have all select a mutually exclusive subset of the packages you need to execute.

You can have a single Data Flow copy multiple tables.

Are there any diffs between the privilege or permission_path when you run this against each principal?

EXEC sys.xp_logininfo

@acctname = 'domain\user1',

@option = 'all';

EXEC...

I would have more questions. Here are a couple options based on the answers to the questions.

- Can the entire file fit comfortably in memory? If so then in Data...

😛 sorry, no harm meant

I would look for high CPU queries using the initial post, there are lots of queries online for this. Proving it to the vendor is always...

jporgy (9/21/2012)

---

So Give this, is it fair to say that the auditors simply need to look at the OS level security policy because it should take effect on the SQL...