Stack Overflow
Stack Overflow

Questions tagged [sql-server-2005-express]

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

193 questions
160
votes
13 answers

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 rows in this table and all of them have their corresponding ID auto incremented value. Now I would like to change every ID in this table like this: ID…
Tom Smykowski
  • 25,487
  • 54
  • 159
  • 236
89
votes
27 answers

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 following error message, how can I correct it? Thank I am having the error message: A connection was successfully established with the…
learning
  • 11,415
  • 35
  • 87
  • 154
61
votes
9 answers

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 transactions that are applied to a tenant, and it returns the balance and the id of the tenant. I want to use the record set it returns…
Malfist
  • 31,179
  • 61
  • 182
  • 269
38
votes
1 answer

maximum number of parameters in sql query

I do experiment with LINQ since some time. Typical method to enumerate through a collection and change some of its properties in my code would look like: ATDataContext dc = new ATDataContext(Settings.connection_string); int[] col =…
Mariusz
  • 908
  • 1
  • 13
  • 28
33
votes
16 answers

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 (TB1.PersonID)='2' It's working fine in MS Access but getting error (Incorrect syntax near ','.) in SQL Server Express…
Jobi
  • 1,102
  • 5
  • 24
  • 38
17
votes
1 answer

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?
Xandir
  • 173
  • 1
  • 1
  • 7
14
votes
6 answers

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 package for the product Microsoft SQL server native Client cannot be found. Try the installation again using a valid copy of…
Eduardo Molteni
  • 38,786
  • 23
  • 141
  • 206
11
votes
2 answers

Why does my typed dataset not like temporary tables?

I am attempting add a tableadapter to a stored procedure in my SQL Server 2005 Express. The stored procedure, however, uses a temporary table called #temp. When creating the table adapter, Visual Studio complains "Unknown Object '#temp'" and says…
Malfist
  • 31,179
  • 61
  • 182
  • 269
7
votes
3 answers

unable to restore database in sql server (single_user)

I am trying to restore a database in my sql server 2005 express edition. I know that to restore the database I need to make it to single user. I am giving this command to make it to single user USE [master] ALTER DATABASE database_name SET…
user281693
  • 615
  • 2
  • 8
  • 20
6
votes
3 answers

SQL 2005 Express Edition - Install new instance

Looking for a way to programatically, or otherwise, add a new instance of SQL 2005 Express Edition to a system that already has an instance installed. Traditionally, you run Micrsoft's installer like I am in the command line below and it does the…
Douglas Anderson
  • 4,652
  • 10
  • 40
  • 49
6
votes
1 answer

ROW_NUMBER OVER (ORDER BY date_column)

I am wondering. I have a complex query which runs in a SQL Server 2005 Express edition in around 3 seconds. The main table has around 300k rows. When I add ROW_NUMBER() OVER (ORDER BY date_column) it takes 123 seconds while date_column is a…
YvesR
  • 5,922
  • 6
  • 43
  • 70
6
votes
4 answers

Generate script in SQL Server 2005 with data

How can I generate a script in SQL Server 2005 with data in table?
BJ Patel
  • 6,148
  • 11
  • 47
  • 81
5
votes
2 answers

Transaction isolation and reading from multiple tables on SQL Server Express and SQL Server 2005

I have a database with a main table (lets call it Owner) and several sub tables with holdings (like Cars, Books etc). For example: Owner has columns: owner_id, name Cars has columns: owner_id (foreign key), brand Books has columns: owner_id…
athoren
  • 443
  • 4
  • 12
5
votes
3 answers

How can I avoid a deadlock between these two SQL statements?

I have two stored procedures running in separate threads, running on SQL Server 2005. One procedure inserts new rows into a set of tables and the other procedure deletes old data from the same set of tables. These procedures are running into a…
Elan
  • 6,084
  • 12
  • 64
  • 84
5
votes
3 answers

SQL Server 2005 - ModifyDate column - Is using a Computed Column a correct way to implement this?

I just want to have a "ModifyDate" column automatically populated for me when a record is either inserted or updated. Should I be using triggers or is it OK to use a Computed Column? (Using SSMS2005 and SQL Server 2005 Express)
Brian Webster
  • 30,033
  • 48
  • 152
  • 225
1
2 3
…
12 13