Top "Sql-server-2005-express" questions

Use this tag for questions specific to scaled down, free edition of SQL Server 2005.

How to change identity column values programmatically?

I have a MS SQL 2005 database with a table Test with column ID. ID is an identity column. I have …

sql-server sql-server-2005 tsql identity sql-server-2005-express
Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am trying to deploy my website on windows server 2003. Am i missing something or what is wrong from the …

sql asp.net-mvc windows-server-2003 sql-server-2005-express
How can I join on a stored procedure?

I have a stored procedure that takes no parameters, and it returns two fields. The stored procedure sums up all …

sql sql-server-2005-express
Delete rows from multiple tables using a single query (SQL Express 2005) with a WHERE condition

This is the query I'm using: DELETE TB1.*, TB2.* FROM TB1 INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID WHERE (…

sql sql-server sql-server-express sql-server-2005-express
How to install SQL Server 2005 Express in Windows 8

I tried to install SQL Server 2005 Express SP3 x64 on Windows 8 but the installer gives me an error: An installation …

sql-server-2005 sql-server-2005-express
How can I view the contents of sql binary data fields?

Does anybody know how to view the contents of fields containing binary data in an MS SQL Server 2005 database?

sql binary-data sql-server-2005-express
Unable to cast object of type 'System.Object[]' to type 'System.String[]'

I am developing a C# VS 2008 / SQL Server website application. I am a newbie to ASP.NET. I am getting …

c# visual-studio-2008 sql-server-2005-express
Populating Listbox with data from SQL Server

I don't know what is happening to my program, it took me (4) four minutes to load the result of my …

sql-server vb.net visual-studio-2010 sql-server-2008 sql-server-2005-express
Generate script in SQL Server 2005 with data

How can I generate a script in SQL Server 2005 with data in table?

sql-server sql-server-2005 sql-server-2005-express
Linked server setup between SQL Server Express and SQL Server

Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (…

sql-server linked-server sql-server-2005-express