Jonas Stawski

Everything .NET and More

Updating Rows from one table to another without a relationship

So, I’ve been doing a lot of SQL Scripting lately and I’ve come to a stop when I hit a problem I have never hit before. I had to update ColumnA of TblA with ColumnB of TblB. So my initial thought was to do an INNER JOIN UPDATE. So I started typing:... [More]

Enable Full-Text Indexing for a Database on SQL Server 2005

I needed to create a full-text index on a column, but I was unable to do so because of the following error: "Creation of the full-text index is not avaiable. Database is not enabled to allow for full-text indexing." After many hours of searching I fo... [More]