sql-server 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
7
Solved
Trying to create Database as follows:
USE Master
GO
IF NOT EXISTS(SELECT [Name] FROM sys.databases WHERE [name] = 'QAudit')
CREATE DATABASE [QAudit] ON PRIMARY
( NAME = N'QAuditData', FILENAM...
Tenorite asked 9/9, 2009 at 4:39
3
Solved
Given an update statement like so:
UPDATE
UserAssesment
SET
AssessmentDate = comp.AssessmentDate
FROM
UserAssesment ua
INNER JOIN
vw_CompletedAssessments comp
On
ua.NatId = comp.NatId and...
Endorsement asked 5/5, 2014 at 5:27
6
Solved
I have a table similar to the one shown. It contains a list of user ids, the hour value for each hour of the day and an Avail flag to determine if that user is available on that hour.
I need to li...
Viniculture asked 5/8, 2015 at 16:10
2
I have a requirement where I need to find out whether SQL is installed with default instance or named instance.
Can someone please help me here how to find it?
Thanks in advance,
Sasikumar.
Beatrizbeattie asked 23/1, 2015 at 14:28
4
We've been using Visual Studio 2017's SQL Server Schema Comparison for all our (SQL Server 2016) migrations and deployments.
However, recently, it has become very slow, taking hours to process. If...
Minstrelsy asked 28/11, 2017 at 8:37
6
Solved
Query should output a certain list of Items, along with info like store information and manager info. Uses a Cursor to flip through list of various different levels of management, selects relevant ...
Scrapbook asked 19/6, 2014 at 18:7
4
Solved
BEGIN TRY
EXEC N'EXEC sp_testlinkedserver N''[MyLinkedServer]'';';
END TRY
BEGIN CATCH
SELECT 'LinkedServerDown' AS Result
RETURN
END CATCH
SELECT TOP(1) FirstName FROM [MyLinkedServer].TestData...
Ginsburg asked 14/10, 2015 at 16:20
3
Solved
We have a solution with three database projects. All three produced dacpacs are deployed sequentially but for some reason, one of these dacpacs does not run the post-deployment script.
We're using...
Berriman asked 7/6, 2013 at 10:12
3
Solved
I have a Webview2 Control in my application, used to view PDF documents.
The application also stores to and reads from MS SQL server PDFs data.
Currently, I am retrieving binary data from SQL, conv...
Coulter asked 5/8, 2021 at 16:8
3
Solved
Description
I'm trying out the service containers for integrated database tests in azure devops pipelines.
As per this opensourced dummy ci cd pipeline project https://dev.azure.com/funktechno/_git...
Detestable asked 22/8, 2020 at 16:24
4
I have a data call in a Linq to Entities powered data access layer that is designed to make paged calls.
In doing so, I need to select a subset of the data, say 50 rows, but also get the count of ...
Mosenthal asked 23/3, 2015 at 18:54
2
Solved
I have a sql statement (inherited) that has the following WHERE clause:
WHERE
(Users_1.SecurityLevel IN ('Accounts', 'General manager'))
AND (PurchaseOrders.Approval = 1)
AND (PurchaseOrders.Qu...
Figueroa asked 21/7, 2017 at 7:22
3
Solved
String or binary data would be truncated. The statement has been terminated.
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated
Sectional asked 1/7, 2016 at 6:3
5
I'm trying to connect to a SQL server database using pyodbc in Python 3. But I get an error when I'm trying to establish the connection.
I do something like this:
import pyodbc
conn = pyodbc.connec...
Elytron asked 23/3, 2022 at 12:28
2
Solved
I am trying to learn about Entity Framework 6, and I am running into an issue, that I have been able to reproduce in a test project:
A Movie has a Nameand a Revenue. A Revenue has a GrossIncome:
...
Denbighshire asked 7/2, 2019 at 16:49
3
Solved
It's that simple: a query that runs in just a few seconds in SQL Developer connecting to Oracle 11g takes 15-25 minutes in SSRS 2008 R2. I haven't tried other versions of SSRS. So far I'm doing all...
Serpentiform asked 25/1, 2011 at 1:3
3
Solved
I am trying to enable sqlsrv drivers for php8.1 on Ubuntu 20.0. It is not showing the extension in phpinfo().
When trying to check the sqlsrv module with commmand php -m, the output is like this:
...
Quean asked 13/11, 2022 at 15:31
3
I'm looking to populate a column in a table with a value for every hour between two dates.
Example:
01-01-2020 00:00:00 to 01-01-2026 00:00:00
should produce this result:
01-01-2020 00:00:00
01-01...
Paradisiacal asked 30/8 at 12:56
4
Solved
I am using Visual Studio 2008 and SQL Server 2008 Express.
How can I change the name of the view? I can change tables' names, but I can't change the view name.
Any suggestion?
Dyanne asked 10/9, 2009 at 0:10
4
Solved
I need to determine the available space on the drive where my database lives.
I know about the xp_fixeddrives procedure but how do I get the info for the specific drive where my database resides?
Humorist asked 11/2, 2010 at 8:27
4
Solved
When I scan my database, it shows one of the result like VA1143 'dbo' user should not be used for normal service operation in A Vulnerability Assessment scan
They have suggested to "Create users ...
Streamy asked 5/5, 2020 at 10:53
6
Solved
I have an attachments table that stores the size of the document in Bytes.
I'm needing to display a result set of all documents in either KB or MB. In KB if the document is less than 1MB or in MB ...
Rental asked 9/2, 2017 at 0:4
3
Solved
declare @minDateTime as datetime;
declare @maxDateTime as datetime;
set @minDateTime = '2014-01-13 02:00:00';
set @maxDateTime = '2014-12-31 14:00:00';
I am looking to create a select statement ...
Weft asked 27/11, 2014 at 0:59
1 Next >
© 2022 - 2024 — McMap. All rights reserved.