Kalman Toth's threads
-
0 Votes
Text Qualifier in SSIS designer for Flat file source
Unlike SQL Server 2000 DTS, SSIS Flat File Connection Manager Editor does not provide available list of Text ...Answered | 8 Replies | 29058 Views | Created by FrenkAtMicrosoftForums - Monday, May 19, 2008 6:55 PM | Last reply by migueLeugim - Monday, January 20, 2020 8:02 PM
-
0 Votes
Replace multiple spaces with one space
i have searched for other theads on this but not been able to make them work. i have several fields that have multiple spaces betweent the ...Answered | 8 Replies | 1702 Views | Created by GIS Jim - Thursday, September 10, 2015 9:29 PM | Last reply by Arulmouzhi - Friday, January 17, 2020 4:07 PM -
0 Votes
Need an Alternative for Case statement for my Stored proc in SQL server 2005
Hi, I need an Alternative for Case statement in SQL server 2005, as my stored procedure creates a dynamic select query. Thanks in Advance.Answered | 5 Replies | 6851 Views | Created by Swedha - Tuesday, November 20, 2012 10:37 AM | Last reply by Arulmouzhi - Friday, January 17, 2020 3:50 PM -
0 Votes
how to communicate sql server with NOSQL plateform
I want to know how will communication and data synchronization would be done if my application team will think of implementing NOSQL along with SQL Server. Also how will ...Answered | 3 Replies | 902 Views | Created by skc_chat - Thursday, December 4, 2014 8:48 AM | Last reply by dani671 - Thursday, January 16, 2020 11:15 PM -
0 Votes
exec () AT LikedServer Failing
DECLARE @SqlStr VARCHAR(Max) SET @SqlStr = 'DECLARE @SQL varchar(max) SET @SQL = '' CREATE SCHEMA '' ...Answered | 5 Replies | 2184 Views | Created by naveej - Wednesday, September 17, 2014 1:41 PM | Last reply by Sampath reddy- SR SQLSERVER Administrator - Thursday, December 19, 2019 9:46 AM -
2 Votes
The Microsoft Access database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly. If '' is not a local object, check your network connection or contact the server administrator.
Hi , I am trying to access the excel from sharing drive and having permission. But i am getting below this error: The Microsoft Access ...Answered | 16 Replies | 92293 Views | Created by am Looser - Saturday, April 21, 2012 8:39 AM | Last reply by I might have found the solution - Friday, December 13, 2019 3:26 AM -
8 Votes
OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.
Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire ...Answered | 64 Replies | 66459 Views | Created by fdc2005 - Wednesday, August 9, 2006 11:18 PM | Last reply by Erland Sommarskog - Wednesday, November 13, 2019 2:07 PM -
0 Votes
SQL Server 2005 Express Edition SP2 Update failed. KB 921896
Hi, i just done a MS Windows Update and this one keeps failing, any ideas? Posted are two log files both found in ...Answered | 3 Replies | 8421 Views | Created by Nikki Sixx - Monday, October 20, 2008 12:47 AM | Last reply by jp540 - Thursday, October 24, 2019 1:05 PM -
4 Votes
How to collapse Object Explorer Tree in Management Studio
Newbie seeking answers. I switch between servers constantly in my work. After a while, the tree got openned up all over the place, and i have to focus really hard to see ...Answered | 7 Replies | 11254 Views | Created by Richard L Mann - Thursday, February 2, 2012 9:18 PM | Last reply by Muckinabaht - Thursday, October 17, 2019 9:22 AM -
5 Votes
Powershell from a SQL Agent Job (SQL Server 2012)
run with it. No problem. Only when executed from the SQL Agent Job does it fail with invalid path. John M. ...Answered | 11 Replies | 19470 Views | Created by John Couch - Wednesday, May 8, 2013 12:36 AM | Last reply by EricPeeg - Wednesday, October 16, 2019 3:20 PM -
0 Votes
ERROR: Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server"(null)"
Hi, I have been trying to export data from a Microsoft Excel 2007, Tester.xlsx to a SQL Server 2005 table as : SELECT * INTO CUSTMAS FROM ...Answered | 9 Replies | 36880 Views | Created by AngelinaPerez - Tuesday, December 25, 2007 7:29 PM | Last reply by Melski Albayda - Friday, September 6, 2019 4:24 AM -
5 Votes
Windows Server Backup fails when SQL VSS Writer service is running
Hello. On one of our SQL servers, we have SQL Server 2008 Express installed. Whenever is the "SQL Server VSS Driver" service running, backing up the computer with Windows Server Backup will ...Unanswered | 22 Replies | 35544 Views | Created by MarkosP - Monday, July 19, 2010 2:34 PM | Last reply by Win10-is-adware - Sunday, September 1, 2019 7:24 PM -
8 Votes
How to create linked server to Access 2007 accdb file?
How does one create a linked server to an Access 2007 (accdb) file? I am aware that to create one to a mdb file, the code would be - EXEC sp_addlinkedserver @server = 'SEATTLE ...Answered | 17 Replies | 59461 Views | Created by Chaitanya Dabholkar - Wednesday, February 20, 2008 12:47 PM | Last reply by LucasRibeiro2601 - Thursday, August 8, 2019 11:16 AM -
16 Votes
Line Break Issue when Copying from SSMS 2012 & Pasting into Excel
Bit of a weird issue here... With SSMS 2008 R2, when I copy Query Data and paste it the data in Excel, it pastes completely fine into Excel (rows & columns all line ...Proposed | 13 Replies | 35540 Views | Created by brgnewman - Monday, February 4, 2013 8:01 AM | Last reply by lastpyro - Monday, August 5, 2019 6:52 AM -
0 Votes
PMT Calculation with T-SQL
Hi there, I am having this issue where I have to calculate the PMT of a lon with T-SQL script. the Excel formula to calculate such a thing is; ...Answered | 9 Replies | 17246 Views | Created by midway11 - Saturday, October 10, 2009 5:54 PM | Last reply by 4lejandro - Wednesday, July 31, 2019 2:42 PM -
1 Votes
how to calulate next monday date value
i am trying to calculate the date available in flydate column (is a datetime data type column) to next monday, so presently i am doing this below way(it is working fine but seems to be i am ...Answered | 18 Replies | 18814 Views | Created by asitti7 - Sunday, May 23, 2010 9:17 PM | Last reply by scott_morris-ga - Monday, July 29, 2019 12:50 PM -
0 Votes
Calculate XIRR in T-Sql
= 0.0001 BEGIN DECLARE @t FLOAT SET @t = @irrPrev SET @irrPrev = @irr SET @irr = @irr + ...Answered | 6 Replies | 14527 Views | Created by Maulik A. Dusara - Friday, August 6, 2010 7:43 AM | Last reply by Anil Nagthane - Tuesday, July 9, 2019 9:50 AM -
5 Votes
INSERT...SELECT command with a timestamp column
Hi, I am trying to do an insert select command with a timestamp column. I ran the code : INSERT into Table1 SELECT * from Table2 where ...Answered | 14 Replies | 87551 Views | Created by ciaotz - Tuesday, October 21, 2008 11:06 AM | Last reply by stevensrf - Monday, July 1, 2019 10:01 PM -
0 Votes
SSRS Connection Issues
Hi, Hope someone can help me with an issue I have beem struggling with over the last few days. I am have installed SSRS 2008 R2 on server running Windows Server 2008 R2 ...Answered | 6 Replies | 29923 Views | Created by tress - Friday, December 3, 2010 8:57 AM | Last reply by Stormer67 - Monday, July 1, 2019 2:27 PM -
5 Votes
SqlBulkCopy - Received an invalid column length from the bcp client ... ???
Hi I'm stumped by the following exception message: Received an invalid column length from the bcp client for colid 19. The last column ...Answered | 7 Replies | 77965 Views | Created by I.W Coetzer - Monday, November 9, 2009 12:18 PM | Last reply by scott_morris-ga - Tuesday, June 25, 2019 12:49 PM - Items 1 to 20 of 19405 Next ›
