No announcements
-
0 VotesWho will be announced as the next SQL Server Guru? Read more about September 2018 Competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance to ...
-
0 Votes
POSTING 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 ...
-
1 Votes
Unable to install SQL Server (setup.exe).
I am a student trying to install SQL Server 2016 with SP1 Basic for a class so am new to this. Any help/clarification is appreciated. I keep getting the ...Proposed | 2 Replies | 1343 Views | Created by p.meisner - Wednesday, March 01, 2017 2:36 AM | Last reply by rajan45 - Saturday, September 22, 2018 10:42 AM -
0 Votes
SQL Server Management Studio - License Prerelease Software - The License has expired 2017
I am trying to work on SQL Server 2017. SQL Server Management Studio 2017 - License Prerelease Software - The License has expired. When I was installing the ...Proposed | 2 Replies | 54 Views | Created by HeaIer - Saturday, September 22, 2018 1:52 AM | Last reply by Erland Sommarskog - Saturday, September 22, 2018 8:23 AM -
0 Votes
i received error massage "TITLE: Microsoft SQL Server 2014 Setup ------------------------------ The following error has occurred: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes."
i'm trying to install SQL server 2014 express edition. but i received error massage "TITLE: Microsoft SQL Server 2014 ...Unanswered | 2 Replies | 46 Views | Created by heshr124 - Thursday, September 20, 2018 5:08 PM | Last reply by Emily Fei - Friday, September 21, 2018 2:56 AM -
0 Votes
Northwind database SQL Task
Hi, Can anyone please tell me how to get the Number of Orders per territory from the Northwind database?? I have tried it, but I could not get the count for ...Proposed | 7 Replies | 133 Views | Created by Sathya69 - Wednesday, September 19, 2018 1:00 PM | Last reply by Erland Sommarskog - Thursday, September 20, 2018 9:32 PM -
0 Votes
How to backup databases are in (Synchronized) mode
I have a SQL server. Most databases in that server are in "Synchronized" mode (required by the applications). I set up a regular maintenance plan to backup the databases and the logs. But ...Answered | 2 Replies | 74 Views | Created by eg10013 - Wednesday, September 19, 2018 2:16 PM | Last reply by eg10013 - Thursday, September 20, 2018 1:51 PM -
0 Votes
trouble connecting to SQL Server
Hi experts, I have a SQL server 2008 installed on the default port 1433. Reporting service installed as well on the same box on port 8080. From a second machine I need ...Answered | 4 Replies | 4893 Views | Created by Tran Leung - Friday, July 10, 2009 1:07 AM | Last reply by LightUPsql - Thursday, September 20, 2018 12:09 PM -
0 Votes
Trigger from sysmail_faileditems
Is it possible to create a trigger that will sent me an email if a dbmail fails with sent_status "failed"?Unanswered | 4 Replies | 85 Views | Created by ThomasRH - Wednesday, September 19, 2018 7:13 PM | Last reply by Visakh16 - Thursday, September 20, 2018 7:51 AM -
0 Votes
Database refresh - Adding back User and Roles
Hi, Database refresh between environments is a common activity in a development environment. During the refresh process, the user permissions( User ID, roles) available in the ...Unanswered | 1 Replies | 100 Views | Created by Venkatzeus - Wednesday, September 19, 2018 9:18 AM | Last reply by Teige Gao - Thursday, September 20, 2018 6:58 AM -
0 Votes
SQL User CALs for 2nd SQL Server
Hi, Would like to know, if i have 1 SQL server 2012, and 1 SQL Server 2014 with 65 SQL User CALs 2014. Do i need to purchase another 65 user CALs or my ...Proposed | 1 Replies | 63 Views | Created by TeckyChong - Wednesday, September 19, 2018 2:41 PM | Last reply by Olaf Helper - Wednesday, September 19, 2018 3:42 PM -
0 Votes
BULK INSERT WITH '0x0A'
Hi Team, I've 4 columns in my database table, whereas 10 columns in my .csv file. I want to upload first 4 columns of .csv file only in db ...Proposed | 6 Replies | 75 Views | Created by anwar.mustafa - Wednesday, September 19, 2018 7:16 AM | Last reply by Erland Sommarskog - Wednesday, September 19, 2018 12:44 PM -
2 Votes
How to move clustered index from one filegroup to another filegroup
Good Morning Experts, How to move clustered index from one filegroup to another filegroup. KiranAnswered | 6 Replies | 106 Views | Created by juniorkiran - Monday, September 17, 2018 12:27 PM | Last reply by TiborK - Wednesday, September 19, 2018 11:34 AM -
1 Votes
After in place upgradation of OS from Win2008 r2 to Win2016 Std, unable to start SQL server service (SQL Server 2008 R2)
Details: I had a Hyper-v VM with "Windows server 2008 R2" and "SQL server 2008 R2". Now after in place upgrade from Windows server 2008 R2 to ...Proposed | 4 Replies | 203 Views | Created by PintuGorai - Friday, September 14, 2018 1:48 PM | Last reply by pituach - Tuesday, September 18, 2018 7:32 PM -
0 Votes
SQL Server Management studio Not opening
Hi , I tried to install SQLEXPRWT_x64_ENU and it got installed with all the green options at the finish. So when I try to double click on it SQL Server ...Proposed | 6 Replies | 195 Views | Created by PradeepSsql - Saturday, September 15, 2018 8:55 AM | Last reply by pituach - Tuesday, September 18, 2018 7:25 PM -
0 Votes
How Can I Make SQL Server Fast For My Website?
Hey Folks, I have recently made an E-Commerce website related to home decor products and SQL server is creating too many problems for me. As I am new here in Server Management. You ...Unanswered | 1 Replies | 80 Views | Created by cricketworldcup2015highlights - Tuesday, September 18, 2018 12:39 PM | Last reply by Visakh16 - Tuesday, September 18, 2018 1:05 PM -
0 Votes
SSMS 17.9 - don't color syntax
Hi SSMS 17.9 don't color syntax when at least one line has more than 32769 columns. When can you fix it? In version 17.4 works.Unanswered | 3 Replies | 95 Views | Created by Sebastian Ozdoba - Monday, September 17, 2018 1:24 PM | Last reply by Puzzle_Chen - Tuesday, September 18, 2018 7:28 AM -
0 Votes
Calculation if value eq 0
Hi, I need a calculation but not sure how to write it: if 'men' = 0 then 0 else 'data_to' - 'data_his' end How would I write this ...Answered | 1 Replies | 65 Views | Created by AJ_25 - Monday, September 17, 2018 3:07 PM | Last reply by Visakh16 - Monday, September 17, 2018 3:19 PM -
0 Votes
Get records based on a string containing Special Character (γ)
I have a table with one of the column containing values, say "Co-Culture ofSolubleIFNγ-NegativeControl". When I query this table using - select * from table ...Answered | 7 Replies | 174 Views | Created by TRUNKASH - Wednesday, September 12, 2018 10:41 PM | Last reply by Visakh16 - Monday, September 17, 2018 1:44 PM -
0 Votes
Full backups are successful however our log drive is running out of space. what can we do?
Full backups are successful however our log drive is running out of space. It appears our log files are increasing in size abnormally. what can we ...Proposed | 5 Replies | 178 Views | Created by kimdav111 - Friday, September 14, 2018 6:35 AM | Last reply by Emily Fei - Monday, September 17, 2018 9:28 AM -
0 Votes
Snapshot backup in on premise SQL Server?
Hi Experts, Do we have any functionality to take snapshot backups in SQL Server for on-premise editions such as ENT, STD? We are currently using SQL Server 2017 ...Proposed | 7 Replies | 218 Views | Created by Asif_DBA - Friday, September 14, 2018 3:32 PM | Last reply by TiborK - Monday, September 17, 2018 9:13 AM -
0 Votes
Using MS SQL 2016 Developer on a test server with a copy of the industrial database.
Hello! The licensing documentation for MS SQL 2016 on the Developer Edition says: SQL Server ...Answered | 2 Replies | 99 Views | Created by Bob Stick - Monday, September 17, 2018 7:05 AM | Last reply by Teige Gao - Monday, September 17, 2018 8:54 AM - Items 1 to 20 of 20816 Next ›
No announcements
