After copying a database the ASP.Net Membership permissions might not be set for the user you are trying to connect to resulting in the error: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database […]
Every time I setup a new SQL Server I always forget one or more of the steps below to allow remote connection from another workstation via SSMS. 1. SQL Server Properties: check “Allow remote […]
It looks like you have to recreate a new label if you want to change the label type of an existing Dymo® label. I thought the Dymo® software would allow me to change the label […]
At times we copy a SQL Server database from one database name to another for testing or development. One thing that doesn’t change is the logical name: Using the following SQL script the logical name […]
Creating a full-text catalog in SQL Server is easy, I used a tutorial on one of our favorite SQL Server blogs: http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ I created 4 catalogs: Each catalog is assigned to a table and columns […]
I found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
By Microsoft’s definition, Shared.: “Specifies that one or more declared programming elements are associated with a class or structure at large, and not with a specific instance of the class or structure.” Source What does […]
Scenario: a drop-down (lookup) key-value along with the description are included in an import file. There are data scenarios were in the drop-down (lookup) table: 1) The key (code) already exists and we would use […]
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 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 […]