No announcements
-
1 VotesMicrosoft SQL Server Management Studio still crashing when opening a database diagram
I have a diagram that ssms v18.3.1 cannot open. Instead, the program stops executing. I can send a backup of the database to any Microsoft ...Proposed | 2 Replies | 162 Views | Created by Anders Bill Lindén - Friday, October 4, 2019 9:14 AM | Last reply by Dedmon Dai - Monday, October 7, 2019 5:48 AM
-
0 Votes
SQL 2012 - any way to check which PC or user on a domain is accessing a database?
Hello, Is there any way to check which users/or connections from a PC are being made to a particular SQL database? It would be handy to know this ...Answered | 2 Replies | 172 Views | Created by Rudolf Amarlapudi - Tuesday, October 1, 2019 6:47 PM | Last reply by Rudolf Amarlapudi - Friday, October 4, 2019 9:47 PM -
0 Votes
Configure sp_send_dbmail for TEST and PROD environments
Not sure if this is the proper sub-forum for this, but here goes. I have TST and PRD SQL servers. We refresh TST databases from PRD, so they're in sync as far as the objects they ...Proposed | 1 Replies | 152 Views | Created by District9 - Wednesday, October 2, 2019 5:14 AM | Last reply by Dedmon Dai - Thursday, October 3, 2019 2:13 AM -
0 Votes
SSMS 18 -- how to uninstall?
Not sure if this is the correct forum but does anyone know how to uninstall SSMS 18. The installation of a "upgrade" failed and when the "upgrade" was uninstalled it broke SSMS 18 ...Answered | 2 Replies | 214 Views | Created by cupboy1 - Monday, September 30, 2019 9:06 PM | Last reply by cupboy1 - Tuesday, October 1, 2019 4:41 PM -
2 Votes
Microsoft SQL Server Database goes in Recovery
Hi, one of our Databases goes multiple times per week into Recovery: 2019-09-25 06:28:05.26 spid23s Recovery of database 'PIM_PROD_MASTER' (7) is 0% complete ...Unanswered | 6 Replies | 201 Views | Created by unlucky_expression - Monday, September 30, 2019 1:03 PM | Last reply by Dedmon Dai - Tuesday, October 1, 2019 7:40 AM -
0 Votes
SSMS 18 Crash
Looking through SQL Agent jobs, SSMS crashed with the following error dialog: This is not consistent, in an enterprise environment so likely no ...Unanswered | 1 Replies | 215 Views | Created by Matt Jones SFMC - Wednesday, September 25, 2019 11:37 AM | Last reply by Amelia Gu - Thursday, September 26, 2019 8:42 AM -
0 Votes
SQL Server 2017 on Ubuntu Linux - Agent History size - unable to configure
Hello, Steps from this ...Proposed | 3 Replies | 231 Views | Created by NikolajSt - Monday, September 23, 2019 6:18 AM | Last reply by Dedmon Dai - Tuesday, September 24, 2019 9:00 AM -
0 Votes
migrating from domain
Hi Guy's, We are going to migrate our users in mydomain.corp to eu.somedomain.com domain. we Have an application that use SQL as DB and application uses Windows ...Unanswered | 2 Replies | 272 Views | Created by Shahin - Friday, September 20, 2019 10:12 AM | Last reply by Shahin - Monday, September 23, 2019 10:08 AM -
0 Votes
View Menu - registered users - sql server 17
Can you tell me where I can find 'Registered Servers', per this information ...Proposed | 2 Replies | 512 Views | Created by LizBurl - Thursday, September 19, 2019 2:55 PM | Last reply by Amelia Gu - Friday, September 20, 2019 6:25 AM -
0 Votes
SQL Server Configuration Manager - SQL Server 2017
I am trying to get the SQL Configuration manager set up; I read a previous question/response that suggested the following command: mofcomp……..\Microsoft SQL ...Proposed | 1 Replies | 263 Views | Created by LizBurl - Thursday, September 19, 2019 2:13 PM | Last reply by Cathy Ji - Friday, September 20, 2019 3:01 AM -
1 Votes
SQL Jobs
Hi All, What happens when you disable a log backup job when its in running state. Does that log backup which was initiated will get completed or the process would get killed ...Answered | 3 Replies | 278 Views | Created by SSG92 - Tuesday, September 17, 2019 1:00 AM | Last reply by Visakh16 - Tuesday, September 17, 2019 5:45 AM -
0 Votes
Why do I get 60-180 GB log files for a 5 GB database?
I have a 60 GB Log file, for a 5 GB DB, in SIMPLE recovery mode. Every couple of days to Log goes wild and fills the Disk @ 180 GBProposed | 3 Replies | 377 Views | Created by RogFalor - Tuesday, September 10, 2019 2:43 PM | Last reply by Jefferson Silva DBA - Tuesday, September 17, 2019 2:52 AM -
3 Votes
Shrink DB
We have a maintenance plan setup to perform few tasks - integrity check, shrink, etc. The shrink DB task has failed with the below ...Proposed | 4 Replies | 387 Views | Created by SSG92 - Sunday, September 15, 2019 5:58 PM | Last reply by Jefferson Silva DBA - Tuesday, September 17, 2019 2:49 AM -
0 Votes
SSMS IMport and EXPORT
Why there is no import and export button in my SSMS 17 ?Proposed | 2 Replies | 318 Views | Created by sakurai_db - Wednesday, September 11, 2019 3:32 PM | Last reply by Olaf Helper - Thursday, September 12, 2019 5:56 AM -
0 Votes
hide user DB's
Hi, Is it possible to to hide all of the user DB's except the one that a user have access to in SQL ssms 2016 or other versions? I remmber that I asked this before and I ...Proposed | 19 Replies | 503 Views | Created by Shahin - Monday, September 9, 2019 10:39 AM | Last reply by Shahin - Tuesday, September 10, 2019 11:27 AM -
1 Votes
SQL 2012 SP1 Task Name Missing from Maintenance Plan History
I have put lots of these in older versions of sql and task name always shows up. This is my first 2012 SP1 install. Here is a normal one from ...Answered | 6 Replies | 4451 Views | Created by benco5000 - Sunday, July 14, 2013 3:47 PM | Last reply by SSG92 - Monday, September 9, 2019 3:08 PM -
0 Votes
Full database backup unintentionally goes to Virtual Backup Device
Hi all, I've setup 3 SQL Agent jobs to run my backups: Full, Differential and Log. I'm using the scripts provided ...Answered | 3 Replies | 462 Views | Created by clay123123123 - Friday, August 30, 2019 4:54 AM | Last reply by clay123123123 - Thursday, September 5, 2019 11:12 PM -
0 Votes
Insert Trigger on Heavy load Table
Hi Friends, Please I want to create After insert trigger on a heavily loaded (high volume of data insertion & selection) table, my question as follow , which parameter I ...Proposed | 2 Replies | 442 Views | Created by malikasad - Wednesday, August 28, 2019 6:05 AM | Last reply by Tom Phillips - Thursday, August 29, 2019 12:36 PM -
42 Votes
Databases in Recovery Pending state
>Program. e.g. there is just 2008 r2 management studio not 2008 one etc. Dont want to let this happen in production environment (i will have backups though), so is ...Answered | 22 Replies | 228337 Views | Created by Dinkar Chalotra - Friday, August 17, 2012 2:32 AM | Last reply by elsmurfadiablo - Wednesday, August 28, 2019 3:01 PM -
0 Votes
Just getting started, no results are coming up when I enter queries.
I am entering queries in what I think is the right syntax, but I am not seeing any results. First I tried selecting specific columns with the format SELECT ...Answered | 2 Replies | 434 Views | Created by Faradn - Tuesday, August 27, 2019 4:49 AM | Last reply by Rachel_Wang - Wednesday, August 28, 2019 5:59 AM - Items 1 to 20 of 2335 Next ›
No announcements
