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
Search options not deleted user 177400

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
400 views

Using @@PROCID to return name of stored procedure

We are migrating from Sybase to MSSQL 2016, and have triggers on some Sybase tables which we have ported from SYB to MSSQL. These triggers are really useful in SYB because they tell us the proc wrote …
  • 352
0 votes
0 answers
285 views

Find full name from AD alias in SQL Server

We have recently migrated from Sybase/SAP ASE to MSSQL Server. master..syslogins in sybase has two columns name and fullname. Name would be AD alias name and fullname is Full Name of the user. Exampl …
  • 352
4 votes
1 answer
2k views

SQL Server detected a logical consistency-based I/O error - tempdb

We started receiving these error messages suddenly Error: 824, Severity: 24, State: 2. Message SQL Server detected a logical consistency-based I/O error: invalid protection option. It occur …
  • 352
2 votes
1 answer
1k views

SQL binaries on C drive?

We are setting up a new SQL Server with over 2 TB size of Database, and this is a heavy OLTP. Let me know, if there is any impact of placing SQL binaries in C drive? or i would need another Drive? Ser …
  • 352
0 votes

How to remove files and filesgroup from dis that have data in it?

These queries may be helpful to you if you are looking for details in the FG's --Find partition schema and partition function details on a DB SELECT t.name AS TableName, ps.name AS PartitionScheme, p …
  • 352
0 votes
1 answer
212 views

Backup Compression SQL Server vs PURE

We are having a SQL 2016 Standard Edition Server holding 4TB of data. And the compressed backup using maintenance plans is taking around 1.5 hrs. Our storage team claims that as PURE FlashArray is us …
  • 352
0 votes
1 answer
27 views

SSRS Encryption errors post reinstall services

Initially, I installed and configured SSRS and backed up Encryption Keys, able to run reports successfully. Then I uninstalled the SSRS from the VM, dropped report databases, renamed the SSRS folder i …
  • 352
0 votes

SSRS Encryption errors post reinstall services

Cleared cache, temporary files, browsing history...and it worked.
  • 352
-2 votes
1 answer
38 views

Long running sp_server_diagnostics

sp_server_diagnostics is running from past 28 days, i.e., from last server reboot. This is going on every month. It never stops and gets notified as long running sessions often. It starts again after …
  • 352
1 vote

XA transactions - timeout errors

below article has more details https://learn.microsoft.com/en-us/archive/blogs/sqlserverfaq/sql-server-deadlocks-due-to-character-data-type-conversion-when-using-sql-server-jdbc-drivers If sendStrin …
  • 352
1 vote
1 answer
123 views

XA transactions - timeout errors

We have recently setup XA Transactions as per the documentation. However, app team is facing the issues as below Performance Test 1: XXXX Internal users [get XXXX token API ] – 3 concurrent users wi …
  • 352
0 votes

ssms does not let me change to server authentication mode and I can not log in

Check this pinal dave solutions - https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-er …
  • 352
2 votes
2 answers
118 views

Login failed errors while DB refresh in progress

We have a 2.5TB refresh in Production, I have automated the refresh of latest production backup to lower environment every Sunday night. And during this activity, SQL error log is filled with Log …
  • 352
2 votes
1 answer
94 views

How to send mail from a restricted SQL Server

I have created an DB refresh job on a pre-prod SQL server, with latest successful Prod backup to refresh pre-prod DB every monday morning. However, i want to send a status mail post refresh. Due to co …
  • 352
1 vote

How to send mail from a restricted SQL Server

So, I used the below script. Prerequisites are that the refresh script will write the log to a shared location accessible from a Prod Server. $date = Get-Date -Format d $dir = "\\xxxxx\g$\QARefresh …
  • 352

15 30 50 per page