No announcements
-
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 ...
-
0 Votes
SQL Server 2014 Installation error
I am trying to install SQL Server 2014 on my PC (windows 10 64-bit) with all features. I have also installed visual studio 2013 but the SQL installation gives the ... -
0 Votes
How to import multiple xcel files into sql server?
Hello SQL forum, I would like to check how to I import multiple xcel files into the ...Proposed | 4 Replies | 66 Views | Created by Tan_100 - Friday, February 15, 2019 6:09 AM | Last reply by TheBrenda - 16 hours 8 minutes ago -
4 Votes
Sql Server Configuration Manager - No protocols to configure under SQL Server Network Configuration
Hi All, I am trying to configure SQL Server Network Configuration in Sql Server Configuration Manager. I need to enable TCP/IP in Sql Server Network ...Unanswered | 9 Replies | 241 Views | Created by scMarth - Monday, February 11, 2019 5:31 PM | Last reply by scMarth - 21 hours 33 minutes ago -
0 Votes
Append Tables
Hi, I have 3 tables, all have the same variable names ...Unanswered | 5 Replies | 63 Views | Created by Bone_12 - Friday, February 15, 2019 1:22 PM | Last reply by TheBrenda - 21 hours 44 minutes ago -
0 Votes
Restoring database status suspended
Hi!, I am restoring a large database (1.2TB) with no recovery, but the following query shows the status as 'suspended' and the % complete as ...Unanswered | 3 Replies | 72 Views | Created by Zoe.Ohara - Friday, February 15, 2019 12:05 PM | Last reply by Mohsin_A_Khan - 22 hours 42 minutes ago -
0 Votes
Add a New Column into Query
Hi, I would like to add a new column into my query labelled Contract_Type and for all values to be shown as 'New Business' Any idea how I would do this ...Answered | 1 Replies | 148 Views | Created by Bone_12 - Friday, February 15, 2019 12:14 PM | Last reply by Andrey Belyakov - Friday, February 15, 2019 12:21 PM -
0 Votes
SQL SERVER PRODUCT KEY INVALID
While installing SQL SERVER 2012 error is showing up as PRODUCT KEY INVALIIDUnanswered | 1 Replies | 57 Views | Created by sonali95 - Friday, February 15, 2019 11:51 AM | Last reply by Andrey Belyakov - Friday, February 15, 2019 12:16 PM -
1 Votes
data conversion failed
hello guys, Has anyone encountered this issue before and know what is the solution for it?Answered | 57 Replies | 562 Views | Created by Tan_100 - Friday, February 8, 2019 6:40 AM | Last reply by Tan_100 - Friday, February 15, 2019 5:55 AM -
0 Votes
SQL Licensing
Team, We required SQL Licensing ...Proposed | 1 Replies | 59 Views | Created by Varma-GD - Thursday, February 14, 2019 11:17 AM | Last reply by Olaf Helper - Thursday, February 14, 2019 11:24 AM -
0 Votes
Return ID From INSERT
I'm sure there is a billion ways to do this but I'm trying to return the ID for the insert which would be the purchase id. code: IF ...Unanswered | 2 Replies | 75 Views | Created by old_School - Wednesday, February 13, 2019 8:14 PM | Last reply by Puzzle_Chen - Thursday, February 14, 2019 2:02 AM -
2 Votes
Database Design
Hi everyone, looking for some advice on a database design, the business model is around an online ecommerce tyre website. Basically, I have to purge the tbl.Products each night and ...Answered | 7 Replies | 152 Views | Created by brucey54 - Tuesday, February 12, 2019 9:08 PM | Last reply by brucey54 - Wednesday, February 13, 2019 11:14 PM -
0 Votes
how we can develop exe or sp which ,runs in background and moves rows with status 0 from a table in sql server to oracle
I have one table in sql server , whenever one row with status 0 is inserted in this table,I need ...Unanswered | 2 Replies | 104 Views | Created by vivek_kumar9 - Tuesday, February 12, 2019 6:40 AM | Last reply by TheBrenda - Wednesday, February 13, 2019 3:33 PM -
0 Votes
Database send mail
my database send mail does not seem to be sending the email. I setup a profile from an existing instance that works fine. I ran this EXEC ...Proposed | 6 Replies | 134 Views | Created by Linton123 - Tuesday, February 12, 2019 3:02 PM | Last reply by Uri Dimant - Wednesday, February 13, 2019 6:13 AM -
5 Votes
Table update
Sir while using sqlserver, I have this data I want to update TIK column as like ...Proposed | 5 Replies | 148 Views | Created by Tariq Mehmood - Tuesday, February 12, 2019 2:25 PM | Last reply by Uri Dimant - Wednesday, February 13, 2019 6:10 AM -
1 Votes
Computed Column Specification
Hi everyone, looking for some advice. 1. Importing approx 50k records per day 2. Each record has ...Answered | 6 Replies | 137 Views | Created by brucey54 - Monday, February 11, 2019 8:00 PM | Last reply by Erland Sommarskog - Tuesday, February 12, 2019 12:11 PM -
3 Votes
how to run a query on different servers without stopping if connection fails for one server
Hi, I have a sql select query that i need to run on more than 100 servers(probably using loop and connecting using linked server connection). So my question is while running this ...Answered | 9 Replies | 459 Views | Created by vinisha9 - Friday, April 27, 2018 12:00 PM | Last reply by Mohsin_A_Khan - Tuesday, February 12, 2019 7:39 AM -
2 Votes
Problem importing an Access Database
Hi I'm trying to import an Access Database in an SQL one. I used SQL Server Management Studio. I created a new database then Tasks / Import ...Answered | 7 Replies | 510 Views | Created by BernardBouree - Sunday, August 12, 2018 1:59 PM | Last reply by Ed Price - MSFT - Tuesday, February 12, 2019 7:16 AM -
3 Votes
Reporing server out op prod live data
i have always on setup on sql 2014 with two databases ABC database is primary on first server and XYZdatabase is primary on second ...Answered | 4 Replies | 296 Views | Created by '''HuuM''' - Tuesday, June 5, 2018 3:19 PM | Last reply by Ed Price - MSFT - Tuesday, February 12, 2019 7:06 AM -
4 Votes
Wrong installer for SQL Server 2016 with SP1
If you go to here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 and download SQL Server 2016 with SP1 and run it, it installs SQL Server ...Answered | 6 Replies | 592 Views | Created by enventive - Friday, May 25, 2018 7:57 PM | Last reply by Ed Price - MSFT - Tuesday, February 12, 2019 7:04 AM -
3 Votes
how to clear list of login names appearing in Dialogbox in SSMS 2012
hi Just wanted to know how to clear all login names that appear in the list of"Connect To Server" dialog box while getting connected to database engine in SSMS in Sql ...Answered | 9 Replies | 1069 Views | Created by srm_2010 - Thursday, December 28, 2017 12:40 PM | Last reply by Ed Price - MSFT - Tuesday, February 12, 2019 6:58 AM - Items 1 to 20 of 21065 Next ›
No announcements