Thank you John. You have pointed me in a direction that will work. I think kicker was the -1 and I was just not thinking.

Thanks everyone. I went down the road of adding the SalesRepNumber into the mix, but didn't think to get it as another row_number. Good stuff...

Thank you GilaMonster. Yeah, I'm working with an old database and this is how the data was stored. I would certainly have preferred not to store it in...

JMartin, did you ever figure out a solution to what you needed to do? I'm in the same boat. I have a SID in binary form and I...

GilaMonster, thank you so much for the info!

Grant, another question if I may. What happens in the case of a proc that has conditional branching? For example, the proc has a major IF statement based...

Thank you guys for the confirmation on this. We had a case of a new stored procedure that was put into production. Within a week we started getting...

Dan, thanks for the reply. That is what I thought, but I wanted some confirmation.

Sure makes sense. Everything being used in my example is standard .NET namespaces. Thanks again Jim.

Thanks Jim. So to answer my questions, you need to have PowerShell and SMO installed on the remote computer. The identity that script is being executed under has...

Thanks Jim for the reply. Using SQLCMD was my original thought too, but our client is requesting this be done using PowerShell. I guess another question is that...

I agree with ALZDBA. We have done the same thing by calling the appropriate SP to kick off a job that runs the package.

Congratulations Josef! The world could certainly use more DBAs like yourself.

Beverley,

So that is the problem right, the application is connecting to SQL server using a SQL account verses doing integrated security. Integrated security is more secure than a SQL...

Beverley (8/31/2009)

---

I'm not sure I fully understand the question, but we do something similar (I think) to what you're asking.

The application knows the logon user (e.g. dmn\jdoe)

But then it connects...