Technical Article

Changing the Owner of a Single DTS Package

This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000).  His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner.  This script will change the owner of the most recent version of a specific DTS package (@p_name) […]

You rated this post out of 5. Change rating

2002-10-29

497 reads

Blogs

9 questions to ask before adding generative AI to your data project

By

Will adding generative AI to your data project improve the outcomes? It might, but...

Accelerating Database Modernization Through DevOps & Cloud Integration

By

In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...

Speaking at the PASS Data Community Summit

By

I’m honored to be speaking at the PASS Data Community Summit in Seattle this...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Database Architecture Considerations for Implementing Content Moderation Services

By inbathiru

Comments posted to this topic are about the item Database Architecture Considerations for Implementing...

Database Architecture Considerations for Implementing Content Moderation Services

By inbathiru

Comments posted to this topic are about the item Database Architecture Considerations for Implementing...

Visit the forum

Question of the Day

TCP Provider Errors in SQL Server

You're troubleshooting a connectivity issue between a client application and a remote SQL Server instance. The client receives a "provider: TCP Provider, error: 0 - No such host is known" message. You verify that SQL Server is running and reachable on the server. The SQL Server instance is configured with a named instance and uses dynamic ports. Which of the following steps is most likely to resolve the issue?

See possible answers