Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

Filter by
Sorted by
Tagged with
0
votes
1answer
855 views

Where to look for clues as to why SQL Server become unresponsive/crashed?

Recently an SQLExpress instance suddenly become unresponsive/crashed whilst I was mid-dialog (SSMS transaction log backup), which froze with an hourglass and the dialog was unusable. No other ...
12
votes
1answer
10k views

How to move folder of SQL Server LocalDB instances from the default location?

I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
2
votes
1answer
550 views

In SQL Server, are there any other options of data Import and Export

I've been working with SQL Server since SQL Server 7. So I know about BCP, Bulk insert, openrowset and SSIS. My question is a simple one: Do you know of any other ways to Import/Export data using ...
2
votes
2answers
2k views

Trigger to create a variable Table to be sent to service broker

I've setup a service broker for the first time and tested it... Looks good. Everytime a DML operation happens on a specific table; Let's say the Price Table, a trigger calls a stored procedure passing ...
8
votes
2answers
2k views

Can I have full backups on multiple disks?

Currently, I've only got one backup file, IMTDB.bak, and it's on the same HDD as the Database itself. I want to increase the redundancy of this DB backup by essentially "copying" it to another disk, ...
2
votes
2answers
3k views

Can't shrink WSUS SQL database

I have a Windows SBS2011 installed. It has file sharing, Exchange and WSUS running off it. WSUS console was, and always been, running slowly - I have no comparison with any other system, so I ...
1
vote
1answer
742 views

How do I reindex my SQL Server Express database to free up space when it's already full?

Being the naive guy that I am, I let my DB get full (10GB is the max for SQL Server Express), and have now decided to drop columns to reclaim space. I'm dropping 10 columns from a ~50M row table to ...
1
vote
4answers
1k views

How do I check how many rows a query will affect before executing it?

I'm writing an application to interface with my database (SQL Server 2014 SP1 Express), and there are two sections of the application that worry me slightly. The first involves an UPDATE: UPDATE Jobs ...
3
votes
1answer
3k views

Can't upgrade a SQL Express to SQL Standard

I have a 64 bit SQL Server 2008 Express R2 installed and I cannot upgrade it to a fully licensed 2014 Standard. When I try to update to SP 4, I get this issue: If I try to run the upgrade edition, ...
1
vote
1answer
36 views

Move database from windows server 2003 to windows 7/8?

I am working with this company currently running their SQL Express database in a virtualized Windows Server 2003. What would you experts say about replacing that for a virtualized slimmed-down ...
4
votes
1answer
15k views

command or query to ping SQL server

I have 2 windows 7 machines on a very high security domain one acting as a server, the other as a client. Each box has a SQL Server Express 2005 database and application "A", however I'm only using ...
1
vote
1answer
627 views

Combine multiple records into one, using name from only one record

I've got a query that returns a table of technicians and the number of work orders they've filled. The problem is that sometimes technicians get entered using their full name, and sometimes they get ...
4
votes
3answers
5k views

SQL Server 2008 R2 Express size

I have what I believe is SQL Server 2008 R2 Express installed on a production server. When I connect to it with SQL Server Management Studio it shows up as SQL Server 10.50.1600. If it is in fact SQL ...
1
vote
1answer
1k views

What connection string to use to connect to network server?

I have a database on my computer running on SQL Server Express 2014, and I'd like other computers connected to my network to be able to connect to it using a C# program I wrote. I've done the ...
0
votes
2answers
1k views

Why does my SQL Server Express (2014) connection break after restarting my computer?

For some reason when I install SQL Server Express (2014), it works fine for a while (usually a day or two), and then quits allowing me to sign in. I'm not just talking about remotely here, either. ...
0
votes
1answer
81 views

Is having SQL Server express database on client better than querying data on a remote server? [closed]

I'm planning to create a SQL Server Express database on each client machine that will sync with the remote server's data. What I'm trying to achieve is to have a faster processing and querying of data ...
2
votes
1answer
742 views

