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
4
votes
2 answers

VB.NET 2005 connecting to SQL Server Express, No errors but cmds don't run

I am trying to connect to SQL Server Express locally using VB.NET 2005. I pulled my connection string directly from the app.config file. When I run, I get NO errors and the connection states returns open, however the commands are not being…
Carrie Kendall
  • 11,124
  • 5
  • 61
  • 81
4
votes
6 answers

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 the above error, however, on the last line of the following code. Can you give me advice on how to fix this? This compiles correctly, but I…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
4
votes
2 answers

How do I manage version control when developing with SQL Server Express?

I am developing a website using SQL Server Express on my development machine. My web hosting company is providing me with SQL Server 2005. At the moment all I have is a database that I develop with and a database that is on the live server. I do not…
tpower
  • 56,100
  • 19
  • 68
  • 100
4
votes
2 answers

SQL Server 2005 (Express) - Login vs User

I'm quite new to Microsoft SQL Server. I have some experience with MySQL, and there you have a user with privileges, if I understand things right; these privileges decide which databases you have access to on the MySQL server. However now I am in…
cc0
  • 1,960
  • 7
  • 40
  • 57
3
votes
2 answers

SQL value contrains to another table data

I have a couple of tables, lets say I have a cars table and I have another table which hold all types of cars available(just to avoid multiple entries on the cars table) so I want a constraint on my cars table that has a "list/set" of types of cars…
Termiux
  • 418
  • 2
  • 7
  • 20
3
votes
2 answers

Changing ASPNETDB name

Is there anyway to change the ASPNETDB and also using SQLExpress (2005) user instance ? I have changed my web.config's connectin string to
Hashem
3
votes
1 answer

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 soon. My application uses the bulk insert…
jmbowse
  • 31
  • 1
3
votes
1 answer

Using SQL Express edition commercially

Can I use SQL Server Express edition for commercial use? Can our clients redistribute SQL Server Express edition with their application?
Viratkumar Kothari
  • 71
  • 7
3
votes
2 answers

SQL query, select values of a column only if

Im using SLQ server 2005. I have this table were i register a list of items creating an "order" wich will be sent to the warehouse so they know what it needs to be sent back. this is my code. id_pedido=id_order, id_articulo=id_item,…
Edgar Holguin
  • 179
  • 1
  • 4
  • 11
2
votes
3 answers

SQL scalar variable value between and

'Names' in table 'Data' "type12pen105A" "type12pen110A" "type12pen121B" Declare @n int; select Names From Data where Names ='type12pen'+cast(@n between 100 and 110 as varchar)+'A' My Required out put is "type12pen105A" "type12pen110A"
gopi nath pandraju
  • 79
  • 3
  • 10
2
votes
5 answers

How can I combine these queries?

I have 5 queries I'd like to join together. Basically what they do is they go though the database and select how much a tenant has paid, and how much a tenant owes based on how long ago he or she was charged. I have four categories Charge < 30 days…
Malfist
  • 31,179
  • 61
  • 182
  • 269
2
votes
2 answers

How to list SQL 2005 Express instances

I would like to list what instances of SQL 2005 Server (Express Editon) are installed on local or remote machine (my app is in Native C++). I found that i can make it by SQLDMO, however it seems that SQLDMO does not see SQL 2005 Express Edition and…
Marcin
2
votes
4 answers

How to exclude first row in SQL Server 2005 Express

I want to exclude the first row from displaying from a SQL Server 2005 Express database... how do I do this? I know how to return just the top row, but how do I return all rows, except the top row
Denis
  • 21
  • 1
  • 2
2
votes
2 answers

Trouble setting up witness in SQL Server mirroring scheme w/ error

I've got a trio of Windows servers (data1, data2 and datawitness) that aren't part of any domain and don't use AD. I'm trying to set up mirroring based on the instructions at http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx. I've had…
Chris Bloom
  • 3,526
  • 1
  • 33
  • 47
2
votes
1 answer

How to set the default author name in MS SQL 2005 stored procedure template in management studio?

In MS SQL Server Management Studio Express, is there a way to set the default author name to my name when I create a stored procedure by right clicking on the "Stored Procedures" folder under "Programmability" folder? It would save me a lot of time…
Leo Nix
  • 2,085
  • 2
  • 24
  • 37
1
2
3
…
12 13