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

learn more… | top users | synonyms

0
votes
0answers
20 views

Connecting 2 databases using sp_addlinkedserver

I have 2 servers and I want to connect to them using this: exec sp_addlinkedserver 'myserver1.dyndns.biz'; exec sp_addlinkedsrvlogin 'myserver1.dyndns.biz' , 'FALSE', NULL, 'remoteuser', ...
1
vote
1answer
29 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
0
votes
0answers
31 views

Reporting Services Configuration Manager - error message “Could not connect to server…server was not found..”

I am attempting to install and configure SQL Reporting Services (SSRS). I have a windows 8.1 Pro OS laptop. Running SQL Server 2012 Express with SQL Server 2012 Management Studio. I downloaded and ...
0
votes
1answer
49 views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
1
vote
1answer
100 views

Cannot install database engine services, replication and SQL writer

I am trying to install SQL Server 2012 Express, but I get this error (I try to uninstall and delete registry key, try to change account for database engine to NT Authority\System, but reinstall still ...
1
vote
0answers
38 views

SQL Server 2012 Express and Hardware Differences affecting performance [closed]

Here is the setup. I'm running SQL Server 2012 Express on the following two boxes: Box 1 (Server) : Dell T710 2x X5680 3.33Ghz Xeon 92GB Memory RAID 10 - 146GB Dell drives, w/ Cachecade SSD drive ...
1
vote
1answer
35 views

Failed to attach SQL Express DB, Could not continue scan with NOLOCK

We have a remote client that had to rebuild their server and has been having trouble with their SQL Express database since. I cannot remotely connect to this client unfortunately. I had them run "DBCC ...
3
votes
3answers
141 views

Install Express/Standard side-by-side

I've reviewed these two existing questions: Install SQL Server 2008 Express on same machine as normal SQL Server 2008 install? Installing SQL Server Express in parallel of Standard ...and I ...
4
votes
1answer
66 views

Permission error when executing a 5.6 GB sqlcmd file

I am trying to run a very large file through the sqlcmd command and it works perfectly with files of 100 MB up to 1.4 GB. This is what I have tested so far, but when I try to run a file which is 5.6 ...
1
vote
2answers
47 views

Monitor executed SQL statements from external application [duplicate]

I have an external application connecting to a SQL Server 2008 Express database. Is it possible to monitor (view) the SQL statements that are generated by the external application at all? I am trying ...
5
votes
1answer
536 views

How many users are supported on SQL Server 2012 Express?

I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like. The limitation of SQL Server 2012 Express is 10 GB. It is the ...
2
votes
2answers
2k views

Differences between the different installers of SQL Server 2014 Express

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate it. ...
5
votes
1answer
198 views

How to create a server instance of just ComputerName instead of ComputerName\SQLEXPRESS

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014. I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that ...
0
votes
1answer
80 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 ...
1
vote
3answers
1k views

SQL Server express - Management studio installation hangs at native images installation

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
2
votes
1answer
107 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 ...
3
votes
1answer
199 views

Is Service Broker the best choice for auditing data changes on SQL Server Express?

My project is to audit 5 to 10 existing tables in our system without prolonging transactions. Whatever method is used, it has to work on SQL Server Express 2005 to (eventually) 2016. I've done ...
2
votes
2answers
135 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 ...
7
votes
2answers
460 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, ...
1
vote
2answers
343 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
63 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
121 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 ...
0
votes
0answers
255 views

restore a database in Visual Studio 2013 Setup development

How can I restore this database backup to SQL Server Express in Visual Studio 2013 Setup development system? Visual Studio 2013 Uses Install Shield Limited Edition. I could add SQL Server Express in ...
2
votes
1answer
677 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
28 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 ...
0
votes
1answer
262 views

Why are some of my migrated tables showing “The given key was not present in the dictionary” in WebMatrix's interface?

I'm having an issue while using the SQL Server Migration tool to convert Access accdbs into SQL Server 2014 Express. I am converting the tables using SQL Server Migration Tool and I have a connection ...
2
votes
2answers
939 views

Sync many client database to one central database

We have client application which can be installed on local machine where users can work offline and create projects in it. This application is already developed. Now we need to create Admin ...
1
vote
1answer
181 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 ...
1
vote
1answer
227 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
522 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
193 views

SQL Server Express 2012 Repair

I have a copy of SQL server Express 2012 database which may be corrupt. When I tried to run a repair on it I was asked for the original installation media. The Options were for an MSI or ISO image. ...
0
votes
1answer
378 views

Can SQL Server replication be used for Point-of-Sale (POS)?

We are looking for a solution that will synchronize the databases of our POS. The scenario says we have 3 POS with SQL Server Express installed on each machine. We want these databases to be in-sync ...
-3
votes
1answer
860 views

SQL Server 2012 Express Database Backup Script [closed]

Just a quick one. I want to do a full weekly backup of my SQL Server 2012 Express database. I have created a SQL script and batch file to automatically do a full backup of my database each week and ...
0
votes
1answer
453 views

Only local administrators can connect remotely

I'm facing a problem that when I try to connect to the SQL Express instance from client to server. The Server logs an error: SSPI handshake failed with error code 0x8009030c, state 14 while ...
0
votes
1answer
240 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?
1
vote
2answers
3k views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
0
votes
2answers
599 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? ...
0
votes
0answers
24 views

Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to SQL express size 4G? [duplicate]

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
1answer
70 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 ...
0
votes
2answers
850 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 ...
0
votes
2answers
161 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 ...
2
votes
2answers
799 views

Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)

So I am having a heck of a time importing a CSV file. The ultimate goal is to create a repeatable process to import the file. The only way I've been able to import the file is in a roundabout way ...
1
vote
1answer
185 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
984 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. ...
-1
votes
2answers
8k views

how can I install Microsoft SQL Server 2005 Express Edition on Windows 8.1 [closed]

I can't install Microsoft SQL Server 2005 Express Edition on Windows 8.1.
3
votes
0answers
333 views

utf8mb4 in SQL Server Express

We have some web applications based on databases using utf8mb4 as character set and utf8mb4_Standard as collation. We saw that we can use any character we want with this setting. In SQL Server ...
15
votes
1answer
22k 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 ...
2
votes
1answer
5k views

SQL Server 2008 R2 Express single CPU core usage and need of upgrade to SQL Server 2014 Express

In our office we are using SQL Server 2008R2 Express which is installed in Windows server 2012. The SQL Server database is accessed by more than 60 users in network simultaneously. In recent days we ...
1
vote
3answers
3k 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). ...
3
votes
2answers
300 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 ...