Kalman Toth's threads
Found 20 threads
-
9 Votes
Why SSIS
Why SSIS? Is there a need for it?? The question is where and in which circumstances, isn't it?? I have been ...Answered | 30 Replies | 16222 Views | Created by rixol - Friday, December 5, 2008 5:21 PM | Last reply by ideras.com - Saturday, February 1, 2020 6:28 AM
-
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 | 31014 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 | 4880 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 | 8666 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 | 2407 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 | 3632 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 | 105087 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 | 72627 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 | 9639 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 | 12967 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 | 21156 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 | 39075 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 | 37471 Views | Created by MarkosP - Monday, July 19, 2010 2:34 PM | Last reply by Kamillo Kramulus - 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 | 61377 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 | 40061 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 | 19025 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 | 20535 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 | 15653 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 | 93937 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 | 32967 Views | Created by tress - Friday, December 3, 2010 8:57 AM | Last reply by Stormer67 - Monday, July 1, 2019 2:27 PM
