My computer is not part of a domain., but rather a member of a workgroup. You can still use Windows Authentication for things like file sharing and accessing Microsoft SQL Server instances. All you have […]
Recently came across an error when trying to print labels via NetLabels 3.0. The print job would fail and would throw an error. The problem is that a Windows registry key for a font (or […]
I often find myself needing to check the version of the Microsoft .NET Framework that is installed on a PC. If your looking for .NET 4.0 it’s pretty easy, you can go into add/remove programs […]
When using query by example there are the known wildcard characters “*” or “%” and “?” or “_”; but, recently I stumbled upon a new wildcard known as the charlist. Wildcard Description * or % […]
I recently found myself having to update several document categories to new values. From the NetTrax.NET database side this was a breeze, a few simple SQL update statements and I was done. The problem was, […]
Bottom up methodology is the most successful way to implement most Records Management projects. By starting with the one record series or loan type first that is causing the biggest problems or would impact the […]
You would clean up the physical files…. Many of the same problems exist in the database. Incorrect information, incomplete information, missing required information, not enough metadata to classify, corrupt data, out of date information, incomplete […]
I needed to pull out all rows where a user id was numeric, SQL Server (as of 2005) has a function IsNumeric: SELECT USERID,USERNAME FROM Users Where IsNumeric(UserID) = 1 ISNUMERIC returns 1 when the […]