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 | 6 Replies | 357 Views | Created by CCISolitude - Monday, August 10, 2020 1:18 PM | Last reply by Cris Zhan - 3 hours 16 minutes ago
-
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 | 384 Views | Created by mrLexa - Monday, August 10, 2020 7:24 AM | Last reply by MIAOYUXI - 5 hours 25 minutes ago -
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 | 1419 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 | 692 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 | 884 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 | 4753 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 | 827 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 | 1116 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 | 995 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 | 966 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 | 1307 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 | 1192 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 | 1289 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 | 10277 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 | 32922 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 | 1916 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 | 1912 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 | 1681 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 | 2181 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 | 1689 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
