You can't. You have to rebuild your DTS as SSIS. Here's some documentation to help out. In some cases, you can run a DTS package inside an SSIS...

Piling on.

Backwards restores are not possible. When you create/restore a database on a newer version of SQL Server, it uses all the new functions storage mechanisms, etc.,...

Saluton, mia nomo estas Grant. Bonvolu pafi min.

Great Googly Moogly.

Referencing a recent thread, and several of you know the one, I posted on Twitter that simply moving a query into a view will not improve...

Yeah, you've pretty much nailed the reason for it existing. The only trick is, can you readily isolate individuals within your system to limit them logically. If so, it works...

Writing out a full fledged T-SQL for all that would be a full-time position and I ain't getting paid. Ha!

However, I'll offer a few pieces of advice.

Find a champion.

You want a high level person with integrity who will work with you and support your efforts. If it's family run, someone in the family. You...

Get a copy of SentryOne Plan Explorer. It's free. Anonymize the plans (it'll clean the query & everything) and then post those. Otherwise, everything everyone is saying is just random...

This is the Minion mentioned above. Worth a look. It's a very viable alternative for most people.

PBM is pretty amazing. Unfortunately it gets extremely little love from Microsoft. There have been additions to it with new functionality, but overall, it gets almost no attention. I don't...