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 server different editions
Hello i have a bit of a problem with a computer that i work remotely. the problem is that i have a backup from an sql 2017 server that i want it restrored to that ...Unanswered | 5 Replies | 967 Views | Created by Ipodamia - Wednesday, December 4, 2019 10:37 AM | Last reply by Cris Zhan - Friday, December 27, 2019 9:28 AM -
1 Votes
SQL Server Express R2, Why won't my database expand (where are the objects?) in object explorer?
I've been working with sql server 2008 exclusively through the visual studio interface since I've started coding. I'm trying to get at my database in the SSMS, and I connect, but my database is ...Answered | 15 Replies | 11349 Views | Created by Landdesigner - Sunday, February 19, 2012 9:26 PM | Last reply by Gubber Sing - Thursday, December 26, 2019 10:37 AM -
0 Votes
SQl Server database mdf file
i am a beginner with SQL Server, i am currently working on a little project that uses SQL Server database file(.mdf). the mdf file contains the table ...Unanswered | 4 Replies | 523 Views | Created by Austinnet - Monday, August 20, 2018 9:13 AM | Last reply by Sofia Watson - Thursday, December 26, 2019 5:48 AM -
0 Votes
i can't install the computer Microsoft SQL Server Management Studio
Hello! anything me help! I don't know what to do anymore. Microsoft SQL Server Management Studio erro: ...Answered | 4 Replies | 467 Views | Created by Tiago Pimentta - Friday, December 20, 2019 11:29 AM | Last reply by Amelia Gu - Thursday, December 26, 2019 2:53 AM -
0 Votes
Cannot connect with sql server management studio/sql confiquration missing in my computer
TITLE: Connect to Server ------------------------------ Cannot connect to ...Proposed | 4 Replies | 361 Views | Created by brilliantvinoth - Friday, December 20, 2019 6:55 AM | Last reply by Cris Zhan - Wednesday, December 25, 2019 9:48 AM -
0 Votes
Fill Absent text in empty place using pivot sql
Below is pivot query for my requiremnt. Declare @cols ...Unanswered | 2 Replies | 379 Views | Created by mohd mazhar - Saturday, December 14, 2019 11:44 PM | Last reply by Rachel_Wang - Wednesday, December 25, 2019 8:18 AM -
0 Votes
error 40: cannot connect to server
hello everybody, I am running some tests on simple MVC apps created in VS 2019 and I created an sql server DB through godaddy's plesk dashboard, set up the authorized user, named ...Unanswered | 6 Replies | 224 Views | Created by Adam102345 - Tuesday, December 24, 2019 1:24 PM | Last reply by Dawn Yang - Wednesday, December 25, 2019 5:50 AM -
0 Votes
Replication from SQL Standard to SQL Express. CAL license question
Hi This CAL licensing stuff is making me crazt so I have a CAL question for you experts: If I have a SQL Server Standard with transactional replication set up to ...Answered | 2 Replies | 6114 Views | Created by HBI MSDN - Friday, March 13, 2009 3:45 PM | Last reply by Gustavius - Tuesday, December 24, 2019 4:38 PM -
0 Votes
after reseed, the id value doesn't follow
Hi all, After I reseed, the newly added don't grow their id from the new seed, but follow the current column value. In my case, they should follow the 106716, but they go with ...Unanswered | 5 Replies | 277 Views | Created by sesquipedalian - Monday, December 23, 2019 4:38 PM | Last reply by SQLNeophyte - Tuesday, December 24, 2019 8:11 AM -
0 Votes
Update stats question
Is it necessary to update stats after index rebuild? Please adviseProposed | 6 Replies | 486 Views | Created by johnrp88 - Tuesday, December 17, 2019 5:25 AM | Last reply by Uri Dimant - Tuesday, December 24, 2019 5:08 AM -
0 Votes
SQL Profiler
Hi All, I need to capture deadlocks on a sql 2008R2 server. I dont see option to use Extended events under Management. Using Profiler to capture deadlocks. I am ...Answered | 5 Replies | 381 Views | Created by SSG92 - Friday, December 20, 2019 8:22 AM | Last reply by Uri Dimant - Monday, December 23, 2019 6:53 AM -
92 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 | 42 Replies | 18551 Views | Created by Анѓелкоски Методија - Tuesday, May 14, 2019 7:09 AM | Last reply by Tushar Bhagat - Sunday, December 22, 2019 4:18 AM -
0 Votes
Who is application team
While working in production server Came to know application team Just to know who is application team I felt it's is ...Answered | 8 Replies | 667 Views | Created by johnrp88 - Thursday, December 19, 2019 9:30 AM | Last reply by Erland Sommarskog - Saturday, December 21, 2019 9:57 AM -
0 Votes
[SSMS 18.4] Cannot connect when using servername
Hello I need some to help to understand why SSMS is not able to connect. On the local server, I can connect with 'sa' using : - ...Answered | 3 Replies | 519 Views | Created by Duvernet Vincent - Friday, December 20, 2019 10:33 PM | Last reply by Duvernet Vincent - Friday, December 20, 2019 10:46 PM -
0 Votes
Attach database in MS SQL Server Management Studio did not work
I successfully installed MS SQL Server Management Studio on my computer (windows10). I connect to the server name: SQLEXPRESS, Authentication: Windows ...Answered | 8 Replies | 747 Views | Created by SBLondon - Tuesday, December 17, 2019 1:14 PM | Last reply by SBLondon - Friday, December 20, 2019 9:40 AM -
1 Votes
MS SQL Server Installer won't run
I've downloaded the Express Edition but the Installer won't run. I just git a tiny box with an x, max window button, and minimize button. None of which are functional.Answered | 3 Replies | 2194 Views | Created by Taylor Feinstein - Friday, December 8, 2017 10:06 PM | Last reply by Ronaldvv - Thursday, December 19, 2019 3:36 PM -
1 Votes
Data Not able to Insert or Update in a table through Store Proc
0) begin while @recordCount<=@Total begin Select @ID=ID from @IMPORT_STAFF where ...Answered | 4 Replies | 346 Views | Created by VENKAT YADAV - Thursday, December 19, 2019 3:04 AM | Last reply by Vaibhav-Chaudhari - Thursday, December 19, 2019 9:31 AM -
0 Votes
Scripts needed.
Hi Team, Need your help on getting the sql DB server- Total Memory in the box in terms of GB Number of processors in the ...Unanswered | 3 Replies | 471 Views | Created by S_NO - Wednesday, December 18, 2019 9:36 AM | Last reply by Israel Haylamicheal - Wednesday, December 18, 2019 2:46 PM -
1 Votes
Database maintenance plan backup job still run even job deleted
Hi, Our database maintenance backup job still run daily even job was deleted from Maint. plan and SQL agent. Could you please know why. Thank ...Answered | 13 Replies | 886 Views | Created by Marcus_ch - Tuesday, December 10, 2019 6:39 AM | Last reply by Amelia Gu - Tuesday, December 17, 2019 3:18 AM -
1 Votes
Unable to import Connections from another PC
from new PC 2. My Connections-Old -> from another PC My questions: How could I fix it? Should I change/recreate or etc. with Connection ...Answered | 3 Replies | 536 Views | Created by susja - Friday, December 13, 2019 2:40 PM | Last reply by susja - Monday, December 16, 2019 1:23 PM - Items 1 to 20 of 21604 Next ›
No announcements
