Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.
1
vote
0answers
10 views
SQL 2012 Error 3154 while restoring a DB backup in SQL 2012 even if “With replace” is checked [migrated]
I have SQL 2012 with SP1 installed on my computer. I made a backup of a database "test.bak"
I have a database with the name "test2" wich is the same database, but the data changed.
I want to restore ...
0
votes
2answers
30 views
SQL Server 2012 join perfomance features?
Consider a simple 3 table database i SQL Server 2012.
Table A
AId
Name
Other1
Other2
Table B
BId
Name
Table A_B
BId
AId
Simple example query:
SELECT TOP(20) A.Aid, A.Name, ...
0
votes
0answers
12 views
Replication between SQL Servers resides in Windows Azure Virtual Machine
Hello I am facing one issue during snapshot replication between SQl servers reside in Windows Azure Virtual Machine.
I had 2 VM with below configuration
1) Windows server 2012 (Installed sql server ...
azure
0
votes
0answers
11 views
SSRS 2012 - Custom Authentication - The permissions granted to user " are insufficient for performing this operation
I am a newcomer to SSRS in general, so please bare with me.
Whenever I want to deploy a report in Visual Studio I receive the error message "The permissons grated to user " are insufficient for ...
0
votes
1answer
22 views
Enable identity insert ignored using SQL Server Import?
I'm trying to move a database from a remote server at a web hosting company (meaning I have no control of the server) to my new own server running SQL Server Express 2012. To do this, I am using SQL ...
0
votes
0answers
21 views
Parsing the string value that represents the field image from sql server 2012 with Java
I have a .sql generated from sql server 2012 from a table that has a field image.
I need when I read the .sql and find the field that represents the image perform a parser in the string value to ...
0
votes
0answers
6 views
How to synchronize(update, insert) static(reference/setlist) tables from one databse to another one?
I need to find algorithms to update static(set-list, reference) tables from one database to the other one.
I have a -called- Big database and a Small database. Small DB has same schema and tables, ...
0
votes
1answer
8 views
FluentNHibernate SchemaUpdate isn't working
I have a problem updating the database schema using SchemaUpdate method of FluentNHibernate.
Here's my code:
Fluently.Configure()
.Database(MsSqlConfiguration
.MsSql2012.ShowSql()
...
1
vote
1answer
19 views
Sql query with date comparison in Sql Server 2012
I want to fetch all records from table which are 15 days old. I have found a solution in MySql:
select *
from dt_tb
where dt >= DATE_SUB(CURDATE(), INTERVAL 15 DAY);
What its equivalent in ...
1
vote
0answers
32 views
Unable to use SSIS's SSDT in VS2010 / SQL Server2012
I have a full version of SqlServer 2012 installed on my local machine and have installed SSDT from the installation package (and updates)
I've then opened the SSDT visual studio application and ...
0
votes
1answer
26 views
Multi-field search for all rows containing specific string
Say I have the following table:
CREATE TABLE #Pig
(
PigName VARCHAR(10),
Field1 VARCHAR(10),
Field2 VARCHAR(10),
Field3 VARCHAR(10),
Field4 VARCHAR(10),
Field5 VARCHAR(10),
Field6 VARCHAR(10),
Field7 ...
0
votes
0answers
25 views
Retrieving multiple summaries
In this scenario there are four tables: TableA, TableB and TableC, TableD and TableE
TableA -> TableB = 1-to-many
TableB -> TableC = 1-to-many
TableB -> TableD = 1-to-1
TableC -> TableE = ...
0
votes
0answers
17 views
Populating data from database(MS SqlServer) (using Entity Framework 5)to JqGrid using ASP.NET MVC3
I am new to JqGrid and MVC 3 but I have a new requirement to populate data from MS Sql Server using Entity Framework 5 and ASP.Net MVC3 to JqGrid without using any third party plugin(e.g Trirand ...
0
votes
1answer
9 views
Can I use SQL Server-2012 Express edition over a network when the FIREWALL is on
I have enabled the TCP/IP, Named Pipe protocals and I have started the SQL Server web browser also. Still not able to connect to SQL Server2012 Express edition from some other system apart from my own ...
0
votes
1answer
20 views
How to convert minutes into HH:MM:SS formate in sql server
I am having a column in my sql server database table with datatype bigint.
Now i need to convert this column into HH:MM:SS formate.
For this i use this command
SELECT ...
