Answer Questions

• Luke_82 Error using Execute Package Task

  I'm trying to run a package from another package using Execute package task - I'm getting the error: Error: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run. . I have Delay validation on the child package. Any other suggestions Thanks I am perhaps wrong about this but I don't think setting DelayValidation=TRUE on the package preven ...Show All

• mendez_edd failure in starting the process for the user instance

  High everybody, I have a set of winforms (.NET 2.0 assemblies) ( 6 total ) that each tries to open a connection to the same Database file using the same connection string. In the connection string, UserInstance is set to true. If each winform is started manually after opening the session on the computer, the connection to the database performs well for every winform. If the same winforms are automatically started at the opening of the u ...Show All

• JonTec string to int????

  Hi, I need to convert a string to an integer. I've tried using CAST and CONVERT but the problem is that my data also contains alphanumeric characters, in wich case I want the result of the conversion to be 0. The above commands gives an error if the data is not pure numeric. What can I do Create a UDF to do this and use isnumeric to check before convert. Hi Germn, ...Show All

• Toomy Ling Serious limitation in SQL server installation

  I am trying to install the server in a non-system drive.  I have to install the server in a diffferent folder like (E:) instead of the default C: due to existing partition that I have to continue to have (due to reasons that include security). Even though I selected this drive and every thing else (Program Files etc) the same, the install program still asks for over 2 GB on C drive. I checked each of the install options and ...Show All

• Renate Data Import & Export Error in DLL

  : Microsoft SQL Server ------------------------------ 由于以下 ， 此向 : 有 助信息， : http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476 ------------------------------ 其他信息: DLL 中出 (异常 自 HRESULT:0x800401F9 (CO_E_ERRORINDLL)) (Microsoft.SqlServer.DTSRuntimeWrap) ------------------------------ 按 ...Show All

• Fabricio11 Remote Connection problem on MS SQL 2000

  Hello, First, I want to say I read all threads similar this thread and I couldn't solve problem. My firewall is always off when I tried to connect remotly to SQL Server. I opened 1433 port from my router's configuration page and forwarded it to 10.0.0.4:1433. When I started SQL Server service and checking "netstat" with "-na" paramters. It shows only one row as "TCP - 0.0.0.0:1433 to 0.0.0.0:0". What "0.0.0.0" means and why foreign ad ...Show All

• Yan Y. Query Issues......help!

  SELECT tblWatchInstance.RepairNumber,tblWatchInstance.Comments,tblWatches.OwnerFName,tblWatches.OwnerLName FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.Watch_Key WHERE tblWatches.OwnersLName LIKE '%son' AND tblWatchInstance.ReapirNumber = (@RepairID)", myConnection for some reason when i added the Where clause, it stopped working and i dont really know why......Do any of you great individu ...Show All

• Greg H Problem with uninstalling SQL Server 2005

  Hi all, I had installed Sql Server 2005 Express Edition Beta 2 on my computer. Now i would like to upgrade with SQL Server 2005 Express edition. It is noticed ( http://www.microsoft.com/france/msdn/vstudio/uninstall/default.mspx ) that i have to uninstall all previous version following a specific order. In my Add/Remove program i have : 1 -Microsoft .Net Framework 2.0 Beta 2 -SQL Server 2005 Express Edtion Beta 2 3 -S ...Show All

• Drakkaris What interface does Management Studio use?

  Hi, Does anyone know what interfaces Management Studio use It does seem to retrieve information about Server/Database objects without the performance issues that SMO suffers from How does it do it Regards, Joginder Nahil www.starprint2000.com Actually, if you can't get rid of the calls to Prefetch then the easiest way to get better performance would be to just create a new Server object on the same connection, set the Default i ...Show All

• thn How reliable is Microsoft's type4-JDBC driver for MsSQL Server????

  Hai Friends,     I am using MsSQLServer in the backend and java in the front-end.      How reliable Microsoft's type4-JDBC driver for MsSQL Server     I am very afraid as its only a beta version and version 1.0 and my project is a commercial one.   Is there any other better type4-JDBC driver for MsSQLServer available -which i can get for no cost-free of cost.   ...Show All

• Lweek <Unsupported Data Type> ??

  I have a problem in a store procedure.... the field isn't updated or touched...it's only readed with a nested select... In the grid pane is showed :<Unsupported Data Type>  as this.. http://www.base2.it/img/sql3.JPG If I force a cast  like this.. CAST(derivedtbl_1.Descrizione AS varchar(255)) the value is showed... tha field in the original table source is definded ...Show All

• rosapdx Linked measure groups

  Hi, I'm trying to manage linked measures group with AMO. I want to create a new cube with a linked measure group. I have a problem that I don't understand. The error I receive (I don't paste the real message because my installation is in italian) tells that the measure group I added doesn't have relations to the dimensions... The code I use is this: // Get the measure group to link from an existing cube MeasureGroup MGToLi ...Show All

• Adeel Problems with Identity Specification - deleting rows

  First of all, I'm new to the forums, and I'm still getting started with VBEE and SQL. I'm building a simple Windows Application that has a SQL Database with three tables, related to each other. In all of them I need to set one column as a simple index for the rows (1, 2, 3... etc), to work as a PK and relate to the other tables' FKs. I've set the property Identity Specification of the column to Yes, and added some rows of data for testing ...Show All

• etaylor SSIS and COM

  Dear all, Does anyone know if exists any COM wrapper provider for SSIS TIA SSIS is exposed as a series of COM interfaces that have managed wrappers. Are you looking to use SSIS from a COM environment or a managed environment enric12879 wrote: Yes, I've been thinking over the possibility to call SSIS packages from Visual Basic 6.0. But I haven't found relevant information about that. ...Show All

• Mike Carter MS error: 17194

  I cannot use sql connection. This is my connection string 'Conn.Open "Provider=SQLNCLI;Database=dbname;Server=.\\MSSQLSERVER;UID=username;PWD=test123;" The error message appears on browser is Microsoft SQL Native Client error '80004005' Client unable to establish connection due to prelogin failure /Connect.asp, line 8 in SQL server ERRORLOG, it shows Error: 17194, Severity: 16, State: 1. The server was unable to load the SSL provider library n ...Show All