Selecting from an excel spreadsheet into SQL Server table

This question has been asked before but I tried giving full admin rights to the SQL Server user on C:\temp\ folder location (I am using Windows authentication into SQL Server Express). So for the ...
21
votes
1answer
59k views

Where is SQLCMD.EXE in SQL Server 2014 Express?

Using "SQLCMD.EXE" to back up my SQL Server Express databases for years I just discovered that after installing the 2014 version, I found no SQLCMD.EXE anymore. In previous versions it was located at ...
0
votes
1answer
440 views

SQL Server Express Limitation

I would like to use Express instead of Standard. Does Express still have the annoying habit of going to sleep if left unused for a period of time?
0
votes
1answer
114 views

Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to 4G?

I recently deleted some data from a table that was not needed and growing to too big a size with this query which provided to me by a support tech... declare @mdate datetime set @mdate='04/04/2014'...
0
votes
2answers
1k views

SQL Server Express to SQL Server Standard upgrade?

The database size on our SQL Server Express database is around 10GB. I checked our database size and it said 38GB. Do I need to upgrade to SQL Server Standard edition? Is it expensive to upgrade? ...
7
votes
3answers
10k views

Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?

I have two computers running SQL Server 2008 Express: c01 and c02, I setup both for remote connection using windows authentication. Worked fine for c02 but not for c01. This is the error message I'm ...
2
votes
2answers
5k views

SQL Server Express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL Server and am following some tutorials. I have not yet created any databases. In SQL Server 2012 Management Studio I click on "connect" -> "Database Engine". I noticed that, using the ...
2
votes
2answers
207 views

Error after removing sql server 2008 R2 Express edition and instaling Entreprise edition: Unable to connect to MyHost\MSSQLSERVER

So I'm having this issue after installing MS SQL Server 2008 R2 Enterprise edition, I'm getting this message error: Unable to connect to WIN7 \ MSSQLSERVER A network-related error or instance-...
1
vote
1answer
206 views

Unable to view SQL Server services

Whenever I enter SQL Server Configuration Manager and choose SQL Server Services I would always get the following error message: "The remote Procedure call failed. [0x800706be]" everything else works ...
0
votes
2answers
2k views

Mirroring Database tables and views on SQL Server Express

I need some idea on how to mirror all table and views in my development server to my demo server. Both servers are running SQL Server Express. I have tried it manually but it's very time consuming. ...
3
votes
2answers
713 views

SQL Server Express Freezes for a couple minutes

I have SQL Server Express on an AWS micro instance. These instances have only 615MB of RAM. For the most part it performs fine. My application can make up to about 15 db connections. However, every ...
1
vote
1answer
347 views

How to store lots of small text in a SQL Server database?

I have a table with a varchar(max) column that stores text ~4-10KB in size. Data is just being added - never modified, it is a log. My problem is that a table grows too large in size - I would like to ...
3
votes
2answers
14k views

How to attach an .mdf file that was not properly detached?

One of our clients had a SQL Server 2000 database, on a system which is no longer running. They have no idea what was in the database. They have given me the .mdf and .ldf files, and want us to ...
5
votes
1answer
3k views

SQL Server 2008 R2 Upgrade (Express to Standard) fails. No “Select Instance”

Hello there, i got stuck in the progress of upgrading 3 systems from SQL Server 2008 R2 Express Edition --> SQL Server 2008 R2 Standard Edition Problem: The Option "Select Instance" in the ...
1
vote
3answers
8k views

Inserting Serbian Latin and Cyrillic characters

I am using SQL Server 2012 Express as part of my asp.net development workstation. Database and table collation is set to Latin1_General_CI_AI. Attribute types are nvarchar(max) and varchar(max). ...
1
vote
1answer
2k views

SQL Server Express 2008: Can I store database files (.mdf, .ldf) in directory other than the default DATA directory?

