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 218976
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.
1
vote
2
answers
916
views
SQL Server Agent Job failure
We have a log backup job running every hour. The log backups are being taken for all the databases except one of them. For security purposes lets call this database FAILED_DB.
These are the things I h …
- 83
0
votes
1
answer
1k
views
Query to list all the databases that have a specific user
I need to form a query that lists all the databases that include the words 'PRD' that have a single specific user name 'user_1'
So far I have this query:
select name as username,
create_date,
modify_d …
- 83
-1
votes
1
answer
93
views
When was my indexes in the database fragmented?
I am trying to create a script that finds the index fragmentation, have it log to a table that I can query each time it runs. I need to fins out specifically what time my indexes in a table get fragme …
- 83
0
votes
0
answers
189
views
SQL Server 2014 - Disk Space Issue
Currently we have a drive on your server that stores all user DB's data files along with one tempdb data file. (D: drive) It has 1.4 TB total space with only 98Gigs free space.
The biggest DB size is …
- 83
0
votes
1
answer
1k
views
Always On Instance Service Broker/Database Mirroring transport connection endpoint Error
I have a production instance that has 2 AOG. There is no mirroring configured for both groups. Both groups are also in 'Healthy' state.
Upon checking the error log on SQL Server, I noticed that starti …
- 83
1
vote
1
answer
8k
views
Linked server error- The table either does not exist or the current user does not have permi...
There is a view that is being called from Server A (SQL 2016) and this view needs to read data from Server B (SQL 2014). There is a linked server set up between these two servers and the connection wo …
- 83
-1
votes
2
answers
80
views
Rebuild Indexes [duplicate]
We have a database named WSS_Us_App in our Production SQL Server 2014. In this database all of the indexes need to be rebuilt as most have a fragmentation level greater than 50%. I plan to rebuild the …
- 83
3
votes
2
answers
1k
views
DBCC consistency error in SQL Server
I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error:
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed with the foll …
- 83
1
vote
1
answer
691
views
Kerberos Issue - Anonymous Login
I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection;
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. …
- 83
0
votes
1
answer
592
views
SQL Server data drive (.mdf files) running out of space
We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space.
A few weeks ago DB files were shrunk to temporarily f …
- 83
0
votes
2
answers
7k
views
An error occurred while updating the entries. See the inner exception for details.; [INNER] ...
One of our production SQL Servers the database is performing poorly. On the application side, they are experiencing this error:
An error occurred while updating the entries. See the inner exception f …
- 83
0
votes
0
answers
536
views
Linked server anonymous login error
I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This windo …
- 83
0
votes
0
answers
175
views
Linked Server Issues SQL Server to Oracle
I am trying to set up a linked server from SQL Server Production to one of our Oracle instances but experiencing this error :
The test connection in ODBC succeeds, but it fails on SQL Server side. I …
- 83