No announcements
Found 2417 threads
-
0 VotesSSMS behaviour run normally vs run as administrator
I have 2 servers. Both running the following: Microsoft Server 2019 Microsoft SQL Server Express 2017 Microsoft SQL Server Management Studio ...Unanswered | 9 Replies | 4127 Views | Created by CCISolitude - Monday, August 10, 2020 1:18 PM | Last reply by Cris Zhan - Monday, August 17, 2020 1:51 AM
-
0 Votes
How to execute Azure SQL snapshot
Hi team, Whether the Azure SQL database snapshot creation process can run with user traffic/deploy/application restart in the background or the customer should close the ...Unanswered | 4 Replies | 3242 Views | Created by mrLexa - Monday, August 10, 2020 7:24 AM | Last reply by MIAOYUXI - Thursday, August 13, 2020 1:09 AM -
3 Votes
Corruption in database ID 5, object ID 60 possibly due to schema or catalog inconsistency. Run DBCC CHECKCATALOG.
Hello. The server in operation had failed. So after some work, the server is operating normally again. But there is one unresolved ...Unanswered | 8 Replies | 10626 Views | Created by judeoh - Thursday, July 16, 2020 12:42 AM | Last reply by AV111 - Monday, August 3, 2020 8:40 AM -
0 Votes
SQL Agent job throws error Microsoft.ScriptTask. The parameter is incorrect
Hi, I get the error (ScriptTask incorrect parameter) while running the SQL Agent job which executes SSIS package. The SSIS package job runs well when we run in ...Unanswered | 2 Replies | 4605 Views | Created by Prasant Nanda - Friday, July 24, 2020 4:46 PM | Last reply by MIAOYUXI - Tuesday, July 28, 2020 2:02 AM -
3 Votes
"[DbId:XX] ADR enabled for the database." logged all the time in ErrorLog
Hi Team, We were testing ADR in a two SQL Server 2019 CU 4 Developer Edition servers, with a AG setup. After enabling ADR for every database in those instances, the secondary server ...Unanswered | 7 Replies | 4108 Views | Created by Rafael Dontal - Wednesday, July 22, 2020 5:50 PM | Last reply by Amelia Gu - Monday, July 27, 2020 1:07 AM -
0 Votes
SQL Server 2016 Create maintenance plan failed.
Received an error in SQL Server 2016 in setting-up a maintenance plan. SSMS version is 16.5 Cannot create a task from XML for task ...Answered | 7 Replies | 7895 Views | Created by wfg1234 - Tuesday, November 29, 2016 10:03 PM | Last reply by Prasant Nanda - Friday, July 24, 2020 4:38 PM -
1 Votes
Do SELECT statement cause Transaction Log file .ldf files to grow?
Hello, like my Title mentions can a large complex SELECT (only not DMLs) query statement (has some basic functions like LEFT(), MAX(), GETDATE()...with many JOINs ) can cause a DB's Transaction Log ...Answered | 3 Replies | 4389 Views | Created by techresearch7777777 - Tuesday, July 21, 2020 11:35 PM | Last reply by Cathy Ji - Thursday, July 23, 2020 8:21 AM -
0 Votes
SSMS and Windows authentication
Does anyone know how SSMS handles AD group authentication? Specifically, how it handles database access changes while the application is open? We have users that can grant ...Proposed | 6 Replies | 3451 Views | Created by Bulbous - Thursday, July 16, 2020 6:28 PM | Last reply by MIAOYUXI - Thursday, July 23, 2020 1:30 AM -
0 Votes
SSMS 18.5.1 teeeeeeeeeeerrrrrriiiiiiiiibly sloooooooooooow (terribly slow)
I have a fresh install of SSMS 18.5.1 on a freshly installed Windows 10 (64bit). On this instance are 2 databases and one of them even has 2 tables (wauw). Expanding the tables tree of either of the ...Unanswered | 2 Replies | 3111 Views | Created by Michelke - Friday, July 10, 2020 9:14 AM | Last reply by Cathy Ji - Monday, July 13, 2020 1:47 AM -
0 Votes
Reclaim space after deleting large amounts of data from SQL Server table column
I have a table that stores large amount of data in a varbinary(max) column. The table is growing very quick. I have used SSIS package to move all the data less than 12 months into a table in data ware ...Answered | 2 Replies | 4212 Views | Created by denkyira - Friday, July 10, 2020 1:02 AM | Last reply by denkyira - Friday, July 10, 2020 12:35 PM -
0 Votes
Linking exec_sessions.cpu_time and exec_requests.cpu_time in Azure
50 AND DES.is_user_process = 1 AND DES.session_id <> @@SPID ORDER BY ...Unanswered | 5 Replies | 3703 Views | Created by Piers Williams - Thursday, July 2, 2020 7:58 AM | Last reply by Melissa Ma - Tuesday, July 7, 2020 8:08 AM -
0 Votes
Reply_to parameter of sp_send_dbmail
I have configured the DB Mail in MSSQL Sever 14 , i need to add multiple mail address in reply_to : currently i am able to add only one mail id .Any ...Proposed | 3 Replies | 3323 Views | Created by govindarajp91 - Thursday, July 2, 2020 2:07 AM | Last reply by Cathy Ji - Friday, July 3, 2020 7:39 AM -
0 Votes
Strategies of better SQL Management and Cost Saving
Our company has nearly 50 SQL server engines and 250 database instances running, the business applications data in the databases vary greatly in their subjects. Due to lack of expertise and good ...Unanswered | 1 Replies | 3933 Views | Created by Wei_RDU - Tuesday, June 30, 2020 2:55 PM | Last reply by Tom Phillips - Tuesday, June 30, 2020 3:33 PM -
0 Votes
sp_sproc_columns execute every time when jdbc call sp
we have a application to connect sqlserver, i found that when the app call the sp, this system sp 'sp_sproc_columns' was executed every time, and cost much time. i don't konw why .Proposed | 4 Replies | 13109 Views | Created by Kevin Lan - Wednesday, February 9, 2011 2:54 AM | Last reply by Tom Phillips - Monday, June 29, 2020 2:35 PM -
2 Votes
TempDB Full – How to Clear
If tempdb is full how to free up in production environment? and DBCC FREESYSTEMCACHE ('ALL') is recommended in Production environment or not?Answered | 8 Replies | 72523 Views | Created by Nani K - Monday, January 30, 2017 12:52 PM | Last reply by Shankar Kulkarni - Monday, June 29, 2020 4:12 AM -
0 Votes
Can't seem to find any documentation regarding SQL Addin
Im trying to develop an extending add-in to SSMS, versions 15,17,19 . From the little I found on the web there are only a small number of tutorials to create a ...Answered | 4 Replies | 4771 Views | Created by Orel_tri - Saturday, June 13, 2020 8:32 PM | Last reply by Orel_tri - Monday, June 15, 2020 12:14 PM -
0 Votes
Does a real DBA use Visual Studio?
My guess is that real DBAs do not use VS, at least not for DB design. Do they use SSMS for DB Design, or something like SSMS? It has been a while since I worked in an organization with a DBA and I am ...Proposed | 5 Replies | 4409 Views | Created by Simple Samples - Sunday, May 17, 2020 4:54 AM | Last reply by MIAOYUXI - Wednesday, June 10, 2020 9:24 AM -
0 Votes
I just upgraded to SSMS 18.4 and now when I'm tabbing in my table columns, every time I get a Windows "ding" sound.
A few people have this issue, please see here: https://www.reddit.com/r/SQLServer/comments/e6pfb7/tabbing_in_ssms_dings/ Every time you are ...Unanswered | 3 Replies | 4463 Views | Created by DennisGG - Thursday, May 14, 2020 2:35 PM | Last reply by MIAOYUXI - Wednesday, June 10, 2020 9:21 AM -
1 Votes
Unable to Connect other SQL instance using its name
Hi, I have installed SQL Server 2014 (SP2-CU18) on a machine (Mach-c). Its working fine. We have other DB servers as ...Unanswered | 5 Replies | 11069 Views | Created by ZahidButt - Tuesday, February 25, 2020 8:02 PM | Last reply by ZahidButt - Friday, June 5, 2020 3:25 PM -
0 Votes
Reduction of Transaction Log File Size in Simple Recovery Mode
Hi, I was not able to reduce the transaction log file size of my database even if it was in simple recovery mode. The database size was around 250 GB and even ...Answered | 4 Replies | 5210 Views | Created by Indrashish Saha - Thursday, June 4, 2020 9:52 AM | Last reply by Indrashish Saha - Friday, June 5, 2020 6:53 AM - Items 1 to 20 of 2417 Next ›
No announcements
