Answer Questions

• TheBlackNoodle sqlexpr.exe is not a valid win32 application, I downloaded the sql express 2005 edition when i click on exe file. I receive a

  I am using a windows xp sp 2. I have visual web developer 2005 express edition. .net Framework 2. but when i downloaded the sql 2005 express edition. when i click on the sqlexpr.exe. I receive a message " sqlexpr.exe is not a valid win32 application". just to try I downloaded the framework 2. for win32 , when i click on the exe file I receied the same message. Well someone help me please with the sql server. i have alm ...Show All

• fuurin modify procedure sys.sp_datatype_info

  Can we modify the sp_datatype_info stored procedure to return datatypes >=3 only in sql server 2005 Is it possible with SQL Server 2000. If it is not possible to modify/drop the procedure, is it possible to change the name resolution logic to be able to call the procedure in another (for example dbo) schema Any other possible way to achieve this Hi Umachandar, My objective is to modify sp_datatype_info to ...Show All

• Mal Hornsby How to avoid having locked tables during update in sql server 2005?

  We are running a shopping mall in Korea and got a database including a table of 4 million product prices, which is to be updated hourly basis.  Updating 4million records requires at least 10 minutes to complete. During the update, our shopping mall exposed to customers does not respond quickly in fact very very slowly and we investigated and found out that many tables of SQL database during the update were being locked.  As you know, s ...Show All

• NeelTiwari create tables and insert data in sql server mobile on dekstop

  Hello (sorry my bad english, im brazilian) I was using Visual Studio 2003 and SQL Server CE 2.0 for C# mobile applications. The .sdf database were created in the emulator or in the mobile device itself using Query Analizer. The application developed need some initial data to run, and this data is obtained executing one service that reads a postgree database, and insert the data in the SQL CE database of the mobile device. But, given the si ...Show All

• sbondale SSIS Package runs in BI but not VB.Net

  I have a solution with 2 projects: Startup project is VB.net the other is a BI project with an SSIS package.  If I right click on the SSIS package in BI and choose execute the package works flawlessly.  No warnings, no errors, no nothing.  IF I try to execute the same package in VB.net using the following code: Dim dtsPkg As New Package Dim dtsApp As New Application Dim events As IDTSEvents Dim Res As DTSExecResult d ...Show All

• pattinyl Customize Error Messages

  Is there a way to customize the error messages returned from SSRS2005 I do not want error messages like "Access deined for <computername>\<username>' But a more user friendly message returned. How can that be done Thanks. Try this... http://msdn2.microsoft.com/en-us/library/ms153616.aspx The solution may lie in the ASP.NET programming. Another thing to try is to modify the error pages in the IIS ...Show All

• RIHARD D ROBERTS Reading from a XML Source

  I am trying read certain attribute from a XML Source based on a particular attribute. My XML source has the following Structure:<Database ID = "1" Source = "ABC" ></Database><Database ID = "2" Source = "ABC" ></Database><Database ID = "3" Source = "DEF" ></Database>. I would like to fetch the list of IDs filtering upon Source = "ABC". ...Show All

• David McC How to get a handle of my queries

  Does anyone knows of a tool that will help me manage my queries I have 100's of them and all scattered. On my PC at home, some of them on my laptop, some of them at work, some in memory sticks. Then, when I need them I can't find the one I'm looking for so I end up writing the query again. Any ideas What do you mean by "snippets" You're right, in SQL Management ...Show All

• Kevin LZJ problem with custom conflict resolution

  Hi Well.. I implemented the business logic handler. It was registered successfully and my table was changed to use this business logic. Below the part of the code I use: public override ActionOnUpdateConflict UpdateConflictsHandler(DataSet publisherDataSet, DataSet subscriberDataSet, ref DataSet customDataSet, ref ConflictLogType conflictLogType, ref string customConflictMessage, ref int historyLogLevel, ref string historyLogMessa ...Show All

• Macrop Could not load file or assembly ADODB, Version=7.0.3300.0

  I have an application broadly deployed (about 10 computers). As of yesterday, two of these computers are unable to start the application, and failing with the error below. All other computers run the application just fine. System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified ...Show All

• nbaubant Bug? Err Rows Not Filtering on truncation in delimited file types

  I have run into a situation where my file will just error out if the output row is smaller then what is found in CSV file, (in between the "quotes") even though I have clearly specfied redirect bad rows / truncated rows. This is only the case with delimited file types, fixed lengths and xml errors filter fine. Also, if I add a space to the very beginning of the CSV row, it will filter the truncated fine, it is only when I have more spaces/text i ...Show All

• ESTAN suppress the display of a txt box when null

  I have a text box in a list, which i only want to display if it is not null. How can i do this in reporting services. thx la Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. That's all You must put in the value the expression: = IIF(CSTR(Fields!EvaluatedField)="", "", "The Title") I hope i ...Show All

• OfficeDeveloper Help! - Error in moving data from AS400

  I have a process that simply copies data from a table on an AS400 to SQL Server. This process executes fine until it gets to around 44 million rows copied out of 48 million rows in the source table. At this point, the process exits with the following error messages: The attempt to send a row to SQL Server failed with error code 0x80004005. The ProcessInput method on component "SQL Server Destination" (40) failed with error code 0xC02020C7. Th ...Show All

• Tilak Stepping over the line

  I'm running both SQL 2000 and SQL 2005 on the same server. I got this informational message when running a replication job in SQL 2005. It references the SQLAgent of SQL 2000 instance and says it needs to be upgraded to SQL 2005. Log Windows NT (Application) Source SQLAgent$My2000Instance Category Job Engine Event 1073742027 Computer AMWA-011605 Message SubSystem Message - Job 'MyJobRunninginSQL2005' (0xF6BA7BF3BB3EAD42BF281CA1CA3 ...Show All

• SGMX SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All