😛 You just made my point for me. I think we're done here 🙂

You could do something with Dynamic SQL and a DDL Trigger, but that would be code-compiling-code-that-it-wrote-on-the-fly which can be difficult to write to where it works properly in all cases,...

Jeff Moden (3/25/2013)

---

opc.three (3/24/2013)

---

You're still hung up on 'external attackers.' The point is, xp_cmdshell is a blunt tool that cannot be audited and allows people to run commands as someone...

Sergiy (3/25/2013)

---

Not sure what...

gurvimail (3/25/2013)

---

My connection string looks like this for excel, so if the user with the services account exists in the server then it should be able to acces the file.,...

gurvimail (3/25/2013)

---

i am referring to the service account, the excel file is not password protected. and i think you are right that i need to have my windows account to...

gurvimail (3/25/2013)

---

Hi,

I am trying to connect to the UNC path , but am unable to connect to the Shared Drive, i cannot find any option in the Excel file...

Del Lee (3/25/2013)

---

We want to introduce Integrated Security and use Windows Groups to simplify some things in our SQL Server access. I believe I understand how this works, but...

Phil is right about the sorts. The way they're bring used they are a size-of-data operation and in most of the instances in your Data Flow you could have the...

Thanks, Steve! I was not sure where this would land on the priority list but it sure would be cool. I appreciate you considering the feature.

It did appear as a school assignment to me as well. I love helping newbies and students however if I think it is an assignment I will typically insist on...

Bummer. SSIS 2012 has some new Tasks built in to make working with CDC data a breeze, but it's not too difficult with SSIS 2008 R2. Have a look at...

peterdru401 (3/25/2013)

---

You should keep track on SQL Server storage and performance to avoid this type of problem

If the capacity management of sql server is up to the mark then...

Sergiy (3/24/2013)

---

And?

How adding an "sp_configure" command to a script used for stealing data...

I may have picked up am extra trailing parent when it copied it from my script. Try removing that and see what you get. Better yet, deconstruct the command and...