No announcements
-
0 VotesPOSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ...
-
0 Votes
SQL Erro 22022.
Hi, Greeting for the day. I am facing issue with SQL 2008 r2. while running Differential Backup Job getting Error 22022 Job already running by ...Unanswered | 1 Replies | 48 Views | Created by Gulshan.singh - 12 hours 13 minutes ago | Last reply by Erland Sommarskog - 9 hours 8 minutes ago -
0 Votes
Looking for help on my company DayEnd process and alerting
Hello and good morning to you all. In my company I am tasked with writing a SQL query to perform a few actions for our DayEnd processing. First off a little bit ...Unanswered | 3 Replies | 82 Views | Created by toastedbread1 - Friday, October 18, 2019 2:58 PM | Last reply by Erland Sommarskog - 12 hours 2 minutes ago -
2 Votes
The server principal 'username' already exists.
I've removed the username from the Security/Logins. Now I want to recreate with the following code. CREATE LOGIN [USERNAME] WITH ...Proposed | 8 Replies | 84 Views | Created by Charlie2 - Friday, October 18, 2019 12:49 PM | Last reply by nkumar230 - Friday, October 18, 2019 2:34 PM -
0 Votes
Unable to execute update statistics with db_owner for database
What other permission required to only execute update statsUnanswered | 2 Replies | 96 Views | Created by johnrp88 - Thursday, October 17, 2019 5:18 PM | Last reply by Amelia Gu - Friday, October 18, 2019 6:44 AM -
0 Votes
How to visually group a star schema?
Hello, I have a multiple star schemas in the same project file. In the "Diagram" tab, I would like to enclose each star schema in a "box" for the sake of visual organization. Is ...Proposed | 5 Replies | 167 Views | Created by Oliver Eye - Tuesday, October 15, 2019 11:21 AM | Last reply by Stefan Hoffmann - Thursday, October 17, 2019 8:58 AM -
0 Votes
virtual memory
Hi All, Few applications are restarting on its own on our servers. We found low virtual memory condition was the cause. Can anyone help me understand what is ...Unanswered | 4 Replies | 195 Views | Created by SSG92 - Tuesday, October 15, 2019 5:40 AM | Last reply by Shanky_621 - Thursday, October 17, 2019 8:23 AM -
0 Votes
MSSQL license CAL or pocess license?
Hi We have a php base application, what use mysql now. We would like to change is to MSSQL, and we have a question about what kind of licence do we need? The php ...Unanswered | 2 Replies | 104 Views | Created by Gergo Toth - Wednesday, October 16, 2019 11:53 AM | Last reply by Dedmon Dai - Thursday, October 17, 2019 6:36 AM -
0 Votes
Recreate .ldf file?
I have a database which was approx 500MB for the MDF and 150MB for the LDF. I created a backup and deleted some tables holding large records which was not required i.e history ...Answered | 4 Replies | 127 Views | Created by Pure Deal - Wednesday, October 16, 2019 11:48 AM | Last reply by Uri Dimant - Wednesday, October 16, 2019 12:59 PM -
90 Votes
MS SQL Management studio 18 not starting
I have installed latest SMSS (Downloaded May 5th, 2019). It worked for 3 days, and then when I try to start it, it just closed with windows sound error, but no message on any of my ...Answered | 41 Replies | 16009 Views | Created by Анѓелкоски Методија - Tuesday, May 14, 2019 7:09 AM | Last reply by 4Dyce - Wednesday, October 16, 2019 11:38 AM -
1 Votes
error converting data type nvarchar to int
= case @getValue when 100 then 0 ...Unanswered | 11 Replies | 183 Views | Created by VinaySJ - Tuesday, October 15, 2019 6:04 AM | Last reply by Dedmon Dai - Wednesday, October 16, 2019 9:15 AM -
3 Votes
Will SQL Server come online
Dear Experts, Will SQL Server come online if MSDB is corrupted? Does it need all system databases to come online? KiranAnswered | 11 Replies | 477 Views | Created by juniorkiran - Thursday, October 10, 2019 12:11 PM | Last reply by TiborK - Tuesday, October 15, 2019 2:26 PM -
0 Votes
Audit Trail Tables
We have been asked to add audit trails to about 20 tables in our sql 2016 database to be able to identify who inserted, changed or deleted data in each table. I have seen solutions that use a ...Proposed | 20 Replies | 442 Views | Created by David Chase89 - Friday, October 11, 2019 1:05 PM | Last reply by Erland Sommarskog - Monday, October 14, 2019 9:37 PM -
2 Votes
Add/Remove Programs versus service
Hello, SqlServiceAdvancedProperty is the source of inventory data in this case. If it's blank, Configuration Manager must not get the information ...Answered | 3 Replies | 514 Views | Created by Felyjos - Thursday, October 10, 2019 1:32 PM | Last reply by Amelia Gu - Monday, October 14, 2019 9:56 AM -
2 Votes
Queries about database shrink process and database initial size
I have few doubts or confusion about database data ,log file shrink process and initial size Initial size I had drive space issue and so so i checked ...Proposed | 3 Replies | 314 Views | Created by johnrp88 - Saturday, October 12, 2019 6:37 AM | Last reply by Amelia Gu - Monday, October 14, 2019 7:50 AM -
0 Votes
Availability Groups Fail over Report
we have SQL 2012 availability group 3 node cluster, It has 5 AG groups and two group always be primary on node A and 3 groups always primary on node B, node C is for ...Proposed | 2 Replies | 261 Views | Created by Sunny143 - Friday, October 11, 2019 6:23 PM | Last reply by Cathy Ji - Monday, October 14, 2019 6:32 AM -
40 Votes
error: 26 - Error Locating Server/Instance Specified
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does ...Answered | 53 Replies | 219010 Views | Created by pepellini - Friday, July 28, 2006 8:16 PM | Last reply by bardar - Saturday, October 12, 2019 4:14 PM -
1 Votes
Importing CSV Errors
I have spent the last full two days on this. All I am trying to do is import a csv into a new table. Once I have this working, I'll be import a 260 million row ...Answered | 7 Replies | 3680 Views | Created by Bruce D. Meyer - Friday, March 17, 2017 4:31 PM | Last reply by VikrantSrivastava - Saturday, October 12, 2019 10:42 AM -
2 Votes
Installation error : the SQL database engine and the SQL agent failed to start.
We installed a fresh instance of SQl 2008 on a Windows 2008 R2 SP1, the SQL database engine and the SQL agent failed to start. I’ve uninstall and reinstall start services using network ...Answered | 7 Replies | 6477 Views | Created by Mahendra Nikam - Thursday, July 7, 2016 9:21 AM | Last reply by vikashspeaks - Friday, October 11, 2019 7:13 AM -
0 Votes
SQL server and MS server 2012 Upgrade
Hi, We have installed 2008 MS SQL server Software and 2012 MS OS. i want to do the UPGRADE only and not purchase an entire license. where can i do that? and how? what pre-requisits ...Proposed | 2 Replies | 241 Views | Created by Kalkidan Mulu - Thursday, October 10, 2019 12:20 PM | Last reply by Amelia Gu - Friday, October 11, 2019 7:08 AM -
0 Votes
Can I restored TDE backup database to a non-enterprise SQL Server?
I have TDE .bak files and I like to restore it to a non-enterprise SQL Server. Will I be able to restore? This is only for testing purposes only. Thanks!Proposed | 4 Replies | 242 Views | Created by Charlie2 - Thursday, October 10, 2019 11:29 AM | Last reply by Dedmon Dai - Friday, October 11, 2019 6:55 AM - Items 1 to 20 of 21489 Next ›
No announcements
