No announcements
Found 14134 threads
-
1 VotesSQL Agent Error: unable to connect to sql server '(local)'. the step failed
RE: Windows 2000 Enterprise Edition (SP4), SQL Server 2000 Enterprise Edition (SP3), default instance, stand alone server (not clustered or replicated) I have a SQLAgent job that runs ...Answered | 5 Replies | 27585 Views | Created by SQLme - Friday, December 15, 2006 7:40 PM | Last reply by Rama-M - Thursday, July 30, 2020 2:13 PM
-
1 Votes
SSMS > Open > File > Search causes crash every time, anyone else?
For the last year I've had to stop using the Search field in the Open File dialog. SSMS crashes (not responding) immediately upon clicking on it. This has ...Proposed | 7 Replies | 4219 Views | Created by leifp - Thursday, July 2, 2020 4:20 PM | Last reply by Naomi N - Monday, July 27, 2020 4:20 PM -
0 Votes
Is there a Text String length limitation on using SSMS Guid for EXEC sp
Fellow SQLers I am a lead DBA. One of my developers ran across something strange. SQL 2016 SSMS. They have an sp that has a few input parameters. One of them, ...Answered | 4 Replies | 2870 Views | Created by mg101 - Thursday, July 23, 2020 7:32 PM | Last reply by mg101 - Friday, July 24, 2020 1:57 PM -
0 Votes
Database instance on object explorer showing 'question mark' on cluster host server.
I have a 2 node active passive cluster setup with SQL 2019 & Microsoft 2019. There's no problem with the cluster, SQL instance able to fail over successfully ...Unanswered | 3 Replies | 5000 Views | Created by Jason Oon - Monday, July 20, 2020 8:19 AM | Last reply by Amelia Gu - Friday, July 24, 2020 9:45 AM -
0 Votes
Fail to install SMSS 18.5.1 on win2012R2 - the parameter is incorrect (0x80070057)
Dear all, i have tried to install SMSS18.5.1 onto a Win2012R2. it show the following error. i have tried to use the netfxrepairtool but still fail to repair the ...Unanswered | 9 Replies | 3434 Views | Created by zkchiu - Monday, July 13, 2020 7:40 AM | Last reply by MIAOYUXI - Friday, July 24, 2020 9:32 AM -
1 Votes
SQL Server memory setting. Restart required?
Hi all, I have a production SQL Server cluster (2008R2) on which I need to configure the 'min server memory" and "max server memory". Do I need to restart the SQL ...Answered | 11 Replies | 58257 Views | Created by Sid Kothari - Thursday, March 8, 2012 1:52 AM | Last reply by Shanky_621 - Thursday, July 23, 2020 5:34 PM -
1 Votes
SQL Server Version Control / Change Automation
Dear Experts, I am looking for a Microsoft Tool which I can adopt for SQL Server Scripts Deployments a kind of Version Control tool that is available with Microsoft. Do you ...Answered | 2 Replies | 2579 Views | Created by Momen Azmath - Wednesday, July 22, 2020 6:48 AM | Last reply by Cris Zhan - Thursday, July 23, 2020 5:45 AM -
0 Votes
Activity monitor always Paused.
I have a newly setup SQL 2019 cluster running on a Windows 2019 server. I notice when I logon to SSMS & launched the Activity Monitor, it'll be started up as paused. There's no way for me to ...Unanswered | 7 Replies | 3535 Views | Created by Jason Oon - Wednesday, July 15, 2020 8:20 AM | Last reply by MIAOYUXI - Tuesday, July 21, 2020 1:46 AM -
0 Votes
master.sys.xp_delete_file runs successfully, but does not delete the files
I have a process that is trying to delete some backup files from a directory and event though everything seems to run successfully the files do not get deleted. I'm running in ...Proposed | 6 Replies | 4745 Views | Created by LenkaPenka - Friday, June 30, 2017 4:07 AM | Last reply by Laxmidhar sahoo - Monday, July 20, 2020 11:42 AM -
1 Votes
Agent Jobs when sqlcmd command step has an error agent step is still successful
> %sql_log% IF %ERRORLEVEL% NEQ 0 GOTO ...Unanswered | 2 Replies | 2947 Views | Created by Bassrocks27 - Thursday, July 16, 2020 2:26 PM | Last reply by Cris Zhan - Friday, July 17, 2020 3:28 AM -
0 Votes
Query Azure Active Directory from a SQL Managed instance.
Not sure if this question belongs here, but will give it a try. Is it possible to add add Azure AD as linked server to enable the SQL instance to read ...Proposed | 2 Replies | 2694 Views | Created by Abner Estrada - Tuesday, July 14, 2020 3:03 PM | Last reply by Cathy Ji - Thursday, July 16, 2020 2:58 AM -
0 Votes
Error 0x80070643: Process returned error: 0x643
Hi: I am not able to install ssms 18.5 or 17.9. It always has same error "Error 0x80070643: Process returned error: 0x643". I tried uninstall .net ...Unanswered | 1 Replies | 4512 Views | Created by Salina Cheung - Wednesday, July 15, 2020 10:33 PM | Last reply by Cris Zhan - Thursday, July 16, 2020 2:00 AM -
2 Votes
Access Denied when attempting to open trace
Hello, We are having issues opening SQL trace files in the SQL Server Profiler. We keep receiving "Access ...Proposed | 5 Replies | 2930 Views | Created by ShaneJohnson2002 - Tuesday, July 14, 2020 2:09 PM | Last reply by Cris Zhan - Wednesday, July 15, 2020 2:05 AM -
0 Votes
SQLAGENT Job Failed
Dear colleagues, I got a strange issue. I have SQL 2014 Standard (upgraded from SQL 2014 Express). I've just created a Maintenance plan with one task (update statistics). When I run ...Unanswered | 5 Replies | 2806 Views | Created by sport-now - Saturday, July 11, 2020 7:29 AM | Last reply by Cathy Ji - Tuesday, July 14, 2020 3:17 AM -
3 Votes
[SSMS] How to add character to end of line?
I have a list of numeric values (copied from an Excel column) that I need to include in the IN clause, but before I do, I need to convert them to strings and separate them by commas. So I need to wrap ...Answered | 11 Replies | 9281 Views | Created by Alek Davis - Monday, July 6, 2020 6:45 PM | Last reply by Alek Davis - Monday, July 13, 2020 6:16 PM -
1 Votes
CPU usage Trends
Hello, Is there way I can track or Are there any tools out there that could tell us that "X user is causing the ...Unanswered | 2 Replies | 2473 Views | Created by JinalContractor - Tuesday, July 7, 2020 10:46 PM | Last reply by Cris Zhan - Monday, July 13, 2020 1:38 AM -
1 Votes
Can't install SQL Server Management Studio 19 .
I have windows 10 and I am trying to install SQL Server Management Studio 19 but it is not installing in my PC and stuck after loading packages Please ...Unanswered | 3 Replies | 2351 Views | Created by Priyajala - Thursday, July 9, 2020 9:46 AM | Last reply by Cris Zhan - Monday, July 13, 2020 1:32 AM -
13 Votes
SQL Database Recovery
Hi, We have accidentally deleted a database from SQL server. Then we have used NTFS file recovery tools such as R-Studio and scanned the entire drive. As a result of the scanning ...Answered | 12 Replies | 8183 Views | Created by Sairams - Wednesday, December 17, 2014 5:13 AM | Last reply by Pollard Donald - Friday, July 10, 2020 11:44 AM -
10 Votes
SQL Database is corrupted
unfortunately hard disk of my system is damaged, now i recovered my database. but it cannot be attached again to SQL management studio 2005. the error ...Answered | 10 Replies | 11676 Views | Created by CarlosVelaZen - Wednesday, December 24, 2014 1:53 AM | Last reply by Pollard Donald - Friday, July 10, 2020 11:19 AM -
0 Votes
Invoke-SqlCmd passing variables causing the issues.
i need to pass variables from power shell script to SQL File. The following code works with sqlcmd but if i use Invoke-Sqlcmd its not ...Unanswered | 1 Replies | 2122 Views | Created by SHANKARARUL - Tuesday, July 7, 2020 11:16 AM | Last reply by Dave Patrick - Tuesday, July 7, 2020 12:33 PM
No announcements
