SQL Server DTS may be one of the best tools ever included with a database server. It makes data movement, copying, any sort of ETL task a breeze. At least for the most part. Bruce Szabo found a place where the Copy Objects task sometimes doesn't work as expected. This article looks a problem he had as well as the solution that you can use to ensure that this task works reliably for you.
2004-10-13
8,974 reads
Monitoring your SQL Servers is something every DBA must do. Checking job status, disk space, etc. is a frequent question seen in our forums. Pearl Knowledge Solutions has developed a product to help you easily setup monitoring on your servers from a web interface. SQLCentric gets 4 stars from author Bruce Szabo; read his detailed review on this fine product.
2004-07-23
6,274 reads
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
2004-04-08
9,881 reads
2004-03-08
10,998 reads
Looking for a good (or another) TSQL reference? This might be the one. Bruce took a good look at it and points out both the good and the bad.
2004-02-17
5,454 reads
The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.
2003-08-28
6,844 reads
A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.
2002-08-22
6,365 reads
An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.
2002-07-22
9,149 reads
This script kills all the processes using a given database. It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script. Notifications are written to the windows application eventlog.Use this script at your own risk. […]
2002-07-12
1,104 reads
This article shows how to use a DTS package to detect a file. After the detection of the file the processing of the file can be completed. This code in the .DONE processing section uses the Wscript.Shell command to unzip a file.
2002-07-09
11,285 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Comments posted to this topic are about the item Converting Money
Tlp/Wa_Cs:0817-866-887. Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers