Answer Questions

• micronax update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget update statement is fine....check the datatype of cashnumber...is it int... if no ...does it contain non integer values.......basically check the data , as the statement is fine... I agree with what you say about isNumeric; I was kind-of posturing because I am not sure what actual di ...Show All

• fscarpa58 Line delimiter.

  Hi all. I have some problem. String is kept in format "aaaa\r\nbbbb\r\nc\tcc" in database When i trying to render a report(RS 2000) i take this result textbox : aaaa\r\nbbbb\r\nc\tcc ,but i want textbox: aaaa bbbb c cc Can you help me Thats actually what I ment :-D -Jens. Hi All I've found simple way to realize this feature. It turned out, that RS dont understand C# delimiter but understand VB delimiters . I've written custom code for impleting this thing Function ConvertString(ByVal value As String) As String value = value.Replace("\n", vbCr) value = value.Replace("\r", vbLf) value ...Show All

• CCam Converting date from string to datetime in data transfer task

  The source is a flat file with a column where dates are stored as: 07/12/2006 11:35am. In some cases the column is blank. I need to import this into a table with a datetime column. In the data flow task, I get the error that conversion b/w String and DB_Timestamp is not allowed. First question is why does SSIS think its a DB_Timestamp column Shouldnt it be DB_Date or DB_Time. Anyway, when I add a Data Conversion Task in the Data Flow, and cast to the source column to either DB_TimeStamp, DB_Date or DB_Time I get an error. Please help. What am I doing wrong. Asim. Hi Asim, Can you paste in the error you get from the data conversion transform If you open your flat file connection man ...Show All

• Tomasz24311 Migration to SQL Server 2k5

  Hi all, I have script written in SQL Server 2000. When i tried to migrate to SQL Server 2005, it is working fine in the SQL Server 2005 installed in Windows 2003 Server . System tables(syscolumns, sysobjects etc)are created in "Database->Tables->SystemTable". But when i tried to run in SQL Server 2005 installed in Windows XP , I'm facing the following problems. 1."The object 'CK_SavedSear_LastL_4B422AD5' is dependent on column'LastLoadedTime' "ALTER TABLE DROP COLUMN LastLoadedTime failed because one or more objects access this column" 2.Moreover none of the tables had been created in "Database->Tables->SystemTable". In both XP and 2003 Server, While installing, i ha ...Show All

• meoryou Copying my SQL Database to another server

  Hi guys, I have created a new SQL database (named “DB”) on my personal pc at home. I want to copy “DB” to my job’s computer, which works on a local net with SQL server. What should I do Thanks a lot, Aldo. Where can I see how to "detach" and "reatach" a dababase Hi ajliks, I would suggest , first you take a back up of your Database (Db) from your personal pc . Copy the back up file to a CD or some portable storage device. Copy it to your Job's computer. And the restore the database from there on to your SQL Server directly. This would be the easiest way to do it. Thanks & Regards Mathew Hi Mathew, thanks for anwering. I want to know how to make the SQL database copy. ...Show All

• vivek.athalye SSIS hanging in the middle of processing

  Hi, We have a problem importing the flat file data using SSIS into sql database. For some erroneous files the package is just hanging with out any activity (Disk Reads/sec, Disk Writes/sec, Page faults/sec, Workingset Memory counters are const when the package hung). The package is giving the following messages before it is hung. The column data for column "ServerName" overflowed the disk I/O buffer. An error occurred while processing file "M:\Tani1\APS-PRXY-02\APS-PRXY-02-ISALOG_20060621_FWS_001-2006062106.Log" on data row 1. The PrimeOutput method on component "Firewall Data" (6109) returned error code 0xC0202092. The component returned a failure code when the pipeline engine c ...Show All

