Sergiy (4/26/2013)

---

opc.three (4/26/2013)

---

A stand-alone PowerShell prompt on Homer's machine does not offer much over a stand-alone CmdShell prompt on Homer's machine in the way of added security, only in functionality....

How to: Map Result Sets to Variables in an Execute SQL Task - SQL Server 2005

As a side note, using sp_executesql is pretty much how every query from SMO (objects used by SSMS) is issued against the instance. The SQL Agent team coded their queries...

RSS Feed http://blogs.msdn.com/b/sqlreleaseservices/rss.aspx (courtesy of Gail Shaw for initially providing on these Forums)

Jeff Moden (4/26/2013)

---

I understand that working from the command prompt isn't the same as working through xp_CmdShell (seriously elevated privs can be found there). It was sounding like you...

Jeff Moden (4/26/2013)

---

opc.three (4/25/2013)

---

I never said a regular PowerShell session offers more security than a regular cmd shell session when not running via xp_cmdshell. I said PowerShell is more robust...

I never said a regular PowerShell session offers more security than a regular cmd shell session when not running via xp_cmdshell. I said PowerShell is more robust than cmd shell...

All things being equal, going from VARCHAR to NVARCHAR should roughly double the size of your table. You might check for fragmentation in your clustered index (assuming the table is...

If you add a CHECK CONSTRAINT to LINE_CODE on all your tables to let the optimizer know what values can exist in that table then the optimizer will be able...

Can you please post the DDL for one of the TB tables, including all constraints?

That's one way to try and abstract the poor table-design. When used in a query, the Optimizer will evaluate the contents of the VIEW so indexing on the referenced tables...

Jeff Moden (4/24/2013)

---

opc.three (4/24/2013)

---

Who cares? Maybe nowhere. Maybe somewhere. But either way the files were deleted while Homer was logged in as himself. Do the same through xp_cmdshell and the...

How are you checking the table size?

Jeff Moden (4/24/2013)

---

opc.three (4/24/2013)

---

Xp_cmdshell does not maintain a users identity all the way through the stack, which impedes auditing and allows for obfuscation of the identity of the person running...

Heh...a SQL Pro would also know "it depends" on the context and environment 😉