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
1
vote
1 answer

Install SQL Server Express edition in silent mode

I use C# and need to install SQL Server 2005 Express edition in silent mode in my project and use code below, but for the first time, SQL Server do not install correctly . Sql database engine do not install.. When I uninstall SQL Server 2005 Express…
Mohsen Ahmadi
  • 31
  • 4
1
vote
1 answer

Automate rebuilding of Indexes in SQL Server Express 2005

My team is working on a .NET web application whose data storage is managed through SQL Server 2005 Express. Is it possible to automate a task in the database so that it rebuilds certain indexes automatically on an interval following…
Christian
  • 1,685
  • 9
  • 28
  • 48
1
vote
0 answers

How can i increment the counter?

At the registration time i wanted if side is left then my left count will increment and side is Right then my right is increment and both side is filled then their sponcor will increment... How can i do this???? HERE i wanted to increment the my…
user1744507
  • 11
  • 1
1
vote
1 answer

HOW To remove ' in a column SQL server 2005

I have a specific column (description) in a particular table. I used bulk loading to insert data in table, but in retrieving data it's giving an error because of this column (description). The problem is occuring due to ' in description (like 12'…
user1730668
  • 11
  • 1
1
vote
0 answers

Mystery of the missing SQL Server transaction log (.ldf) file

I have just finished development of a C# 2010 windows desktop application that uses SQL Server 2005 Express. I gave it to a colleague to test on his Windows 7 (64bit) laptop. The program ran as expected on day one, connecting the database to the…
Merlin
  • 157
  • 2
  • 12
1
vote
2 answers

Create view with extra column indicating type in SQL Server

I need to create a view with a column that indicates which table does the row come from. I'm using SQL Server 2005 Express To be more specific, I have a database with a table called users, a table called developers and a separate one containing bank…
cangrejo
  • 2,189
  • 3
  • 24
  • 31
0
votes
1 answer

Can't Connect to SQL server 2005 installed on windows 7 X64

I have installed SQL EXPRESS 2005 on Windows 7x64. I have already added sqlsvr.exe in firewall exception, enabled both Names Pipes and TCP/IP from SQL server Configuration Manager. The SQL server Browser service is also set up to run automatically.…
Prajwal
  • 298
  • 1
  • 7
  • 18
0
votes
3 answers

Connecting to SQL Server database using Visual C++

I am trying to connect to the sample database Northwind in SQL Server 2005 Express through Visual C++ 2008 using the following code: SqlConnection^ con=gcnew SqlConnection(); con->ConnectionString="Data Source=localhost\\SQLEXPRESS;Initial…
ankit0311
  • 735
  • 3
  • 10
  • 20
0
votes
2 answers

Team Foundation Server 2005 and SQL Express 2005

I haven't seen anything that says SQL Express 2005 is not supported for use with Team Foundation Server 2005. However, when I attempt the installation I get all sorts of errors "SQL Agent service not installed", "SQL Server 2005 Analysis Services…
MattH
  • 1,975
  • 6
  • 24
  • 31
0
votes
1 answer

installation of SQL Server 2005 Express edition in Windows 7

I recently installed VS 2008 express edition on windows 7(32 bit system). Then installed SQL Server 2005 SP3 Express edition. But the problem is I am not able to create a database in my SQL Server (I am not able to find the option to create a…
user923452
  • 9
  • 2
0
votes
1 answer

ADO SQLServer dbGo generates a EAccessViolation

I have a program that is filling a DB in a single thread. I Use one connection for all queries. Thats so i will be able to run them all in transactions. Every second I get a new set of files that has to be entered into a SQL Server 2005 Express. The…
None
0
votes
4 answers

SQL DELETE STATEMENT problem with returned rowcount

I have a statement like this: DELETE TABLENAME WHERE COLUMN = NUMBER; SELECT @@ROWCOUNT AS RC; if i run it from the code (classic asp) i get Error:Item cannot be found in the collection corresponding to the requested name or ordinal. the DB is sql…
Y.G.J
  • 1,098
  • 5
  • 19
  • 44
0
votes
1 answer

Inserting records permanetly into sql server express edition using c#

I created a database in sql server express edition, in that i create a table called employee. Now i am able to inserting rows(records) dynamically into table successfully, and i can also read those records successfully. But the problem is the values…
Siddrtha
  • 1
  • 2
0
votes
1 answer

What exactly is this error?

I was trying out making a website with asp.net to see how data binding works but when I launch the application, it throws this error. Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data…
Niranjan
  • 813
  • 2
  • 12
  • 33
0
votes
2 answers

Stop SQL Server listening on Remote Ports

How do I 'lock down' my SQL Server 2005 installation to not listen on remote ports? My SQL Server 2005 database instances are only used locally on the machine, so I want to prevent it listening on remote ports for security purposes, but do not want…
FrinkTheBrave
  • 3,894
  • 10
  • 46
  • 55
1 2 3
…
12 13