We frequently have to generate location or item codes for clients. This is typically a sequential number that has multiple levels in the code. For example, there are 4 carousels; each carousel has either 23 […]
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 […]
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, […]
I cannot tell you how annoying I find this error, and before you post a comment, I know it’s not the fault of SQL Server. I’ve asked it for something that is not logically solvable. […]
I often find myself needing to take data from a SQL query and give it to another person. SQL Server Management Studio (SSMS) does have the ability to right click in the results grid and […]
I know what your thinking. Why in the world would I want to manipulate the complex workings of MS SQL Server using the archaic command line? Before today I would have been thinking that right […]
Often you need to access data on a server that lives on a separate server. Fortunately SQL Server lets you create a Linked Server to join Server A to Server B. Once linked you can query against the […]