sql-server-2012-express Questions
6
Connect to LocalDB in SSMS
Open Server Properties -> Database Settings
Change Data/Log/Backup locations -> click OK
When I click OK I get this error:
Found some blogpost and changed this in r...
Sedda asked 8/12, 2012 at 13:47
5
I'm trying to set up a SQL Server 2012 LocalDB (RTM, x64) shared instance on my Windows 7 x64 machine and I can't seem to connect to the shared instance. I'm using an Administrator command prompt f...
Icebound asked 18/4, 2012 at 17:28
14
Solved
I just downloaded the latest version of SQL Express 2012 but I cannot connect to localhost. I tried localhost\SQLExpress and Windows authentication but it gives me an error message saying cannot co...
Philander asked 8/10, 2012 at 3:7
17
Solved
I just installed SQL Server Express 2012 on my home server. I'm trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error:
A network-related...
Vanitavanity asked 30/6, 2012 at 22:21
7
Solved
I'm trying to give an ASP NET App access to a database (These are test only not production).
It's the first time I try it in this network, and I haven't done it with VS2012, SQL Server 2012 Expres...
Shibboleth asked 14/2, 2014 at 14:40
3
Solved
I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox...
Inanna asked 8/4, 2013 at 21:19
6
Solved
I recently installed Visual Studio 2010 and SQL Server 2012 on a Windows Server 2008 R2 machine - (including all updates/Service Packs).
When attempting to work on a SQL Server database from withi...
Chicalote asked 23/4, 2012 at 17:53
3
Solved
I would like to be able to search every word so I have cleared the stop word list. Than I have rebuilt the index. But unfortunately if I type in a search expression with stop word in it it still re...
Millrun asked 6/10, 2012 at 10:40
3
Solved
I'm trying to create a database on my local machine using SSMS version 11.0.2100.60. I've run the application as administrator, logged in using Windows authentication, and I've added MYDOMAIN\my-us...
Tetherball asked 22/7, 2013 at 13:27
6
Solved
Okay, I'm confused. My SQL Server JAR is here:
Volume in drive C has no label.
Volume Serial Number is 8008-2D93
Directory of c:\temp
03/07/2014 09:38 AM <DIR> .
03/07/2014 09:38 AM <...
Suzysuzzy asked 7/3, 2014 at 15:1
2
Solved
Is it possible for a column in to be auto-calculated by SQL Server 2012 itself?
For example: I have three columns START_DATE, END_DATE and DURATION.
I want to get the duration by doing this :
DU...
Lubet asked 14/4, 2013 at 12:2
3
Solved
I am dealing with hibernate and as I opened my current project I figured out my Session-Factory is deprecated:
AnnotationConfiguration af = new AnnotationConfiguration();
SessionFactory factory = ...
Calan asked 28/7, 2013 at 18:17
2
Solved
Getting error "commandtext property has not been initialized" when sql compare of Red Gate
When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized"
I am using the SQL server 2012 express and R...
Dogtooth asked 13/6, 2013 at 10:13
1
I've installed SQL Server 2012, after I've installed all features including report services. I go to Report Manager link and wanted to add New Data Source, but in Data Source Types there is only Mi...
Undergird asked 23/6, 2015 at 13:41
3
Solved
I create about 15 tables and create relationships and constraints among them using Wizard in SQL Server 2012 express
Now i want to see the query that is used to create those tables including relat...
Loony asked 4/4, 2015 at 3:47
4
Solved
i have the SQL code to generate the date list between two dates, but i want to generate the week days (Business days) from the given two dates,
DECLARE @MinDate DATE = '20140101', @MaxDate DATE = ...
Nullity asked 11/3, 2015 at 11:12
1
Solved
I am trying to backup a database I have created in SQL Server 2012 Express. I right click the database -> tasks -> backup and assume normal defaults.
The error I get is then this:
TITLE: Microsof...
Feature asked 18/6, 2014 at 12:8
2
Solved
Can someone please guide me on how to overcome the following error. I am trying to install SQL Server 2012 Express on my win7 32bit system. I had SQL Server 2008 R2 32 bit installed in this system,...
Playroom asked 12/7, 2013 at 10:42
1
Solved
I have a connection to a MS SQL Server 2012 database in classic ASP (VBScript). This is my connection string:
Provider=SQL Server Native Client 11.0;Server=localhost;
Database=databank;Uid=myuser;...
Washedup asked 18/3, 2014 at 21:19
2
Solved
I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here.
So I would like to know what is the difference b...
Sickler asked 23/6, 2012 at 14:20
2
Solved
I have this code:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetProfitDealsVar2]
GO
IF EXISTS(SEL...
Whelm asked 9/10, 2013 at 11:25
3
Solved
I just run this query
Select *
from ProjectData
where logtime between '2012-09-25 12:00:00.000' and '2012-09-25 12:59:59.999'
order by LogTime
in an attempt to find the all record for 12 hou...
Ivanaivanah asked 7/8, 2013 at 5:11
4
Solved
I have a database table (running on SQL Server 2012 Express) that contains ~ 60,000 rows.
I am using the following code to purge old rows:
//Deleting CPU measurements older than (oldestAllowedTim...
Amorist asked 8/5, 2013 at 13:41
1
Solved
I'm developing SQL script, using SSMS, which makes some changes in database:
USE MyDatabase;
BEGIN TRANSACTION;
-- some statements
PRINT(N'#1');
IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.CO...
Parcenary asked 23/4, 2013 at 9:31
2
Solved
I've never seen this happen before, very odd.
I have a local SQL Server 2012 Express database that I'm developing against. Running a simple suite of tests using the TestDrive plugin and accessing ...
Vav asked 1/12, 2012 at 7:40
1 Next >
© 2022 - 2025 — McMap. All rights reserved.