I have a SQL Server Express 2008 instance of which I am attaching databases from development systems quite often. Typically I transfer the .MDF and .LDF files to the instance's DATA folder and ...
0
votes
1answer
58 views

Should I consolidate my SQL instances? [closed]

I'm trying to find an answer to this one with not much luck. I have an MS DB server with our main databases on it. Over time, someone has installed SharePoint and Microsoft Online (365) services ...
2
votes
1answer
5k views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

We have a group of users within my company that are running reports directly against our production database. It has gotten to the point where they are hammering it enough to cause performance issues ...
4
votes
1answer
1k views

Why clustered index scan?

I just started to learn to optimize my queries and to analyze their query plans. I thought this query would generate nonclustered index seek + key lookup. SELECT ct.* FROM Person.ContactType AS ct ...
1
vote
2answers
605 views

Table not dropped correctly in SQL Server Express 2008

I've dropped a table but it is still listed in sys.tables. What's more confusing is that I can create the table again as one user, but if I log in as another user with the same permissions, I can't (I ...
4
votes
3answers
47k views

How to automatically execute a stored procedure every day at a particular time?

Can you please help me how to execute a stored procedure automatically in SQL database without any transaction in SQL? I want to execute on particular fix time.
0
votes
2answers
2k views

“an agent job has not been created for this subscription”

I have set up merge replication with a publisher on my SQL Server 2008 R2 box with the distributor on this box too; in Express I have created a subscriber but the subscriber won't run because of the ...
3
votes
5answers
1k views

Extract data to another computer

I have SQL Server 2008 R2 Express edition, and I want to export the data in that database to another computer so I can import it again in that computer. How please? What I have tried Right-click ...
0
votes
0answers
40 views

How can I use Query notification and what are the requirement? [duplicate]

I want to use Query notification in my app to get the notification from database for updated data, so that app will fire the query to get updated data instead of monitoring the database for every 5 ...
0
votes
1answer
546 views

Security Concerns of SQL Server Express for Web e-Voting web application

I am building a database driven web application. The web application is basically an E-Voting website, where users can register and vote on things that concern their community ... etc. The database ...
2
votes
1answer
5k views

SQL Server taking a lot of memory

I have SQL Server Express on my VPS(2GB RAM) with a database size of 1.5 GB that I expect will increase to 15 GB. I have noticed that SQL Server is using 1.5 GB RAM even when only small queries has ...
-1
votes
1answer
292 views

Back up my ASPNETDB

I want to back up my database but I got this error: Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'My-laptop\user'. I'm using SQL Server Express ...
1
vote
1answer
756 views

Can I install sql server on Win XP machine with user profile on D drive?

Is it possible to install sql server on a windows xp machine where the user profiles are created on a non system root directory, that is, on D drive rather than C drive? I am trying to install SQL ...
13
votes
5answers
9k views

SQL Server 2008 Full Text Index Never Seems to Complete

Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
1
vote
0answers
311 views

FOR XML EXPLICIT problems in SQL Server 2005 Express

SQL Server 2005 Express Service Pack 2 w/Advanced Services Windows 2003 R2 I recently migrated a database from MSDE 2000 to MSSQL 2005 that is used for a tourist website that can be displayed in one ...
0
votes
0answers
50 views

Max connections sql server express could have? [duplicate]

Possible Duplicate: Max connections SQL Server Express could have? I have sql server 2005 express edition installed on one of my client's machine, and lots of other users are also connected to ...
3
votes
3answers
12k views

Which SQL Server Express edition is right for me?

I have developed a Java program which works with SQL Server as it's database. I have installed SQL Server 2012 Enterprise edition on my Windows and designed the database via SQL Server Management ...
3
votes
1answer
528 views

SQL Server 2008 R2 Express - Runs at an average of 2-3% CPU, but gets stuck at 100% sometimes

Edit: Skip to the last paragraph for the summary-version! I am dealing with a SQL Server 2008 R2 Express installation. I have a fairly complex stored procedure. Depending upon the inputs, it may ...