I had a spreadsheet that was in .xlsx format that I needed to import into an Access Database. I made sure the columns were in the correct order, and that the column headers matched my […]
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 […]