One possibility: the account running the SQL Agent job does not have access to the file path where the PS script resides.

PHP on *ix talking to SQL Server is a challenge because of the lack of a complete and current open source driver. FreeTDS is the generally accepted "best one" and...

Awesome 😎

Thanks for posting back.

I looked at the article to see how you arrived at a query that used "IF 0 NOT IN" because I had never seen that as an...

Ahhh...when you launch PowerShell from SSMS I think you're actually running a SQLPS session which is a mini-shell (real term :-)) different from a standard PS shell.

See section "Adding the...

I think we're having a terminology disconnect here...

I am talking about using SQL Server transaction replication to replicate the resultset of a VIEW from a publisher (the operational database) to...

Not sure if I'm a purist but your post freaked me out a little.

PowerShell +10,000

Something did not come through correctly through the copy/paste/website translation...can you please save the execution plans on your local disk and attach them to the thread?

We want the Actual Execution Plan saved as an XML file (.sqlplan extension).

From the article with some relevant items in bold:

To save an execution plan by using SQL Server Management...

Sounds like you're doing something when trying to gen it or save it where it's not giving you the proper result. Please have a look at this article:

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

Edit: See the...

PaulB-TheOneAndOnly (6/17/2011)

---

opc.three (6/17/2011)

---

Concrete tables used in a temporary way and truncated before and/or after each use are a common design choice. What I see a lot of people fail to...

:ermm: I'm not well-versed in reading text plans...could you provide graphical plans? You can save them as .sqlplan files locally and attach them to the thread.

You're close. See if this makes more sense. I updated your script so it runs independently and just prints what would be run...just uncomment the EXEC command if you want...

Just curious because I have supported PHP clients talking to SQL Server...what drivers are the PHP devs using? Is it PHP on Windows or *ix?

Define proper? In what way is a replicated VIEW improper?

This is an option. The SSIS package...