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

What do you use to Profile SQL Server 2005 Express?

I've got a problem on an SQL Server 2005 Express instance, and I need to see exactly what is being run, since what I believe is being run works fine when I run it from Management Studio. It appears that Profiler is not available for SQL Server 2005…
John MacIntyre
  • 12,910
  • 13
  • 67
  • 106
2
votes
1 answer

InvalidOperationException when executing SqlCommand with transaction

I have this code, running parallel in two separate threads. It works fine for a few times, but at some random point it throws InvalidOperationException: The transaction is either not associated with the current connection or has been completed. At…
Serhat Ozgel
  • 23,496
  • 29
  • 102
  • 138
2
votes
1 answer

Same name tables under different schemas with SQL Server 2005 Management Studio Express

I know how to create a new schema and write a DDL script to create tables with the same name that reside in different schemas in the same database. I want to know how to do that using SQL Server 2005 Management Studio Express. To repeat, I want to…
Water Cooler v2
  • 32,724
  • 54
  • 166
  • 336
2
votes
3 answers

Convert SQL Server Express 2005 .mdf to 2008 .mdf?

Hi I have a Visual Studio solution and an ASP.NET MVC project that uses a SQL Server Express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for SQL Server Express 2008 ? Thanks
Pricey
  • 5,799
  • 12
  • 60
  • 84
2
votes
2 answers

SQL Dependency with SQL Server express 2005

Is it possible to use SQL Dependency with SQL Server Express 2005 which comes with VS 2008?
Aakash
  • 695
  • 3
  • 10
  • 25
2
votes
2 answers

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers

I have installed SQL Server Management Studio Express 2005 in windows 7. SERVER TYPE: Database Engine SERVER NAME: Avani-PC\SQLEXPRESS AUTHENTICATION: Windows Authentication USER NAME: Avani-PC when I click on connect I found the following…
Avani Soni
  • 33
  • 1
  • 3
2
votes
1 answer

Why do I get a permission error when connecting to SQL Server from Visual Studio?

I have SQL Server 2005 SP4 Express, when I try to establish connection from VS2010 to my database, I get a error: You don't have permission to open this file Contact the file owner or an administrator to obtain permission. I am using windows…
Ahmed
  • 21
  • 1
  • 1
  • 3
2
votes
2 answers

Absolutely simple SQL Server query doesn't return anything

What I have here is very strange to me... Select BARCODE, DATA from HISTORIA WHERE BARCODE='25405187' AND DATA = '2013-03-08 00:00:00.000' Select BARCODE, DATA from HISTORIA WHERE BARCODE='25405187' Simple right? Now please look at returned…
baron_bartek
  • 1,073
  • 2
  • 20
  • 39
2
votes
2 answers

SQL Where Exists Doesn't Filter?

System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'AK_SeqNo'. Cannot insert duplicate key in object 'dbo.SeqNo'. I get the above SQL Server 2005 Express error randomly. Maybe once every 3 weeks from the stored…
Cheval
  • 403
  • 4
  • 14
2
votes
1 answer

Potential causes and solutions for the transaction log in database being full

In the data access layer of my teams ASP.NET application, I run stored procedures against our database through the use of the .NET SQLClient. After adding new code to allow an insert operation on the database, I tested the code, and received the…
Christian
  • 1,685
  • 9
  • 28
  • 48
2
votes
1 answer

Error accessing stored procedure

We have a .NET3.5 Windows Forms application that calls an ASP.NET SOAP web service on the same server. This web service then saves the data into a SQL Server Express 2005 database, again on the same server. The application has been deployed…
Jon Lawson
  • 582
  • 1
  • 6
  • 16
2
votes
1 answer

BIDS installation with SSIS , SSRS and SSAS on SQL Express 2005

I want SQL Server 2005 Express in my machine so that I can have a local database (not allowed to install standard or enterprise))and at the same time should be able to create projects for SSRS, SSIS and SSAS in BIDS. I saw this post : Installation…
Sumita Narayanan
  • 21
  • 2
2
votes
3 answers

Grouping by case field

so I'm pretty new to SQL and almost wholly self-taught so far. I'm currently trying to run some analysis on the ranks of staff, where I'm trying to "reclassify" about 15+ ranks to 4 rank categories. Then I want to group by those categories, but am…
mattknight1986
  • 23
  • 1
  • 3
1
vote
2 answers

Access a SQL Server 2005 Express Edition from a network computer

How do you access a SQL Server 2005 Express Edition from a application in a network computer? The access I need is both from application (Linq-to-SQL and ODBC) and from Management Studio
Jedi Master Spooky
  • 5,629
  • 13
  • 57
  • 86
1
vote
0 answers

SQL Server Replication, How to Synch. a Subscriber gone offline

We are using SQL Sever 2005 replication for out application. Every thing is working fine without any problems. However, recently we ran into a situation to which I have no solution. We use merge replication with the publisher(SQL Sever 2005) in one…
rAm
  • 1,086
  • 2
  • 16
  • 23
1 2
3
…
12 13