There are many better ways (IMHO) to get XML from a database to disk than from within a T-SQL context. Have you exhausted all other options? What is your client...

I imagine it is possible to do this using the pipeline with far less code but this will get the job done:

$dir = "C:\@\1"

foreach($file in (ls "$dir\*.pdf"))

{

...

You may be able to use Policy Management to prevent it from being disabled. Are you on 2008 or higher? Have you used policies before? I know someone who uses...

This may help you for future executions: http://dtloggedexec.codeplex.com/%5B/url%5D

DTLoggedExec provides an alternate to using DTExec for executing SSIS packages that can generate just about any logging information you like without adding...

You can really compress your timeline by running a TSQL_replay trace on your production server while it is in 80 mode and then replaying the trace results against your dev...

Create a Solution in BIDS 2005 or Visual Studio 2005 (VS). Then add a SQL Server Integration Services Project to the Solution. Now add all 100 SSIS packages to the...

DoubleTake is worth a look. Throughput was far superior than Windows Copy. I cannot speak for it from an admin perspective though because the two shops I have been in...

SSIS is not a High Availability solution. Can you explain more about your environment and what you are trying to accomplish?

pk2011 (12/16/2011)

---

Hello all,

Is it possible to migrate from SQL standard edition to SQL 2008 web edition, without having 2005 never used/installed in the system. In the DB there are...

Try changing this:

$db=gi sqlserver:\sql\D000XXX\default\databases\Northwind

to this:

$db=gi sqlserver:\sql\D000XXX\default

After seeing how this changes the playing field in terms of what you evaluate policies against you may want to rename your variable too 😉

USE master ; --<< important: procs set to start automatically must reside in master

SELECT *

FROM sys.procedures

WHERE is_auto_executed = 1 ;

In that case sys.database_principals and sys.database_role_members has all the metadata you need to build the commands that can add the Database Roles and Database Users to another database.

Path of least resistance...gotcha. Happy you got a comfortable way forward 🙂

geoffrey grierson (12/1/2011)

---

Good morning Jason

I did:

USE master

GO

GRANT VIEW SERVER STATE TO [dom\acc]

but the result is the same.

Today I'll make a fresh start on the problem. No more googlebing for...

I strongly encourage you to find an alternative way to do what you are attempting.

From http://support.microsoft.com/kb/257757

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from...