Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008r2-express]

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

223 questions
6
votes
1 answer

SQL Server 2008 R2 Express error: Cannot open database "PersonnelPro" requested by the login. The login failed

I am using SQL Server 2008 R2 Express and the "SQL Server and Windows Authentication" mode in my database. I can open the database using Enterprise Manager, but when I run my aspx application, I get: Cannot open database "PersonnelPro" requested…
DNR
  • 3,706
  • 14
  • 56
  • 91
5
votes
6 answers

Microsoft SQL Server Native Client 10.0 Login timeout expired

I have a freshly installed SQL Server 2008 R2 Express. I'm trying to run SQLCMD locally (please do take note locally) but I am receiving the error: Named Pipes Provider: Could not open a connection to SQL Server [2] Sqlcmd: Error: Microsoft SQL…
Xian Garcia
  • 51
  • 1
  • 1
  • 5
5
votes
6 answers

SQL Server Express performance problems

Initiation I have a SQL Server Express 2008 R2 running. There are ten users who read / write permanently to the same tables using Stored Procedures. They do this day and night. Problem The performance of the Stored Procedures is getting lower and…
flosk8
  • 465
  • 1
  • 6
  • 17
4
votes
4 answers

How to connect Visual Studio 2010 Express C# to SQL Server Express

Is there any real workaround to getting the Express edition of C# connected to database options other than the lightweight options allowed (Access, SQL Compact, or SQL file)? As has been noted elsewhere, it's possible in the web edition to do so. It…
Jeff Dunlop
  • 893
  • 1
  • 7
  • 20
4
votes
2 answers

Opening SQL Server Express via JDBC in Mathematica?

I have two computers with two (ostensibly) identical installations of SQL Server Express 2008 R2, both running Windows 7 64-bit. On one computer (call it "red"), I can execute the following mathematica code to open a connection to the database and…
Reb.Cabin
  • 5,426
  • 3
  • 35
  • 64
4
votes
4 answers

SQL: Comparing Dates with only Month and Year columns

I have a table MonthlyShipments that looks like: partnumber | quantity | month | year | part1 | 12 | 6 | 2011 | part1 | 22 | 5 | 2011 | part1 | 32 | 4 | 2011 | part1 | 42 | 3 | 2011 | part1…
anonymous
  • 6,825
  • 8
  • 47
  • 60
4
votes
3 answers

how to import an excel file into sqlserver 2008

How can i import an excel file into a new table in sqlserver2008 express edition using an sql query without using the import wizard Thanks Prady
Prady
  • 10,978
  • 39
  • 124
  • 176
4
votes
2 answers

SQL Server 2008 R2, cant create a new DB

Having real problems creating a DB on my version of SQL Server 2008 R2 Express. I've followed the links to the below but no info provided. Thanks in advance for any help. TITLE: Microsoft SQL Server Management Studio Create failed for Database…
Fruitful
  • 597
  • 2
  • 9
  • 16
4
votes
2 answers

How to delete oldest week(period) in MS SQL database?

MS SQL 2008R2 Express, I have database - one table with rows. And when db size became about 10gb I need to clean one oldest week in this table (I dont know the date). Could you help me with script? Thanks. UPD1. There is column DateAndTime, so i…
Роман Кириллов
  • 139
  • 1
  • 10
4
votes
2 answers

SQL Server 2008 R2 Express - Instances continually starting up database

I have 3 instances running of SQL Server 2008 R2 Express, to try and circumvent the 1gb limit for express editions. Instance 1 (SQLExpress) is attached to my busiest web site, servicing around 3000 concurrent online users. This database functions…
gavins
  • 43
  • 1
  • 3
4
votes
3 answers

What is Best Approach for Opening/Closing SqlConnection in C#

I would like to know what could be best approach to open a SqlConnection with Sql Server 2008R2 Express Edition Database. This Version of Sql has Limitations of RAM Usage and CPU Usage so we must adopt something best to open a SqlConnection. Right…
Jaa Zaib
  • 151
  • 2
  • 6
  • 14
4
votes
1 answer

Query that worked for months now timesout

I have a query run from a Delphi application that suddenly started timing out last week after running perfectly for months. further more when it runs it slows the server to a crawl leaving other users believe the system has crash Running from the…
Marc
  • 49
  • 3
4
votes
1 answer

Live sync between SQL Server 2008 R2 and MongoDB with Express

I have created custom script in Express that actually migrates SQL Server database to MongoDB. But I am facing problems in live syncing between the two databases. Currently I have added a column updated_by in both the databases. Then I fetch the…
Viren Ajmera
  • 101
  • 2
  • 6
4
votes
3 answers

Node JS and SQL Server 2008 R2 Express

I want to use NodeJS to connect to a SQL Server 2008 R2 Express database. I've looked around at what NPM has to offer. Have tried mssql, mssql-simple and node-SQLServer. Some of them can be installed some do not. And those who do, will not access…
Krister Johansson
  • 691
  • 2
  • 10
  • 34
4
votes
6 answers

How do you know if a SQL table has been changed since the last time you used it?

Is there a way to know if the data in a SQL Server 2008 R2 table has changed since the last time you used it? I would like to know of any type of change -- whether a new record has been inserted or an existing one has been modified or deleted. I am…
Water Cooler v2
  • 32,724
  • 54
  • 166
  • 336
1
2
3
…
14 15