sql-server-2012 Questions
3
Solved
Trying to create a "read only" intent connection string against SQL Server 2012 high availability Group, following this article, I am getting:
System.ArgumentException: Keyword not supported: 'a...
Wayzgoose asked 17/1, 2014 at 16:5
2
Im am trying to hit the secondary node on a sql server 2012 DB using "ApplicationIntent=readonly" in the connection string.
It is still hitting the primary node, not sure why.
I'm using s...
Shem asked 13/7, 2016 at 15:54
3
Solved
I want to add Isolation level in my procedure and for that I wanted to confirm that which one is the correct format from below:
Attempt #1 - setting isolation level before calling the stored proce...
Illgotten asked 21/2, 2017 at 6:31
2
Solved
I have a table which has one field that uses a filestream. When I attempt to insert the table I get this error
Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarcha...
Kumar asked 5/9, 2014 at 10:53
5
I have been trying to install and start SQL Server 2012. I succeeded installing SQL Server 2012 Management Studio but I am still working to start its service.
When I tried to start it I got an erro...
Virtually asked 29/3, 2015 at 18:36
4
Solved
I am trying to connect Sql Server Data Base using windows authentication from my application using JTDS driver but i got following error
SSO Failed: Native SSPI library not
loaded. Check the ja...
Immunoreaction asked 15/6, 2011 at 10:55
6
Solved
I need to create a SQL script to determine if a sequence exists in a SQL Server 2012 database. I am familiar with process for determine if a stored procedure exist but not sequence. Thank you.
Mold asked 26/9, 2013 at 18:30
1
Solved
I'm trying to set SQLCmd variables based on configuration (Debug / Release, etc) but the Configuration dropdown is greyed out (see image below). For Dev environment, I want the SQLCmd variable to b...
Shastashastra asked 9/10, 2014 at 16:14
4
There's no shortage of topics covering this function and error "An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes". I've checked most of the...
Warner asked 16/7, 2014 at 10:59
9
I get the following error while trying to create a clustered index
The statement has been terminated.
Msg 596, Level 21, State 1, Line 0
Cannot continue the execution because the session is i...
Key asked 6/11, 2016 at 13:42
6
Solved
Does anyone happen to have a generic SQL statement that'll list all of the tables and indexes in a database, along with their current compression setting, for each partition?
Thanks.
EDIT: This i...
Ratchford asked 7/6, 2013 at 15:59
3
Solved
How can I export my 2012 database with data to a .sql file so I can import it to a 2008 server? I've never been able to export the data only the structure.
Shaeffer asked 21/8, 2013 at 10:53
23
Solved
I've got this error:
A connection was successfully established with the server, but then an error occurred
during the login process. (provider: Shared Memory Provider, error: 0 - No process is
on ...
Talesman asked 3/12, 2014 at 9:14
7
Solved
I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component:
===================================
Method not found: 'Void Microsoft.Da...
Heterodyne asked 15/3, 2016 at 11:16
4
Solved
I want to get the current value from my sequence - the same value that is shown in the sequence properties window SQL Server Management Studio
My sequence is created with this statement:
CREATE...
Euonymus asked 4/12, 2012 at 12:4
33
Solved
I need to add a specific column if it does not exist. I have something like the following, but it always returns false:
IF EXISTS(SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'myT...
Haupt asked 25/9, 2008 at 12:34
4
Solved
I use Visual Studio 2013 Professional Update 4 in combination with multiple SQL Server 2012 Enterprise servers/instances. The Idea was to create a Version controlled deployment using a Visual Studi...
Osmose asked 26/3, 2015 at 11:33
5
Solved
I have to fetch data from a @temp table which has something like "or ccc or bbb or aaa" I want to replace the first occurrence into space to get something like this " ccc or bbb or aaa". I am tryin...
Reareace asked 12/8, 2016 at 6:47
9
Solved
I want to make use SQL Server sequence objects in Entity Framework to show number sequence before save it into database.
In current scenario I'm doing something related by increment by one in sto...
Yettie asked 22/11, 2014 at 12:38
20
Solved
Working with my project in debug I have no issues. However running it in IIS I am getting this error:
System.Data.SqlClient.SqlException: Login failed for user 'domain\name-PC$'.
Stack Trace
[Sq...
Bourne asked 14/3, 2014 at 20:39
8
Solved
I am running SQL Server 2012 Enterprise Edition. I have downloaded the AdventureWorks 2012 OLTP data files (both .mdf and .ldf). I saved them to the AW folder that I created in My Documents where I...
Quickman asked 9/3, 2013 at 8:15
8
Solved
I'm working with Sql server 2008.i have a table contains following columns,
Id,
Name,
Date
this table contains more than one record for same id.i want to get distinct id having maximum date.h...
Bonesetter asked 28/4, 2014 at 8:56
4
I run into the classic Parameter Sniffing issues in SQL Server 2012. Based on some research I found multiple options around this problem. The two options that I need to understand the difference be...
Bagwell asked 4/11, 2016 at 22:54
2
I open my SSMS and right click on DB and then Tasks -> IMport Data to import data from a source but as soon as I click I get this error:
Failed to find or load the registered .Net Framework Dat...
Mordancy asked 8/6, 2017 at 14:40
4
I couldn't see the results in grid pane, so I did the following:
Tools > Options > Query Results > Results to Grid
> uncheck the "Discard results after execution" check box
But st...
Modeling asked 11/8, 2018 at 14:46
1 Next >
© 2022 - 2024 — McMap. All rights reserved.