Learn how to use a script to compare two tables that are identical in order to verify if the values are really the same in both tables.
Category Archives: SQL Server
Here’s an example of how a TSQL script will identify all tables in a databases that do not have a Primary Key.
If you are ever trying to work out what hotfix a SQL Server 2000 build equates to, the Build Chart on the ASPFAQ website will certainly come in very handy.
The May edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
Many of you may be aware that the Login Mode for SQL Server is stored in the Registry key HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
There was a post last week regarding a bug with SQL Server 2000 SP4 and not all memory being available when AWE is enabled.
Below is a VBScript code sample illustrating how to use SQLDMO to generate a SQL script of all of the operators on a SQL Server instance.
Recently a client of ours had the need to run a DTS Package on a scheduled basis to read an Outlook Mail Profile and perform some transformations on the mail messages.
Itzik Ben-Gan from Solid Quality Learning is in Australia promoting the launch of Solid Quality Learning’s training services in Australia.
Microsoft has found an issue with the final build of SQL Server 2000 SP4 that impacts customers who are running SQL Server 2000.