Actually, your article doesn't cover use of the REPLACE option. And the Microsoft page you link to is...

Does the message go on to say anything else? I think you can use the REPLACE option to overwrite the existing database. I would advise you to use...

Two other things you could consider: back up msdb on your test server, then restore over it, then restore the original one back once you've retrieved your package. Or...

I would set them both to 12GB, for example, and if there's a failover, let them fight for the available memory. The reason for this is that failovers should...

I think there are compliance issues here, as well. In the UK, the Data Protection Act covers data that can be used to identify a living individual. As...

One way of doing it is put a DISTINCT in, thus:

...

LEFT OUTER JOIN (SELECT DISTINCT ServiceOrder FROM ServiceOrders) SO ON I.ServiceOrder = SO.ServiceOrder

...

John

If you only want one Work Order, how will you choose which one will be returned? Also, your WHERE clause includes conditions on your outer tables. This will...

I like the trigger theory best.

SELECT [name]

FROM sys.triggers

WHERE OBJECT_NAME(parent_id) = 'Person'

John

Try one of these links and let us know how you get on.

John

Will it? How do you know that whatever other solution that may exist doesn't affect performance...

Yes, there are stored procedures you can use to set up a server-side trace.

John

Whoaa! This is far more complicated than it needs to be. All you need to do is user parameters in your Execute SQL task - something like this:

SELECT...

You would need to configure your package so that it does a specific thing on task failure. I think by default, the package will fail if only one task...

I'm not an expert on how server discovery works, but I'd imagine that it interrogates SQL Server Browser and looks for anything listening on 1433. That would explain why...

Sounds like you need an event handler on your event handler! Seriously, though - I would start by having it not do anything except write the error to a...