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

learn more… | top users | synonyms

2
votes
2answers
594 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 ...
2
votes
2answers
713 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 ...
4
votes
1answer
53 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
1answer
24 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 ...
3
votes
0answers
286 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 ...
1
vote
0answers
269 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
175 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 ...
-1
votes
0answers
34 views

Possible SQL Server 2012 Bug - failing to show all tables following a full database recovery

Background: I was testing some software that recovers individual tables from a custom backup file. Before I started to run his recovery software I thought that I would take a backup of my database ...