sql-server-express Questions
2
Solved
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
Messiaen asked 28/6, 2012 at 7:50
4
I believe this is a very novice question, and if I'm using the wrong forum to ask, please advise.
I have a basic understanding of databasing with MS SQL Server, and programming with C++ and C#. I'...
Gower asked 3/1, 2011 at 22:26
4
I'm trying to build a connection string for a test environment that will connect to the local SQL Server instance on different machines. The purpose of this is so that a developer can checkout the ...
Doormat asked 4/5, 2011 at 15:41
1
Solved
For a non-LocalDb SQL Server, I can SELECT SERVERPROPERTY('ServerName') to get the name of the server and the instance that I'm running on. For a LocalDb server, however, I get SERVERNAME\LOCALDB#S...
Rubinrubina asked 28/2, 2013 at 16:16
4
Solved
How can I show the number of rows in a table in a way that when a new record is added the number representing the row goes higher and when a record is deleted the number gets updated accordingly?
T...
Candelabra asked 17/2, 2013 at 18:21
2
Solved
How can I group rows if the different time between on field and other field in other row almost the same?
For example:
GUID - No - sDateTime - eDateTime - Name
--------------------------------...
Territorial asked 12/2, 2013 at 21:49
3
Solved
As per this how-to, I've successfully configured IIS on my XP-SP3 dev box for SQL Server 2008 Express to save ASP.NET session state information. I'm just using SQL Server because otherwise on every...
Rome asked 1/12, 2010 at 2:13
4
Solved
I was developing an application using Entity Framework and storing data in a .mdf database. My code can read the data, apparently it can save too, but only apparently. It get no erros, while the pr...
Halflife asked 18/5, 2009 at 2:9
1
Solved
Does anybody know if Windows RT will have some form of SQL Express available? Hoping for something C# friendly rather than C++.
Invalidism asked 16/10, 2012 at 19:21
2
Solved
I've started work on a project that requires an SQL Server Database. I will be building a front end application in c# .Net 3.5, that will use LINQ to SQL.
I need to host the database on a network ...
Additament asked 14/8, 2012 at 14:4
4
Solved
For a small sales related application, we designed database using logical data model. Come to the stage to convert in to physical model. While creating table in SQL Server Management Studio Express...
Pittsburgh asked 20/7, 2012 at 11:45
2
Solved
What benefit do I derive from installing Sql Express with Visual Studio (2010) when I already have Microsoft Sql Server Developer (2008)?
The only benefit I can imagine is that I can develop for e...
Metanephros asked 28/6, 2012 at 17:43
3
Solved
I'm wondering what the key differences between using a SQL Server Compact database (.sdf) and a full fledged database like for example SQL Server Express are?
Are there any major performance issue...
Doe asked 28/6, 2012 at 10:34
2
Solved
I'm trying to use the Visual Studio 2010 Express editions to set up an ASP.NET MVC 2 Web Application using SqlExpress + Entity Framework as the data access. I have both the "C# Edition" and "Web De...
Ribald asked 26/4, 2010 at 1:27
2
Solved
I am using SQL Server Express 2008 R2 and I wanted to change the instance name from "machine name"\SQLEXPRESS2008R2 to just "machine name". I ran:
sp_dropserver 'old_name'
go
sp_addserver 'new_n...
Badalona asked 10/5, 2011 at 21:38
1
Solved
I have installed SQL Server 2012 Express Edition Advanced Services which states that it includes Full-text indexing. Here is a link that states this:
http://msdn.microsoft.com/en-us/library/cc6459...
Ass asked 2/5, 2012 at 3:31
5
Solved
I have a plain sql file with some SQL INSERT statements.
Is it possible to import it in my local SQL Server Express instance?
Sax asked 30/6, 2011 at 13:31
5
Solved
Tried this in as connection string
connectionString="Server=.\SQLEXPRESS;
AttachDbFilename=E:\Database\dnn49.mdf;Database=dnn49;
Trusted_Connection=Yes;"
but i get an error
Unable to open...
Arawak asked 20/9, 2009 at 1:31
1
Solved
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 d...
Chisel asked 19/2, 2012 at 9:35
5
Solved
I am using SQL Server 2008 express and i want to import .mdf and i get this error:
.mdf version is 661, your db supports the version 655
Which version is 661 and how to import it in sql Server 200...
Arel asked 17/3, 2010 at 14:17
3
Solved
I am deploying an application with sql server express 2008. In the prerequisites section of my application I have included:
As a result when a user installs my application it will install sql ex...
Makebelieve asked 4/2, 2012 at 2:9
1
Solved
I'm using the SQL Express 2010 query builder. I need to be able to increment a field.
In my behind code, I make a call such as
tableAdapter.IncrementLikeCount(id);
If I just use an increment, t...
Byrnes asked 3/2, 2012 at 22:42
2
I wanted to try out the fts feature of sql server 2008 express. According to the product page (http://www.microsoft.com/sqlserver/en/us/editions/express.aspx) , there should be fts included in the ...
Tull asked 18/7, 2011 at 9:32
1
Solved
I have one SQL Server Express instance with a pretty normal well formed database. I need to have the data continuously replicated to a SQL Server Express instance on another server.
Now, I know th...
Feeling asked 8/10, 2011 at 12:40
2
Solved
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 versi...
Epistyle asked 19/9, 2011 at 15:51
© 2022 - 2024 — McMap. All rights reserved.