Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
1
vote
1 answer

How to enable multiple buttons based on sql db data in a cell

My project is coming along nicely thanks in part to all of your help! I have come across another bump in the road. I need to enable (up to 8) buttons based on whether or not a cell in a sql db has a 'y', 'n' or is null. I can get it to work for one…
user3288293
1
vote
2 answers

Granting sql server database access to IIS APPPOOL\DefaultAppPool

I have an ASP NET APP that's trying to access a sql server database, when I run it, I get an error saying "Login Failed for user IIS APPPOOL\DefaultAppPool" Searching the web I found that I should grant access to this user, so I executed the…
Rafael
  • 2,413
  • 4
  • 32
  • 54
1
vote
1 answer

SQL Server 2012: Return multiple strings within a single column for a common row ID

I'm using SQL Server 2012 Express (T-SQL) and I have this table (AwardsPlayers) with the following data in it. My database does not support MySQL. I've looked here and here but I still can't get it right. If I create a function, will that work in a…
Paul
  • 545
  • 8
  • 14
1
vote
1 answer

Why is FORMAT function not recognised?

I have executed the following query: SELECT productid, FORMAT(productid, 'd10') AS str_productid FROM Production.Products; I it is sayng that 'FORMAT' is not a recognized built-in function name. I am using the TSQL2012 database and Microsoft SQL…
thedarkside ofthemoon
  • 2,251
  • 6
  • 31
  • 48
1
vote
2 answers

Error: 1105 in sql server

I'm using SOL server 2012 as database server. Right now mdf file size is around 10 GB. When ever I'm doing any transaction into this database sql server troughs bellow error Error Number : 1105 Error Message :Could not allocate space for object …
Ashish Rathore
  • 2,546
  • 9
  • 55
  • 91
1
vote
1 answer

SQL Server 2012 - Two Table query

Using SQL Server 2012 Express I have two tables, groupsmembers1 and groupsmembers2. Both tables contain four columns: groupname, membername, memberaddress, ID. The tables are populated with group and member data from AD (1) and Domino (2). The…
choppie
  • 13
  • 3
1
vote
2 answers

VisualStudio 2013 persisting to mystery db during project run

Environment: Windows 8.1 Visual Studio 2013 Project type: ASP.NET MVC Debugging in IIS Express. DotNet: 4.5 Database: SQLExpress 2012 EntityFramework 5 When I run my solution (F5), in Debug or Release configuration, I can manipulate data through…
BlinkyBill
  • 397
  • 2
  • 12
1
vote
1 answer

Inserting DateTime into datetime field TSQL

I'm trying to call a stored procedure in SQL Server 2012 Express from a C# program, to insert a DateTime data type into a column (which is also datetime). For some reason, I keep getting errors about "Conversation failed when converting date and/or…
rdem
  • 195
  • 1
  • 2
  • 12
1
vote
1 answer

Will Apache camel be used between SQL server and Activemq?

Working of Application Currently: I have written a trigger for a table in SQL server to trigger a external java application(which is in tomcat server) through http request whenever there is insertion in that table. I used xp_cmdshell inside trigger…
niren
  • 2,693
  • 8
  • 34
  • 58
1
vote
2 answers

How can I merge these 2 queries together?

I've written a query to lookup column metadata based on a database (Tracker) and table (Work): SELECT Cols.Name, TYPE_NAME(Cols.user_type_id) Type, CAST(ISNULL(OBJECTPROPERTY(OBJECT_ID(Keys.CONSTRAINT_NAME),…
Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
1
vote
0 answers

Need exact Table/Column for each field returned by a select

In a database application I'll be executing a few SQL queries. But I also need some metadata from the query or the result. What I basically need is to know exactly where each field came from (Table and Column). The Algebrized Tree contains much…
Jacques
  • 41
  • 5
1
vote
1 answer

Split String With Position ID

I am currently doing some research on data mining and my research data table are looks following ID Author 1 Ali,Ahmad,David,Kumar 2 Aslam,Abid,John Now i want to split comma separated name of authors into multiple rows with the…
user2433263
  • 11
  • 3
1
vote
1 answer

Calling one sp from another

On this link http://gallery.technet.microsoft.com/Compare-Data-0c5bfc87#content we can find a stored procedure example which can compare two tables data. WHat I would like is to call this sp for each table in database. I have found next sp that will…
Goran
  • 6,328
  • 6
  • 41
  • 86
1
vote
1 answer

IN operator not finding matches

I am not able to select values with IN clause using single quotes. The pid column is varchar(50). select * from t_tra_main where pid in (200000002,300000394,200000004, 200000001,300000378,300000393,300000379,200000003) select * from t_tra_main…
Nitin Kabra
  • 3,146
  • 10
  • 43
  • 62
1
vote
3 answers

Allow remote connection only for specific users

I just enabled remote connections on my SQL Server Express 2012 installation. Now I am a little bit worried about the server security because allowing connections to everybody sounds like a big security hole for me. Is it possible to tell the SQL…
Danielku15
  • 1,490
  • 1
  • 13
  • 29
1 2 3
…
26 27