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) […]
2002-10-29
497 reads
Will adding generative AI to your data project improve the outcomes? It might, but...
By Chris Yates
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...
By Steve Jones
I’m honored to be speaking at the PASS Data Community Summit in Seattle this...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Database Architecture Considerations for Implementing...
Comments posted to this topic are about the item Database Architecture Considerations for Implementing...
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