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
0 answers

Windows async batch cannot open database requested by the login

I'm running SQL Server 2005 (Express) on Windows Server 2003 SP2. I'm using a scheduled task to launch a batch program that runs for several hours, during which many child processes are launched. Almost all these child processes are running…
Marc Dingena
  • 556
  • 5
  • 19
1
vote
2 answers

How do I secure the data in my winform's SQL 2005 Express database?

I have a c# winform application that uses SQL 2005 Express. The application creates math and reading quizzes and is marketed to parents of school-aged children. The parents purchase and download SQL files containing quizzes from my website and…
Frederick
  • 213
  • 1
  • 5
  • 14
1
vote
1 answer

Pass value in a Variable

I want to pass the value of 1 of my columns in my SELECT statements in a Variable. Here's my sample code: DECLARE @TotalExpense DECIMAL(18,2) SELECT a.[Posting Date] AS [Check Date], a.[Document No_] AS [Check Number], a.[Vendor No_], …
Marc
  • 11
  • 3
1
vote
2 answers

How do I add NETWORK SERVICE login via SQL Authentication?

I am trying to add the NETWORK SERVICE login cause I still can’t connect to the AdventureWorks3 database. But I want to add this NETWORK SERVICE login via SQL Server Authentication and not Windows. When I select Windows authentication, it lets me…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
1
vote
2 answers

SQL Server Express installation required for clients connecting to a server?

I would like to know if an installation of SQL Server Express is required on my client PCs? I have searched a fair bit and so far all I've seen were related to attached databases or local databases. Here's the setup of my system. There will be a…
DamonAskavio
  • 54
  • 8
1
vote
0 answers

Copy a table with data to another db in SQL server 2005 express

I have a database with a table. I want copy it along with the data to another database. How can I do this in SQL server 2005 express?
Luca Romagnoli
  • 12,145
  • 30
  • 95
  • 157
1
vote
1 answer

how to pass column name with parameter in insert sql statment

how to pass column name with parameter in insert sql statment e.g. @name='name' insert into employees (id,@name) values(1,'a') is this possible?
shmandor
  • 881
  • 3
  • 14
  • 22
1
vote
2 answers

What's the sql exception error number if the maximum limit of the database has been reached

For example SQL Server 2005 Express has a limit of 4gb on the database size, and it has been reached after cumulative inserts of data. What will be the corresponding error number?
Carl Joseph Escarian
  • 13
  • 1
  • 3
1
vote
0 answers

how to connect SQL Server 2005 express database to java

I want to create a JDBC connection with SQL Server Express 2005 when i tried the following code i got exception my code is import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class…
Lijo Joseph
  • 139
  • 1
  • 14
1
vote
3 answers

Encrypt column names of tables in SQL Server Express

What is the best way to encrypt columns in SQL Server 2005 Express edition so that no one can steal our database design? Thanks
Josh
  • 13,530
  • 29
  • 114
  • 159
1
vote
0 answers

How to export SQL Server database into Microsoft Access (2007)

How can I export SQL Server into Microsoft Access 2007? At present I can view tables but I can't view stored procedures and how to save exported database from SQL Server into MS Access. So that I can call the path in connection string.
user2801432
  • 23
  • 1
  • 6
  • 13
1
vote
3 answers

SQL Server 15MM rows, simple COUNT query. 15+ seconds?

We took over a website from another company after a client decided to switch. We have a table that grows by about 25k records a day, and is currently at 15MM records. The table looks something like: id (PK, int, not null) member_id (int, not…
john
  • 33,520
  • 12
  • 45
  • 62
1
vote
1 answer

Cheapest way to mirror an ASP web application on IIS with SQL Server Express

Rather than relying on one server, is it possible to achieve high availability with two servers and no hardware load balancer? Either Network Load Balancing and have SQL Server Express mirrored between the two servers (IIS would be on both servers…
Tom R
  • 11
  • 1
  • 2
1
vote
4 answers

SQL Server Management Studio Express 2005 has no Configuration Manager

Where is the configuration manager for SQL Express 2005? I need to configure SQL Server for TCP/IP but there is no configuration manager with the package. I see SQL Server Database Publishing Wizard, I see SQL Server Migration Assistant for…
brohjoe
  • 11
  • 1
  • 1
  • 2
1
vote
1 answer

How do I copy records from one database to another?

I need to pull data from one SQL 2005 Express database to another and I need to do this periodically. It is not a straight copy from one table to another, but I would use different views from the source table. I also need to do this periodically.…
gyurisc
  • 11,234
  • 16
  • 68
  • 102
1 2 3
…
12 13