Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 746
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
0
votes
0
answers
2
views
Evict node from SQL Server 2016 AlwaysOn
I have 3 nodes cluster on Windows Server 2016 with SQL Server 2016 installed with AlwaysOn.
I would like to remove 1 nodes from the cluster.
What is the correct way to perform it ?
Is there a risk of …
- 1,106
0
votes
0
answers
36
views
SQL - AD Security Group name changing in AD, effects?
I have been granting the permissions within SQL Server to an AD Group(Server-Level). If I change an AD security group name from "companyA_SQL_Server_DBA_Users" to "companyB_SQL_Server_DBA_Users". Wil …
- 1,106
0
votes
0
answers
34
views
Security Updates for Microsoft SQL Server OLE DB Driver
Actually I have silly question. If I install below update during working hours then is it occurring any interrupt ? Also I have checked release notes. But I couldn't find anything.
Security Updates fo …
- 1,106
0
votes
2
answers
2k
views
Migrating from old AlwaysOn Availability Group to new AG cluster but keep ip addresses
We want to migrate our SQL Server 2012 on server 2012R2 to SQL Server 2019 on server 2016 and keep the ip addresses but change hostnames.
i can not change the name of listener and ip addresses from a …
- 1,106
1
vote
1
answer
1k
views
SQL Server 2017 AlwaysOn Failover Cluster issue
I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2.
there is no any running backup (SNAPSHOT)
PROD : 10.1 …
- 1,106
0
votes
1
answer
2k
views
Intermittently failover of my SQL Server resources on Windows Server 2016
I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2016.
Basically everything is pointing …
- 1,106
1
vote
2
answers
13k
views
SQL Server 2019 Always On - Ensure that cluster name object (CNO) is granted permissions to ...
I have here a SQL Server 2019 Always On with a lot of errors like this one:
2 nodes configured in a cluster with file share witness.
Cluster name: SQLCLS
Listener name: SQLLSN
Event:
Cluster network …
- 1,106
0
votes
2
answers
583
views
Schedule suggestion and index rebuild / database integrity progress for Ola Hallengren’s Mai...
I have to configure Ola Hallengren's Maintenance Scripts for my SQL Server 2017. SQL Database size about total 400GB.Total 10 Dbs. But I have some questions.
1- I will use these schedules like below. …
- 1,106
1
vote
3
answers
25k
views
SQL Server - Login failed. The login is from an untrusted domain and cannot be used with Win... [duplicate]
I am getting below error while trying to connect SQL from remote server. Local login is working fine. Can anyone help on this. Thanks in advance.
"Login failed. The login is from an untrusted domain a …
- 1,106
0
votes
2
answers
13k
views
Hide column if any value is null or zero via proc sql or view [closed]
Given either of the two following datasets
Kağıt Cinsi Sarı Yeşil Mavi
Kalın 4 0 5
İnce null 0 3
or
Kağıt Cinsi …
- 1,106
3
votes
3
answers
81
views
Listing Non-Record
I have two tables.
1st table:
called kimlik
id ad
---------------
1 ahmet
2 mehmet
3 ali
2nd table:
called siparis
id kimlikid tarih …
- 1,106
2
votes
1
answer
113
views
Full Text Search in SQL 2008
When I attempt to search in the full-text catalog which is my created earlier, I haven't been finding any word within database.
For example:
My word: Where
CONTAINSTABLE(TABLO,*,' "*Where*" ')
H …
- 1,106
2
votes
1
answer
15k
views
SQL query to convert columns into rows
I have a table as shown below.My question is:How can I convert columns into rows?BTW,I'm using Microsoft SQL Server 2005.
my input Data
ONAY_ID sip_RECno KULLANICI ONAY
1 1 …
- 1,106
0
votes
1
answer
264
views
Grouping stock in 6 month ranges
I have been pulling the total stock within the first 6 months. How can I pull the total stock within the last 6 months in the same query?
Also I want the result of the query as shown below:
Stock …
- 1,106
20
votes
7
answers
118k
views
How to drop multiple tables with common prefix in one query?
I'm using Microsoft SQL Server 2008.My question is:How to drop multiple tables with common prefix in one query?
something like that table names:
LG_001_01_STLINE,
LG_001_02_STFICHE
- 1,106