Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
7
votes
3 answers

Entity Framework EF4.1 - stored procedure "could not be found in the container"

I have a SP in my database. For EF4.1, using the DbContext API. After importing the function from the data model, references to the stored procedure works fine in my development environment. But when published to the server, it fails with a…
Glen Little
  • 6,951
  • 4
  • 46
  • 68
7
votes
2 answers

Difference between SQL Server 2008 Express R2 and SQL Server 2008 Enterprise R2 version

What are differences between SQL Server 2008 Express R2 and SQL Server 2008 Enterprise R2 version? Actually I want to know all exact limitations in Express version which are not in Enterprise version. Like Max DB file size etc
Riz
  • 6,746
  • 16
  • 67
  • 89
7
votes
5 answers

How to import .sql file into SQL Server Express

I have a plain sql file with some SQL INSERT statements. Is it possible to import it in my local SQL Server Express instance?
ggarber
  • 8,300
  • 5
  • 27
  • 32
7
votes
2 answers

Unable to restore SQL Server database - 'The file or filegroup cannot be selected for this operation.'

When restoring a full DB backup to a different SQL Server 2005 Express server, I receive the following message: The file or filegroup "mydatabase_log" cannot be selected for this operation. RESTORE DATABASE is terminating abnormally.…
Daniel O
  • 2,810
  • 3
  • 28
  • 35
7
votes
3 answers

automate a SQL query to run every month

I have a simple SQL query that updates some date fields in a record, on a SQL Express instance. I'd like to have it run automatically every month. What is the best way of accomplishing this in SQL Server 2005 Express using the Management Studio?
ItsPronounced
  • 5,475
  • 13
  • 47
  • 86
7
votes
2 answers

SQL Server Express 2008 using (local) in connection string

Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having…
Jeff Treuting
  • 13,910
  • 8
  • 36
  • 47
7
votes
2 answers

Can I deploy SQL Server Express with my desktop application just like builtin database?

Can I deploy SQL Server Express with my desktop application just like builtin database? Because I don't want my client to set up separately SQL Server Express! Is it easy to integrate SQL Server Express into my desktop application ?
MemoryLeak
  • 7,322
  • 23
  • 90
  • 133
7
votes
2 answers

Execute stored procedure from a Trigger after a time delay

I want to call stored procedure from a trigger, how to execute that stored procedure after x minutes? I'm looking for something other than WAITFOR DELAY thanks
Mohammed Rabee
  • 345
  • 2
  • 8
  • 23
6
votes
3 answers

"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?

I've been struggling for some time now to be able to use the built-in functions in Visual Studio 2008 to handle *.mdf database files with SQL Server 2008 Express. I'm running on an x64-based system, and I've read that there is a known problem with…
Tomas Aschan
  • 58,548
  • 56
  • 243
  • 402
6
votes
1 answer

Proper way to make a connection and query to a SQL Server Express database

I need a sample C# (console application) code witch connects to an SQL Server Express database and inserts a few variables into a table "laptops" SQL Server Express is @ localhost user name is database and password is testdatabase What is the…
Axxess
  • 522
  • 2
  • 7
  • 19
6
votes
1 answer

Logon failed for login due to trigger execution

I try to add the "mdf" database file to the project, I get an error. How to fix the error? Error: The attempt to connect to the database failed; the following information was received: Logon failed for login HOME-PC\Root' due to…
klimst6987
  • 61
  • 4
6
votes
4 answers

Switching from using SQL Server Express to SQL Server Compact

So far I have been using SQL Server Express on my desktop application even though usually the server is only used by that single application, by the single user, on the same single machine. This always seemed a bit silly to me since the full-on…
bobblez
  • 1,340
  • 20
  • 35
6
votes
3 answers

The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229)

I have installed SQL Server 2016 Express edition and also installed SSMS 18.4, now I am having an issue while restarting the SQL Server Agent service. I am able to login with my system user, but not able to login with the default user name like:…
Mahesh S
  • 373
  • 1
  • 3
  • 19
6
votes
3 answers

Visio 2010 DataSources not showing in reverse engineer wizard

Hi I am trying to do a database diagram in visio 2010 to existing database. I am using the reverse engineer wizard. When I push new button on datasource field. I follow the steps to add new datasource. It looks like everything worked no errors,…
user707261
  • 61
  • 1
  • 2
6
votes
4 answers

Error when start an instance of SQLLOCQLDB 2017 on windows 7 64bit (entry point not found except)

I tried to start an instance of SQLLOCALDB 2017 on win7 (x64) but this message box Appears : "The procedure entry point BCryptKeyDerivation could not be located in the dynamic link library bcrypt.dll" Anybody knows it's reason? more info from…
hashem nourollahi
  • 61
  • 1
  • 4
1 2 3
…
99 100