SQL Server - Jeff Widmer's Blog

Browse by Tags

Find stored procedures that reference a table column: We recently moved away from SQL Server replication and the database still has all of the rowguid columns and their associated indexes and constraints in it. We wanted to gain all of that disk space back so we went ahead with scripting out the delete of...
Posted 16 June 2011 10:22 AM by Jeff Widmer | with no comments
Filed under: SQL Server, SQL, SQL Server 2008

Lock request time out period exceeded: I was trying to drop a foreign key for a table I was working on and I ran into a time out exception from SQL Server Management Studio: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for ForeignKey 'fk_MyForeignKey...
Posted 08 June 2011 01:44 PM by Jeff Widmer | 2 comment(s)
Filed under: SQL Server, SQL Server Management Studio, SQL Server 2008

SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0: I am trying to perform a database attach upgrade to SharePoint Foundation 2010. At this point I am trying to attach the content database to a Web application by using Windows Powershell: Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer...
Posted 30 May 2010 08:00 PM by Jeff Widmer | 10 comment(s)
Filed under: SQL Server, Sharepoint, SharePoint Foundation 2010, SQL Server 2008

SQL Server 2008 Service Pack 1 and the Invoke or BeginInvoke cannot be called error message: When trying to install SQL Server 2008 Service Pack 1 to a SQL Server 2008 instance that is running on a virtual machine, the installer will start: But then after about 20 seconds I receive the following error message: TITLE: SQL Server Setup failure...
Posted 30 May 2010 03:23 PM by Jeff Widmer | 15 comment(s)
Filed under: SQL Server

How to change SQL Server login default database through SQL Script: I am moving a SQL Server database from one drive to another by detaching and then reattaching. I detached the database, moved the mdf and ldf files, and then went to attach it and was presented with this dialog: TITLE: Microsoft SQL Server Management...
Posted 19 February 2010 09:51 AM by Jeff Widmer | 2 comment(s)
Filed under: SQL Server, SQL Server Management Studio

SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process.: When trying to do a full text search with SQL Server 2008 I received this error: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start...
Posted 30 December 2009 03:27 PM by Jeff Widmer | 3 comment(s)
Filed under: SQL Server, SQL Server Full-text Index

ISO 3166-1 Country Data SQL Script: I am creating a standard sign up form with one of the fields being a country drop down. So I created my Country database table and then needed to fill it with information. I found the ISO list of countries here , but then the issue was how to get that...
Posted 09 November 2009 09:15 PM by Jeff Widmer | 5 comment(s)
Filed under: SQL Server, SQL Script, SQL, ISO Country Codes

osql.exe and unicode files – how to save your sql scripts with encoding: osql.exe is a great application for running sql scripts in a batch. I use a batch file to execute multiple sql scripts that I use to rebuild my current application database from scratch. When developing a brand new application, deploying a...
Posted 14 October 2009 09:43 AM by Jeff Widmer | 6 comment(s)
Filed under: SQL Server, Visual Studio, Tips & Tricks, osql.exe, Unicode encoding

How to Reseed a SQL Server Identity Column: In SQL Server you can specify a column as an Identity column (ColumnName int IDENTITY(1,1) NOT NULL) to have SQL Server automatically set the value of this column upon insert by incrementing a seed value. This works great but I have run into situations...
Posted 15 September 2009 10:39 PM by Jeff Widmer | with no comments
Filed under: SQL Server

nvarchar(max) parameters need the size set to -1: SQL Server 2005 supports a new data type nvarchar(max). This is one of the new max datatypes that are to replace ntext, text, and image in a future version of SQL Server (according to SQL Server Books Online) but you should start using them now. I recently...
Posted 15 August 2008 05:00 PM by Jeff Widmer | 18 comment(s)
Filed under: SQL Server, .NET, ASP.NET, C#, Visual Basic