Using SQL Server 2008 Express as a default instance

Posted on September 13, 2008

Time to upgrade!  After uninstalling SQL Server 2005, I decided that I would try running only the Express version of SQL Server 2008 on my laptop.  After installing, I found that running SQLCMD against the (local) server no longer worked.  For example, sqlcmd -s (local) -i SomeScript.sql Resulted in this error: HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft ...

Read More

SQLCE Error 26100: The table name is not valid

Posted on April 16, 2008

If you're using LINQ to SQL with SQLCE and use the DataContext.CreateDatabase() method, you may encounter this error.  If you used the LINQ to SQL class designer to generate the classes from a different database provider (such as SQL Server 2005 or SQL Server Express), the table source names may be prefixed with "dbo." Just remove the prefix, and CreateDatabase() will succeed.

Read More