• xxxmpsxxx Sql Server Replication

  Hi, I'm curious to find out is it possible to make a Multi Master-Multi Slave replication system with sql server 2005. I'm not very good at db's and I'm a bit lost with mirroring things and some other things. The main problem in my case is that masters are connected each other via internet which I have to prepare a asynchronus replcation system in this. Let me explain what I mean with an example. Let's say we have two servers one at USA and other UK. They are both masters and both slaves. When entering a data in USA, UK becomes the slave and replicate the data from USA and vice versa. I'm curious about to find out is this possible with SQL Server 2005 What are possible problems that can occur in this case (not hardware problems or server o ...Show All

• JTDDBA OLE DB Provider Oracle

  english: Hello, I have got a problem with the a linked server in SQL server 2005 (64 bit) to Oracle 8.0.5. (32 bit). Further details: The old existing SQL server 2000 (32 bit) has a linked server to Oracle 8.0.5. The works with the OLE DB provider from Microsoft. The new SQL server 2005 (64 bit) should also have a linked server to this Oralce database. I have installed the Oracle 8.0 clients on the new server. The connection to oracle works with the client tools from Oracle. But the SQL server 2005 couldn't connect to the oracle database. The error message from the SQL server sounds (translated form a german error message): A instance of the OLE DB provider "OraOLEDB.Oracle" for the linked server "xxxxxx ...Show All

• Rathish P S Report Viewer Problem

  Hi there, I hope someone can assist with this  My Report viewer takes ages to load then displays in the following format : localhost/WayneServer - / Monday, November 20, 2006 1:32 PM <dir> AW Monday, November 20, 2006 11:07 AM <dir> Data Sources Monday, November 20, 2006 11:44 AM <dir> export_UWCM Monday, November 20, 2006 11:06 AM <dir> Report Project2 Microsoft SQL Server Reporting Services Version 9.00.1399.00 This view exist in IIs, report manager and all previews I wish to view the HTML versions.   This is the debug information for the error. 'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32 ...Show All

• BhuttCrackSpackle ASP 3.0 Record is getting saved twice.

  Hello All, I am facing this unusual error. In My ASP Page I am submitting the Page and after submitting the form I am calling another ASP page, which contains sql command to insert the record. My Problem is when I am submitting the Form. Record is getting inserted twice with same values. What is the cause of this problem as I am facing this problem in every form. With Regards Sunil Dutt yes, the problem was because the Javascript function formSave is called from the submit button and in submitform the form is submitted again. So the form was getting submitted twice just comment the submit line of the javascript or call the Java Script function FormSave from the link instead of Submit Butto ...Show All

• Scott Ha Problems with Win2000 connecting

  I have a SQL Server 2005 in use locally. I'm trying to connect a remote location. Using WinXP Pro, I can connect just fine. However, when I try the same connect string on a Win2000 or WinXP Home computer, I cannot connect. All these computers are plugged into the same network (hub even). I've updated all the computers to MDAC 2.8. To connect, I open the ODBC Administrator in Windows, enter my SQL Server IP and instance name: xx.xx.xx.xx\abc, change the network library to TCP/IP and enter my username and password. This works great on the WinXP Pro machines. This is the error I get on the other machines: [Microsoft][OBBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()). [Microsoft][OBBC SQL Server Driver][TCP ...Show All

• danni123 Combining Multiple Subreports in One Report

  Hi, I am trying to combine 5 different reports in one report. I am using them as subreports. The problem is, they are all different formats. For example, one of the report is rendered as 3 column report, and page length and width vary from report to report. When I tried to use table and list for this, my program crashed and closed my visual studio. When I use rectangle for it, then shows me the report but report is no more multiple column and page sizes were also different from the one I did in the report. Please guide me how to combine all these reports and not loose the formatting of the reports. Thanks, -Rohit Multiple column layouts are currently not supported inside subreports, only as a ma ...Show All

• StumblingInTheDark Maintanance Plan and xp_delete_file

  Hi there, i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs. I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin) EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt' System ist SQL Server 2005 SP1 German Any ideas Thanks in advance regards tobias As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above. The path needs to end ...Show All

• jhidey How to Validate Parameters

  Hi, I am designing a report using SRS 2000. I want to validate parameters before executing the query. Suppose if user gives a random number for parameter (say Emp ID), i want to display a error message in a textbox "There are no records for the given employee ID" and stop executing query to display employee details in the table. I tried using Visible expression for table IIF(Fields!EmpID = "", False, True). But when I run the report with a random number, an error populated saying "You cannot query a record for no data..." Please suggest me a work around. Regards, In any data control you can set the NoRows property which will display a defined message (in the property) instead of the data con ...Show All

• UnKnown Nick Multiple Executions of same package using DTEXEC

  Hi, I have a file-deployed package which I need to call N times at once using DTEXEC.  When I attempt to execute N instances of the package, the second instance doesn't execute.  I can execute different packages at the same time, but never the same package more than once.  Does anyone know how to get this scenario working   Just to clarify a bit more - I can call the package as many times as I like as long as I wait until the previous run of DTEXEC is finished.  Please help! Thanks, dcb99 How about writing a .NET console app to execute the packages I have accomplished similar results but calling the package from another package. You could use a Foreach loop; ...Show All