Browse by Tags
All Tags »
SQL Server (RSS)
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
Read More...
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
Read More...
I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio: Saving changes is not permitted. The changes you have made require the following tables to be dropped
Read More...
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
Read More...
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
Read More...
There are so many different ways to work with data that it can make your head spin. Regardless of the technology, one thing I always try to do when working with databases is minimize the number of calls that are made. I use ORM frameworks
Read More...
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
Read More...
One of the projects my company is currently working on has a requirement to be able to store timesheet data in a more flexible manner. The existing Access forms application is being converted to Silverlight 3 and has a fairly rigid (albeit standard)
Read More...
If you are looking to follow this series, be sure to subscribe to my RSS feed at http://feeds.jasongaylord.com/JasonNGaylord or my Twitter account at http://twitter.com/jgaylord . This series can be followed by using the Hot Links tag. Series Post #12
Read More...
One of the prerequisites for TFS 2008 is that it must be installed to work with SQL Server 2005 SP2 or SQL Server 2008. However, TFS 2008, by itself, will not work with SQL Server 2008. You’ll receive an error message that your SQL Server instance is
Read More...
I was looking for a quick and easy solution to export data from SQL into an Excel format from within my ASP.NET application. I came across a great video posted by Beth Massi on the asp.net website (Video #7 at the bottom at http://www.asp.net/learn/linq-videos/
Read More...
All day I was stumped on why there wasn't a simple way to grab the first object in a sequence other than using: .Take(1).Single Then I discovered the keyword First. I'm still a little puzzled as to why .Single would throw an exception if more than a single
Read More...
The next .NET Valley User Group event will be on June 18th at Scranton University in Scranton, Pennsylvania. There will be two talks that evening. The first will begin at 6pm and will be presented by Michael Murphy. Michael will talk about the ins and
Read More...
I was running into an issue where one of my webmethods was taking a large amount of time to return a small set (5-10 objects). I was using LINQ to SQL. I noticed that the LINQ to SQL query was returning all of the rows. After looking into the table a
Read More...
I ran into an issue earlier when trying to return an entity class through a web service for use in an AJAX page. After some quick research, I came across a post by Darren Neimke that referenced Rick Strahl's post about LINQ to SQL and Serialization .
Read More...