for SQL Server 2012, major build version 11.00.xxxx. Released April 1, 2012 with a projected end-of-life date of 7/12/2022.
0
votes
1answer
32 views
Error creating database in SQL Server Management Studio
I'm trying to create a new database in SSMS, but I get this error:
Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or ...
-3
votes
0answers
36 views
I am getting error messages anytime I try to insert data in to SQL Server 2012 [on hold]
Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Address_ArtistAddress". The conflict occurred in database "MusicMania", table ...
5
votes
1answer
319 views
What is the fastest way to insert large numbers of rows?
I have a database where I load files into a staging table, from this staging table i have 1-2 joins to resolve some foreign keys and then insert this rows into the final table (which has one partition ...
-1
votes
0answers
39 views
SQL Server 2012 installation error - wizard closes abruptly [on hold]
I need to install Microsoft SQL Server 2012 Adv. I have checked my requirement and updates. Everything seems to be fine. However when I run to install the file, at the middle of installation suddenly ...
2
votes
1answer
30 views
SQL Profiler - Insert values?
I setup an SQL profiler to run, but I am not seeing any values for updates/inserts. Is there a way to see them?
All I see is stuff like this:
insert into some_tbl(id, col1, col2, col3) values ( @P0 ...
5
votes
2answers
185 views
Does the Sql Server Agent account need sysadmin permission?
I ran Brent Ozar's sp_blitz script, and one of the things it's complaining about is that my SQL Server Agent account has sysadmin permission. I removed the sysadmin permission, but then the agent ...
1
vote
0answers
40 views
SQL Server 2012 - Large backup file size
We have the following setup:
Once a week (Sunday at midnight), a full database backup is performed. A new BAK file is created for this purpose, let's call it Backup1.bak.
From then, a transactional ...
3
votes
1answer
34 views
With SQL transactional replication, does changing user permissions to a table trigger a new snapshot?
I was hoping to get some help with a SQL Server 2012 transactional replication scenario - or maybe just my understanding of where permissions are stored in SQL server. If I change a users permissions ...
0
votes
0answers
20 views
SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber
In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers
For 2nd subscriber every table data is updating properly
But for 1st ...
20
votes
2answers
749 views
Why does query error with empty result set in SQL Server 2012?
When running the following queries in MS SQL Server 2012 the second query fails but not the first. Also, when run without the where clauses both queries will fail. I am at a loss why either would fail ...
0
votes
0answers
35 views
Looking for package with stored procedures for drop, create, disable, enable operations [closed]
I become tired to write stored procedures for mass drop, create operations, e.g drop all from table, schema, drop with scripting and follow recreation, etc. Even enable/disable all triggers on table ...
2
votes
1answer
48 views
How to allow connections to SQL Server with 2 differents ip
I have a small issue here: I have a SQL Server instance 2012 (let's call it INSTANCE) on a cluster. I also have 2 network interfaces for this instance:
SQLINSTANCE.my.metwork
...
0
votes
0answers
54 views
Map multiple external-id to single internal DB-id
I have been tasked to add a new functionallity to a application and I'm not really sure how the best way to go about this would be...
Basically there is a application that receives messages with some ...
2
votes
2answers
55 views
SQL Agent - PowerShell step “syntax error”
I have the following code setup in SQL Agent Job step that is not running. The message received is simply:
Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed.
...
2
votes
1answer
60 views
Speed of Searching Text vs INT/BIGINT - SQL Server 2012
I am building an application that will need to handle extremely high amounts of traffic. The traffic will consist of incoming requests for information from a SQL Server 2012 database. When a request ...
0
votes
1answer
30 views
Can SQL Agent job notifications be sent to one operator for success and another for failure?
We have a requirement that some people are sent notification on success, and other on failure.
But the UI seems to only allow a combination of 1 operator + 1 condition.
So I was wondering if we ...
1
vote
2answers
38 views
Dropped the Distibution database before disabling publishing and distribution, how to proceed?
I'm setting up my first Distributor database on SQL Server 2012. I successfully created one and then wanted to blow it away and perform the task again just for practice.
This was a brand new ...
1
vote
1answer
38 views
CDC not picking up changes [on hold]
CDC has been set up for one of our databases in our test environment but it's not capturing any of the changes. I've made sure the capture job is running. I've disabled CDCs for the database, enabled ...
0
votes
0answers
25 views
Generating dynamic table CREATE and iterative INSERT INTO script in TSQL?
I'm starting to create a dimensional database for BISM development using tables and views from a relational database on the same SQL instance. I've been looking for a way to dynamically generate ...
2
votes
1answer
67 views
How can I use running total aggregates in a query to output financial accumulations?
I am attempting to write a query that will be consumed by a SSRS 2012 report. Given a paid invoice, with a certain set of account allocations towards which the money paid towards it must be saved, I ...
0
votes
0answers
33 views
Linked Server for MultiSubnet AG Listener
How do I create a linked server for an AG Listener that is in a multi-subnet configuration? I have a couple clusters that need to be able to query the listener at hand but the node that is on the ...
5
votes
1answer
111 views
How to avoid a race condition with cross db proc calls? and other concerns
I am not even sure this question is necessary but I am curious to know everyone's thoughts. I have two databases on the same server, dbFoo, dbBar. dbFoo has the following table please note this is a ...
1
vote
1answer
33 views
automatic transactional replication failover to noce2 with AG failover
I am working on to set up high availability group like
SQL01,SQL02,SQL03(DR) and SQLRPT01 as the reporting server which has our reporting DB.
* From SQL01 to RPT01, I am running transnational ...
1
vote
2answers
63 views
AlwaysOn Availability Groups Delayed Replica
With AO SQL 2012, is it possible to configure one of the member as delayed replica? I know ideally we would like this to be synced but in case of human error, it would give us the ability to check on ...
3
votes
1answer
116 views
Why is SQL Server 2012 working set memory low?
I have recently migrated a 100gb database for a busy website from:
MS SQL 2008 Standard Edition R2
Windows Server 2008
48gb RAM
to
MS SQL 2012 Web Edition
Windows Server 2012
64gb RAM
I have ...
1
vote
1answer
40 views
User defined table type with a check constraint
I have a user defined table type where I want to make sure that a certain column is within a given range. This range however is defined in another table. So I thought I can use a check constraint on ...
2
votes
2answers
36 views
Should I pause Mirroring and stop SQL Server services before running windows updates?
I am running Windows update on my SQL Servers (which are in a Principal-Mirror partnership, in High Safety mode).
I am starting with updating the mirror and I was wondering, to increase safety, ...
4
votes
0answers
66 views
Rebuild Index Task removed WHERE clause from filtered index [closed]
I have a filter index setup on a table as follows:
CREATE UNIQUE NONCLUSTERED INDEX [IX_TableName_Column_Filtered] ON [Schema].[TableName]
(
[Column] ASC
)
WHERE ([Column] IS NOT NULL)
WITH ...
1
vote
2answers
69 views
Upgrading to SQL Server 2012 from SQL Server 2008
I have upgraded my SQL Server 2008 R2 Enterprise edition to SQL Server 2012. Even after upgrade I can see & use SQL Server 2008 R2 instance without any issue. Did my upgrade went fine?
I can ...
2
votes
1answer
74 views
Issue while upgrading SQL Server 2012
When I tried to upgrade SQL Server 2008 R2 to SQL Server 2012 everything went well except below issue
How do I fix it? Do I need to uninstall SQL Server 2012 again?
EDIT
Feature: ...
0
votes
0answers
33 views
SQL Server Mirroring send/receive ack time not normal
I have a problem that arises during the performance test by microsoft team in my client.
The report that is given to us provide information about whether or not a parameter is good based on the Object ...
1
vote
0answers
43 views
SQL Maintenance Plan 'Could not find part of the path' - where is it getting the path from?
I have a SQL Server 2012 maintenance plan which backs up all of the databases. Today I had an issue with a failed backup which I was able to resolve by viewing the detail in the 'Log File Viewer' ...
1
vote
1answer
40 views
db_owner unable to drop database - Error 615, SQL Server
I have a SQL Server 2012 database running on amazon EC2. I've created a user to be able to create, edit and drop databases. I gave the new user with dbcreator server role.
My user can connect ...
0
votes
0answers
42 views
How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0? [duplicate]
I have SQL Server 2012 with version 11.0.3000.0 .
I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
0
votes
2answers
148 views
How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0?
I have SQL Server 2012 with version 11.0.3000.0 .
I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
4
votes
1answer
78 views
Query the Differential Changed Maps in SQL Server
Differential backups use the Differential Changed Map pages to determine what pages to backup. I'd like to investigate a backup strategy involving differential backups. For that purpose I'd like to ...
2
votes
1answer
16 views
“No row was updated error” in SQL 2012 - worked fine in SQL 2005 and 2008
I have a database that currently lives in SQL Server 2005. We are currently looking at upgrading to SQL 2012.
I installed 2012 in a test environment (Windows Server 2012 virtual machine). Backed ...
0
votes
2answers
51 views
Create database fails with Microsoft SQL Server Error 5133, Operating syste, error 5 (Access is denied)
I just installed SQL server 2012 on Windows 2012 today. After the install, I changed the database settings to create database files in f:\mssql instead of the default. i verified the confired and ...
3
votes
0answers
59 views
SQL Server 2012 Error when creating Selective XML Index on XML Query Plan
I'm trying to create a database solution that will enable me to optimise high CPU/IO/Duration queries to improve overall performance of the database.
Part of the optimisation requires persisting ...
0
votes
0answers
29 views
Ways to monitor Replication messages in SQL Server 2012
I have a question for the Replication gurus here. Replication is a massive evil (but absolutely necessary) in my company. What are the various ways to monitor replication performance. I know viewing ...
2
votes
3answers
63 views
Replicating tables for reporting purpose
We have 5 tables in a database on Server A that we would like to replicate to Server B for reporting purposes. We would like to create different indexes on the destination copy so we can get better ...
2
votes
0answers
92 views
Why are queries causing spill to tempdb?
Background
I am in the process of migrating a 160gb database from MSSQL 2008 (standard) on a Win 2008 server with 48gb RAM to a new server running MSSQL 2012 (64-bit web edition) on Win 2012 with ...
1
vote
1answer
33 views
Different results from sys.dm_db_file_space_usage with database prefix
To make it simple:
According to MSDN (link) among other sources, you can get the amount of current free space in tempdb by using the following bit of TSQL:
-- MSDN version
SELECT ...
1
vote
1answer
48 views
System table missing in SQL Server 2012
I restored a SQL Server 2000 database to 2005 then to 2012. I am not able to see system tables that existed in SQL Server 2000 now.
Can somebody please let me know what is the reason.
Thank you
1
vote
1answer
58 views
Does MAXDOP affect the number of tempdb data files I should create?
From what I have read, best practices for configuring tempdb includes creating multiple data files. The rule of thumb as I understand it is if you should create the same number of data files as you ...
0
votes
0answers
20 views
How can I convert Multidimensional Database to Tabular Model In SSAS
I use SSAS in SQL Server 2008 R2 and I Migrate to SQL Server 2012 SP1
I has Multidimensional Database Model In SQL Server 2008 R2 but now I have Tabular Model.
I have 8 Multidimensional Database in ...
0
votes
0answers
5 views
How to install SQL Server 2012 Management Studio Books Online in Help Library Manager
I tried to install the SQL Server 2012 BOLs however my Help Library Manager is all greyed out except the "Choose online or local help"
1
vote
2answers
62 views
SQL Server 2012 is database name mandatory for logon?
is the database name mandatory SQL Server 2012 logon - like SERVERNAME\DBNAME ?
On 2005 Server the servername for logon with Windows credentional has been sufficient.
Thanks in advance,
Tom
0
votes
1answer
54 views
How to add an article to existing replication
This is the first time I am going to add tables to replication.
I have outlined the below steps to add a new table to existing replication. Please correct me if I am wrong. The table is just created ...
1
vote
1answer
104 views
Best Format to Bulk INSERT/UPDATE Data to SQL SERVER using C# [closed]
Can anyone tell me what is best way to bulk insert/update data to SQL SERVER 2012 using C#? I have an excel file which I am passing as TVP(table value parameter) to a SP. But this is little bit ...
