Kalman Toth dizileri
Found 20 threads
-
0 Oylar
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 ...Yanıt | 8 Yanıtlar | 32537 Görünümler | Created by FrenkAtMicrosoftForums - 19 Mayıs 2008 Pazartesi 18:55 | Son Yanıt ile migueLeugim - 20 Ocak 2020 Pazartesi 20:02
-
0 Oylar
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 ...Yanıt | 8 Yanıtlar | 7396 Görünümler | Created by GIS Jim - 10 Eylül 2015 Perşembe 21:29 | Son Yanıt ile Arulmouzhi - 17 Ocak 2020 Cuma 16:07 -
0 Oylar
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.Yanıt | 5 Yanıtlar | 10866 Görünümler | Created by Swedha - 20 Kasım 2012 Salı 10:37 | Son Yanıt ile Arulmouzhi - 17 Ocak 2020 Cuma 15:50 -
0 Oylar
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 ...Yanıt | 3 Yanıtlar | 3926 Görünümler | Created by skc_chat - 4 Aralık 2014 Perşembe 08:48 | Son Yanıt ile dani671 - 16 Ocak 2020 Perşembe 23:15 -
0 Oylar
exec () AT LikedServer Failing
DECLARE @SqlStr VARCHAR(Max) SET @SqlStr = 'DECLARE @SQL varchar(max) SET @SQL = '' CREATE SCHEMA '' ...Yanıt | 5 Yanıtlar | 5100 Görünümler | Created by naveej - 17 Eylül 2014 Çarşamba 13:41 | Son Yanıt ile Sampath reddy- SR SQLSERVER Administrator - 19 Aralık 2019 Perşembe 09:46 -
2 Oylar
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 ...Yanıt | 16 Yanıtlar | 119433 Görünümler | Created by am Looser - 21 Nisan 2012 Cumartesi 08:39 | Son Yanıt ile I might have found the solution - 13 Aralık 2019 Cuma 03:26 -
8 Oylar
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 ...Yanıt | 64 Yanıtlar | 79560 Görünümler | Created by fdc2005 - 9 Ağustos 2006 Çarşamba 23:18 | Son Yanıt ile Erland Sommarskog - 13 Kasım 2019 Çarşamba 14:07 -
0 Oylar
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 ...Yanıt | 3 Yanıtlar | 11440 Görünümler | Created by Nikki Sixx - 20 Ekim 2008 Pazartesi 00:47 | Son Yanıt ile jp540 - 24 Ekim 2019 Perşembe 13:05 -
4 Oylar
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 ...Yanıt | 7 Yanıtlar | 15212 Görünümler | Created by Richard L Mann - 2 Şubat 2012 Perşembe 21:18 | Son Yanıt ile Muckinabaht - 17 Ekim 2019 Perşembe 09:22 -
5 Oylar
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. ...Yanıt | 11 Yanıtlar | 23944 Görünümler | Created by John Couch - 8 Mayıs 2013 Çarşamba 00:36 | Son Yanıt ile EricPeeg - 16 Ekim 2019 Çarşamba 15:20 -
0 Oylar
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 ...Yanıt | 9 Yanıtlar | 42437 Görünümler | Created by AngelinaPerez - 25 Aralık 2007 Salı 19:29 | Son Yanıt ile Melski Albayda - 6 Eylül 2019 Cuma 04:24 -
5 Oylar
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 ...Soru | 22 Yanıtlar | 40879 Görünümler | Created by MarkosP - 19 Temmuz 2010 Pazartesi 14:34 | Son Yanıt ile Kamillo Kramulus - 1 Eylül 2019 Pazar 19:24 -
8 Oylar
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 ...Yanıt | 17 Yanıtlar | 63596 Görünümler | Created by Chaitanya Dabholkar - 20 Şubat 2008 Çarşamba 12:47 | Son Yanıt ile LucasRibeiro2601 - 8 Ağustos 2019 Perşembe 11:16 -
16 Oylar
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 ...Önerilen Yanıt | 13 Yanıtlar | 48839 Görünümler | Created by brgnewman - 4 Şubat 2013 Pazartesi 08:01 | Son Yanıt ile lastpyro - 5 Ağustos 2019 Pazartesi 06:52 -
0 Oylar
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; ...Yanıt | 9 Yanıtlar | 21627 Görünümler | Created by midway11 - 10 Ekim 2009 Cumartesi 17:54 | Son Yanıt ile 4lejandro - 31 Temmuz 2019 Çarşamba 14:42 -
1 Oylar
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 ...Yanıt | 18 Yanıtlar | 22632 Görünümler | Created by asitti7 - 23 Mayıs 2010 Pazar 21:17 | Son Yanıt ile scott_morris-ga - 29 Temmuz 2019 Pazartesi 12:50 -
0 Oylar
Calculate XIRR in T-Sql
= 0.0001 BEGIN DECLARE @t FLOAT SET @t = @irrPrev SET @irrPrev = @irr SET @irr = @irr + ...Yanıt | 6 Yanıtlar | 17378 Görünümler | Created by Maulik A. Dusara - 6 Ağustos 2010 Cuma 07:43 | Son Yanıt ile Anil Nagthane - 9 Temmuz 2019 Salı 09:50 -
5 Oylar
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 ...Yanıt | 14 Yanıtlar | 103232 Görünümler | Created by ciaotz - 21 Ekim 2008 Salı 11:06 | Son Yanıt ile stevensrf - 1 Temmuz 2019 Pazartesi 22:01 -
0 Oylar
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 ...Yanıt | 6 Yanıtlar | 37306 Görünümler | Created by tress - 3 Aralık 2010 Cuma 08:57 | Son Yanıt ile Stormer67 - 1 Temmuz 2019 Pazartesi 14:27
