No announcements
-
3 VotesWho will be announced as the next SQL Server Guru? Read more about April 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
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 Agent scheduled job taking abnormally long time to run but the same one finishing in time when run manually
I am having a quite strange problem- the scheduled job in SQL Server Agent is taking abnormally long time to run. However the same job when I right click on the job and select "Start job at ...Unanswered | 13 Replies | 3278 Views | Created by SQLjoy - Wednesday, April 17, 2019 6:29 PM | Last reply by SQLjoy - 24 minutes ago -
0 Votes
Windows 7 desktop cannot connect to rebuilt SQL server
Reinstalled Server 2008 R2 Standard and joined to domain. Workstations that reboot aren't being updated with the domain name resolution for our PITSQL server. ...Unanswered | 3 Replies | 835 Views | Created by lr1516 - Saturday, April 20, 2019 2:48 AM | Last reply by Matt Bradley Mcr - 14 hours 15 minutes ago -
0 Votes
Loop-select - combine multiple rows
Hi, I have a table that looks like ...Answered | 9 Replies | 672 Views | Created by endeka - Tuesday, April 2, 2019 10:18 AM | Last reply by Lokesh Vij - Thursday, April 18, 2019 4:14 PM -
1 Votes
System Reports/Queries on Foreign Keys
To all I've recently been given charge of a very large (and over-designed) database. Currently I am trying to work out a road-mapping of relations between the ...Answered | 4 Replies | 371 Views | Created by Marcus Claudius - Thursday, April 18, 2019 11:37 AM | Last reply by Marcus Claudius - Thursday, April 18, 2019 1:10 PM -
0 Votes
Unable to execute powershell script due to WMI error
Hi Msdn, I am getting below error while executing powershell script to get disk space details from server. Could you help me with this.Proposed | 1 Replies | 375 Views | Created by Adi9032 - Thursday, April 18, 2019 4:26 AM | Last reply by Olaf Helper - Thursday, April 18, 2019 5:42 AM -
0 Votes
Problem in copying two files in powershell
Hi all, I want to get sql table data extract in text file with caret"^" symbol delimiter with haeder. declare @header varchar(8000) select @header = ...Answered | 7 Replies | 1119 Views | Created by Shaafs - Wednesday, April 17, 2019 6:11 AM | Last reply by pituach - Wednesday, April 17, 2019 11:13 PM -
0 Votes
I have the table in DB but while updating it I get such an error "Invalid object name 'SLOGMENUS'."
My Query is as follows SELECT TOP 1000 [MENU_ID] ,[MENUDESC] ...Proposed | 1 Replies | 373 Views | Created by sandcastle18 - Wednesday, April 17, 2019 9:44 AM | Last reply by Dan Guzman - Wednesday, April 17, 2019 9:52 AM -
0 Votes
Sql Server 2017 - Linux - intermittent crashes with messages "Last Chance"
We are running into periodic (every few days) crashes in sql server 2017 on ubuntu 16.04. We are running the latest cu (14 at time of writing) . These dumps and messages are vague, and we ...Unanswered | 2 Replies | 559 Views | Created by zippyjason - Tuesday, April 16, 2019 12:58 PM | Last reply by Dedmon Dai - Wednesday, April 17, 2019 8:14 AM -
8 Votes
bcp Export to CSV with headers
I’m trying to find a way to export all data from a table in to a csv file with a header. I’m not concerned at this point with dynamic headers (that would be nice ...Answered | 12 Replies | 167348 Views | Created by Mikedc2 - Thursday, March 29, 2007 8:32 PM | Last reply by Erland Sommarskog - Tuesday, April 16, 2019 9:23 PM -
1 Votes
Import flat file SQL Server Express 2017
Good day I am trying to import a csv file into a table. First time I am really using sql server. I am using the new flat file wizard for Express ...Answered | 6 Replies | 10822 Views | Created by AlwynSchutte - Thursday, December 7, 2017 10:16 AM | Last reply by Lydia125 - Tuesday, April 16, 2019 12:37 PM -
0 Votes
Saving data from a C#/WPF application into a database with the ease of XML serialization
Currently, I'm serializing my data and various objects into an XML file. This works great because I just tell C# where to serialize my object and it creates the perfect XML file that I can read in ...Proposed | 3 Replies | 483 Views | Created by T Gregory - Monday, April 15, 2019 3:35 AM | Last reply by Olaf Helper - Tuesday, April 16, 2019 5:33 AM -
0 Votes
SQL Server Machine Learning Services vs azure machine learning?
Hi, What's the difference between 'SQL Server Machine Learning Services' and 'azure machine learning'? I used to be a sql developer, I am a statistician now, I am ...Proposed | 4 Replies | 632 Views | Created by maca128 - Saturday, April 13, 2019 9:38 PM | Last reply by Alberto Morillo - Tuesday, April 16, 2019 3:28 AM -
0 Votes
SQL Mail Operation Timed Out Error
Hi, Getting error Mail Server failure, operation timed out when we try to send more than 70 emails at one go from sql job or procedure, showing some mails retrying and ...Answered | 5 Replies | 680 Views | Created by KVR_Sekhar - Thursday, April 11, 2019 12:35 PM | Last reply by KVR_Sekhar - Monday, April 15, 2019 11:41 AM -
0 Votes
add the Distribution Agent login to the PAL - repl_distribution does not appear where described
Hi all, I'm trying to follow this ...Unanswered | 3 Replies | 665 Views | Created by marchelloua - Friday, April 12, 2019 5:40 PM | Last reply by Dedmon Dai - Monday, April 15, 2019 9:37 AM -
0 Votes
SQl Server Paste is disabled.
Hi All, My SQl Server all of sudden Paste option is disabled. When I am pasting the query in the "New Query window" Please help me ...Unanswered | 3 Replies | 519 Views | Created by Kayra_ - Friday, April 12, 2019 4:11 AM | Last reply by Dedmon Dai - Monday, April 15, 2019 6:32 AM -
0 Votes
Having trouble deploying a VS c# localdb Sql application to my daughters PC in Switzerland
I have written management application in C# on VS using SQL (localdb)MSDSQLocaldb, which runs perfectly on my Home PC (Win 10). it runs in any file location onmy computer, ( I move the ...Proposed | 2 Replies | 497 Views | Created by Rob James Kelley - Sunday, April 14, 2019 4:12 PM | Last reply by Dedmon Dai - Monday, April 15, 2019 3:11 AM -
5 Votes
Keep getting failed install r .. sql server 2017
Hi I've tried 4 times so far to install sql server and each time I get the same error that failed to install r package. I've goggled and tried all options I've ...Answered | 6 Replies | 730 Views | Created by Mohamed_GadAllah - Thursday, April 11, 2019 7:41 PM | Last reply by Mohamed_GadAllah - Friday, April 12, 2019 5:33 PM -
0 Votes
Need help on powershell script for database restore.
To start with im not an expert on database and scripting for powershell. I found a powershell script for database restore over the internet. Some are added by me based on my research. The problem that ...Unanswered | 1 Replies | 501 Views | Created by brianlc - Thursday, April 11, 2019 5:29 PM | Last reply by Dedmon Dai - Friday, April 12, 2019 3:15 AM -
0 Votes
Best way to deploy maintenance plans across multiple nodes/clusters
Hello, Our current environment: 10 domains with no trust between them Each domain has atleast 1 MSSQL cluster Each cluster ...Proposed | 4 Replies | 625 Views | Created by Ro_vi - Wednesday, April 10, 2019 2:23 PM | Last reply by Dedmon Dai - Friday, April 12, 2019 2:57 AM -
0 Votes
exclude replicate values in query(?)
Hi, Im a basic beginner to SQL so this may be a very basic question that perhaps Im not wording correctly. I am left joining tables, the first table has an account numbers that has ...Proposed | 5 Replies | 742 Views | Created by champolino - Monday, April 8, 2019 8:56 PM | Last reply by Dedmon Dai - Friday, April 12, 2019 1:31 AM - Items 1 to 20 of 21183 Next ›
No announcements
