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

learn more… | top users | synonyms

4
votes
1answer
71 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
29 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
346 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
276 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
15 views

Optimal Number of Queries Per Batch for SQL Server

I am optimizing an application for a scenario where it will import an sql file and execute over 11 million create commands, which have have some expensive subqueries that are outside my control. This ...
0
votes
0answers
24 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', ...
0
votes
0answers
46 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
0answers
270 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 ...