PowerShell 2.0 is standard equipment in Windows Server 2008 R2. What are you...

Are you saying you created one stored proc that handles inserts, updates and deletes for over 100 tables using dynamic sql?

Try shrinking by a very small amount. Can you restore the DB to a test area so you can drop into SINGLE_USER mode and try the shrink, or can you...

A simple chore with PowerShell. Here is a one-line PowerShell command that does the work...

You're welcome. I try to pass along the latest info regarding the System and Catalog Views to keep the ball moving forward so to speak. The newer Views have more...

nzhang6666 (8/28/2012)

---

Thanks for the replies, I was on holiday so didn't come here.

Actually in my first proc (nz_test1) I just want to make sure to turn on 'xp_cmdshell' and 'ad...

bwperrin (8/28/2012)

---

Finally figured out how to get it working. SQL uses the sqlps utility, which is a Windows PowerShell mini-shell, and it has some restrictions such as mentioned above....

You could always switch to a CmdExec step type. Or write a PowerShell script to interact with the file system, which it is more capable of doing than T-SQL.

I have used SSRS report subscriptions to send renderings of reports places on a schedule. This would help satisfy the requirement to send the report to your users on a...

If you can use the SQLCLR here is an option that is a bit more expressive in terms of the syntax:

SELECT p.Prod_Name,

...

Thanks for posting back. As far as I know the validation errors you are seeing are considered non-fatal so SQL Agent carries on as usual. In your package you can...

You didn't answer my question.

No problem. Happy to help. I am learning from this too.

Maybe you could try it with a local login just to see if you can isolate it to being a...

The Bulk Insert Task will work but I prefer using a Flat File Source with an OLE DB Destination setup w/ FastLoad.

The former replaces the need for a format file...

If you want the package to keep going then you cannot fail the Task. I looked up the exceptions that can be thrown by the DownloadFile method and you'll likely...