SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.
2006-02-20
20,362 reads
DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.
2005-12-20
5,906 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
hi a few days ago i narrowed down the cause of a new problem...
At what levels can we set the collation in SQL Server 2022?
See possible answers