No announcements
-
0 VotesRestore slows in one SQL
We are moving from one SQL server to newer SQL with better hardware. Both systems have identical configuration. We wont like to change any configuration in newer system. Currently we are doing some ...Unanswered | 2 Replies | 57 Views | Created by Chickoo79 - 6 hours 46 minutes ago | Last reply by Chickoo79 - 1 hour 40 minutes ago
-
1 Votes
Rotation of Keys used for Encryption in SSL and other database encryption features
Dear Experts, I want to know, how can i renew/alternative when the certificates used for SSL or other encryption used get's expired. What is the practice ...Proposed | 3 Replies | 113 Views | Created by DevendraY - Friday, August 16, 2019 9:21 AM | Last reply by Cathy Ji - Monday, August 19, 2019 9:29 AM -
2 Votes
SSMS stops working in SQL 2016 when clicking permissions
Hi All, After installing Microsoft SQL 2016 from scratch , we noticed that SSMS stop working when clicking permission tab(Attached) I tried to install ...Unanswered | 10 Replies | 1951 Views | Created by Peter Zulof - Wednesday, December 28, 2016 10:30 AM | Last reply by Tom Phillips - Friday, August 16, 2019 12:31 PM -
1 Votes
Unable to launch SQL management studio
Hi all, Can anyone help to fix the below error. OS - 2012 R2 and DB - SQL 2014. We have already gone ...Answered | 6 Replies | 202 Views | Created by Suhag Desai - Tuesday, August 13, 2019 12:55 PM | Last reply by Suhag Desai - Wednesday, August 14, 2019 10:27 AM -
0 Votes
Non-existent path prepended to DISK parameter in SQL Server for Linux
We're running SQL Server 14 on Linux. When I run: BACKUP DATABASE [master] TO DISK = N'/tmp/master-full.bak' WITH NOFORMAT, ...Unanswered | 1 Replies | 132 Views | Created by justanothertechnetuser - Monday, August 12, 2019 8:51 PM | Last reply by Dedmon Dai - Tuesday, August 13, 2019 6:04 AM -
0 Votes
How to receive SQLCMD information messages syncronously in Linux
Is possible to receive the information messages displayed during execution of a query (stored procedure), syncronously, at the time of their output, but not upon termination of execution of all ...Unanswered | 1 Replies | 191 Views | Created by Федор Кубанец - Thursday, August 8, 2019 2:03 PM | Last reply by YKN123 - Friday, August 9, 2019 10:07 AM -
0 Votes
Management Data Warehouse database keeps growing
I installed management Data Warehouse database on a SQL Server utility server. We're not really using it at the moment, i.e., not intending to upload data collector sets. MDW01 database ...Unanswered | 1 Replies | 257 Views | Created by District9 - Wednesday, July 31, 2019 5:19 PM | Last reply by KevinNicholas - Wednesday, July 31, 2019 7:28 PM -
0 Votes
Create daily job from DBA side or App side?
Hello, been getting ongoing new requests from different App teams lately to setup a SQL Agent job to basically: - Truncate their App team's local SQL Server DB target ...Proposed | 2 Replies | 309 Views | Created by techresearch7777777 - Tuesday, July 30, 2019 2:01 AM | Last reply by nari_337 - Wednesday, July 31, 2019 11:13 AM -
0 Votes
Can't install SSMS on a 2008 R2 server
I have a Windows 2008 R2 server running SQL Server 2008 R2 (SP3). In SSMS 2008 R2, i try to connect to a SQL Server 2014 Server. I get error #10054... "A connection was successfully ...Proposed | 1 Replies | 248 Views | Created by District9 - Monday, July 29, 2019 10:32 PM | Last reply by Dedmon Dai - Tuesday, July 30, 2019 2:51 AM -
0 Votes
SQL server licence or not
Hello, We have SQL server installed by the person who is not with organization anymore. We are not sure whether it's licences or not. Where should i get the ...Proposed | 4 Replies | 340 Views | Created by Chickoo79 - Thursday, July 25, 2019 4:49 PM | Last reply by Dedmon Dai - Friday, July 26, 2019 8:20 AM -
0 Votes
Suppress the "BackupToUrl process initiated"
I am backing up databases Directly to Azure via Ola Scripts. Is there anyway to suppress the "BackupToUrl process initiated" message that is put in the Error Log Every time a ...Unanswered | 4 Replies | 700 Views | Created by DekoDBA - Monday, June 24, 2019 7:03 PM | Last reply by DekoDBA - Tuesday, July 23, 2019 1:25 AM -
0 Votes
Hide user database
Hi, I have a user that must acess the SQL server with ssms. We have many production DB's on this server and we would like to hide the those DB's for this uer. I ...Answered | 8 Replies | 380 Views | Created by Shahin - Wednesday, July 17, 2019 9:46 AM | Last reply by Tom Phillips - Wednesday, July 17, 2019 11:59 AM -
0 Votes
Joining Multiple tables in Sql SERVER DW
I am trying to create a view from one DW Database tables to another DW database (which is empty). I have total 5 tables - 4 tables in one schema and another table is in another ...Proposed | 5 Replies | 502 Views | Created by pdsqsql - Tuesday, July 9, 2019 5:42 PM | Last reply by Rachel_Wang - Friday, July 12, 2019 7:57 AM -
0 Votes
Archiving large table
I have a database size around 2.5 TB which has a table with 3 billion records size about 650 GB, Database is in simple recovery ...Unanswered | 5 Replies | 517 Views | Created by Zeal DBA - Wednesday, July 3, 2019 9:28 AM | Last reply by TiborK - Tuesday, July 9, 2019 6:49 AM -
53 Votes
SQL Server Configuration Manager: Cannot connect to WMI provider
I installed the latest version (v17.2) of SQL Server on a new PC, and when trying to access "SQL Server 2017 RC1 Configuration Manager" I'm receiving the following error ...Proposed | 28 Replies | 57944 Views | Created by callen1 - Saturday, August 19, 2017 3:11 AM | Last reply by Ashish.Jaswal - Sunday, July 7, 2019 6:05 PM -
0 Votes
Problem accessing remote paths in Powershell via SQL Agent job
Hi, I have a SQL Agent job that has one step - a Powershell script. To simplify things, the script now has only one line: Remove-Item ...Unanswered | 5 Replies | 2790 Views | Created by Docentus - Friday, January 20, 2017 11:12 AM | Last reply by TONMOY RAHMAN - Tuesday, July 2, 2019 3:42 AM -
0 Votes
Open SQL Mgmt studio on Windows core server
Whats the syntax or steps to open SQL Mgmt studio via command line on Windows core server with SQL 2016 instance. used to UI interface ...Proposed | 1 Replies | 387 Views | Created by SQLrocket3003 - Monday, July 1, 2019 9:03 AM | Last reply by Leon Laude - Monday, July 1, 2019 9:11 AM -
0 Votes
Archiving large table
I have a database size around 2.5 TB which has a table with 3 billion records size about 650 GB, Database is in simple recovery model. I want to archive the table since it is ...Unanswered | 3 Replies | 491 Views | Created by Zeal DBA - Thursday, June 27, 2019 9:55 AM | Last reply by Cathy Ji - Friday, June 28, 2019 9:23 AM -
0 Votes
SQL databases goes to recovery pending state when failed over to another node. Asks to open or create a master key.
I have two-node cluster for SQL server. One of the nodes work fine, but as soon as I fail my node to another one, my databases go recovery pending. When I check the logs it asks me to create or open a ...Unanswered | 6 Replies | 567 Views | Created by rgrg3639 - Monday, June 24, 2019 3:58 PM | Last reply by rgrg3639 - Wednesday, June 26, 2019 2:23 PM -
0 Votes
Drop index on a large table
Hi All, I have a table size approx 1 TB and millions of records, where one non-clustered index is there size 255 GB, i wanted to drop that index, its ...Answered | 1 Replies | 413 Views | Created by Zeal DBA - Wednesday, June 26, 2019 11:16 AM | Last reply by Shanky_621 - Wednesday, June 26, 2019 11:21 AM - Items 1 to 20 of 2315 Next ›
No announcements
