Answer Questions

• vtortola Unknown error using HTTP pump on a different server than the Analysis Services server

  Hello, I get an unknown error in the event log when trying to access AS2005 from Excel 2003 SP1 through IIS on a different server than Analysis Services: The description for Event ID ( 10 ) in Source ( MSOLAP ISAPI Extension: \\ \C:\Inetpub\wwwroot\Heloc\msmdpump.dll ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: . The event category is (269). I set up the server exactly as specified in Technet ( http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx ) except ...Show All

• Steve Roggow DataGridView: How can I update data in a DataGridView?

  Hi guys, Im having some issues understanding how to manipulate the data that is in my DataGridView The View is created by calling a stored procedure from VB code and works on two tables: people pswds The columns required from Table people are (personid, userid and sort). The columns required from Table pswds are (comment and activeuser). Table people is parent table while pswds is the child table. The Relationship works between both tables using primary keys from both tables: which is called personid in both. The link below shows the Relationship Diagram for the Two tables: http://cale.csd.anglia.ac.uk/~csd03ib/images/RelationTables.bmp The code for the Stored procedure can be found at the follow ...Show All

• Paul Tew Encrypt Column

  Is there a way to encrypt one column of data in a table in SQL Server 2000 Thanks! -Dave Yes, there are third party products that allow you to do that. An Internet search should bring up some. You could also write your own extended procedures for performing encryption/decryption. SQL Server 2000 does not have any builtin encryption capabilities. SQL Server 2005 does have such capabilities. Thanks Laurentiu ...Show All

• Xelestial I need help with a SQL Query

  I know that there's a lot of you out there that are really good at Sql Queries. Hopefully, one of you will have pity on me and clue me in. I am working with a Visual Studio 2005.net VB application accessing SQLServer 2005 and SQLServer Express databases. I am using a sql query with ado.net data adapter to return data to a grid bound to the data adapter. My problem is that there is data in the SQL table stored as Bigint data types, that I need to divide by another integer and return as a double precision number. For example, part of the Sql Statement looks like: " InvStock.QuantitySold / NumPeriods AS 'AvgUnitsSold', " It works except for the fact that it returns an integer and truncates the decimal points. Is th ...Show All

• metalpunker How do I transfer "My Subscriptions"?

  I am an administrator in Reporting Services 2000/2005 (mixed environment) and have set up several report subscriptions.  I see all of the subscriptions under "My Subscriptions" which provides an easy way to see and manage all the subscriptions. Now we have a few other administrators on my team, and they also want to see all the subscriptions in the environment, but when they click "My Subscriptions" their list is empty.  I have set them up with the same security role as me, but this doesn't seem to matter. How can I provide a way for the admins to see all subscriptions on all reports in the report server, even if each subscription may be set up by a different user Thanks Kory I was ...Show All

• StevenR2 SQLServer uninstall

  Have uninstalled SQL Server many times but have message at startup (Your SQL Server installation is either corrupt or has been tampered with (Unknown package id). Please uninstall and re-run setup to correct this problem. I can not get the reinstall to go as i get a maessage that SQL Server is already on my computer. I am no guru and need simple help on this issue. Did a regedit and deleted wrong thing and had to reinstall XP again to run computer. I am just in a mess. Any help would be appreciated I finally got it figured out but had to get rid of things from the command prompt. Not all was in add and remove list. Thanks for trying. Jack, do any SQL entries sh ...Show All

• Catalin Zima Error -2147024809 An error has occured on the computer running IIS

  I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt. Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ... Error code: -2147024809 zo See what error message in the runtime you have captured. Thanks. I had the same error number in a custom build Powerpoint wizard when you failed to enter a filename of a background picture for the front page. In general is seems to indicate a wrong or invalid parameter in a system call. Complete error message was: "Err. -2147024809- Description: The specified file wasn't found." ...Show All

• ivanchain CSV Import with Column Headers

  It would seem when selecting this option ( "Column names in the first data row") for a Flat File Source that the actual column header name is not used to determine the column to get the data from but rather the column index is used. Is there any way to get SSIS to use the actual column header name for reference May be the answer to the first question will help with the second. I've got the Flat File Source redirecting rows for both Error and Truncation. It would also seem that when a column is missing from the csv file no rows get redirected as an Error and no rows get imported and at no point is any error thrown. Is there a way to get SSIS to throw an error that a column is missing Thanks, Jeff ...Show All

• naiad memory leaking?

    Hi all, i am using windows xp sp2 and sqlserver 2002. i try to import dataset from excel with 300 000 rows data and excel file size is about (5MB). first I create a table in sql database. then i import data from excel to table in sql database by using following step. 1.  I using Data Transformation Service import/export wizard from SQL Server Enterprise Manager to import data 2.  During the wizard i choose data source = Microsoft Excel 97-2000, and choose the particular file. 3. choose the sql server and start import. Notice from Windows Task Manager sqlserver.exe 's mem Usage from 20M rinse to 43MB. after 1 hours check it again, found the mem usage by sqlserver is "NO DROP!!!" still 43MB. The ...Show All

• Paul Stringer Cannot shut down VS after using report designer

  Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP Myself and a number of colleagues are having the same error come up. We are only able to shutdown the visual studio by going to task manager. Still trying to find the cause, but if anyone else knows anything more For me, the only constant is that I am working ...Show All

• DarthFahza Stop processing cube remotely

  Hi, Can I stop remotely processing cube Processing cube is started on one machine, and I want to stop processing from another Thanks I understand you, but I can't find how I can do it. I can't find this activity in Activity Monitor. Not sure I understood your response. You should be able to cancel commands on any active sessions on the server from any machine. This should satisfy your original requirements. If Activity Monitor isn't helpful for you - you can code this yourself, by first doing DISCOVER_SESSIONS schema rowset and finding the session you want to cancel, and then issuing <Cancel> command. Ye ...Show All

• Bendermon Sql server 2005 trial edition

  Hi , i am trying to install Sql server 2005 trial edition , There were 3 types of files for download Self-extracting executables: X86 Executable X64 Executable IA64 Executable Didnt know for which they are applicable , i have a windows xp professional SP2 I downloaded "X86 Executable" . Then tried to run the setup.exe file . It says installing Sql Server 2000 but i want Sql SERver 2005. I have checked couple of times and am pretty sure that i have downloaded sql server 2005 trial version and not the 2000 version. can some one help me Thanks red If you run the downloaded package it will instal SQL Server 2005. X64 and IA64 packages are SQL Server 2005 for 64-bit platforms x64 for AM ...Show All

• PentagonMaster execution package task-SOS

  hello to every body.. well i have a problem.. well i created a package the task of which is to update thedimensions and the fact tables from the tables of source. i created a configuration file with all the parameters that are nedded (connections managers; parameters of packages).this config file will include all the paremeters need for the execution of other packages In that package i call an other package (execution package task). this package normally will take the parameters of the parent package isn't it (i put the parameters of this package to the config file of the parent package). i must also note that for the second package called there is also a package... i must also note that i have 2 DWHs (a and b) for testing. ...Show All

• William Lowers SQLDMO SQLExpress

  I get the impression that I wont be able to programatically interact with SQLExpress in the same way as I can with say SQL2000. I've created a little app that lists all the connections available on my LAN but because SQL Express doesnt support SQL Agent I cant list any SQL Express instances. Is there any workaround in .NET Hi, youl wil have to make sure, that -SQL browser is running -You did not block the port 1434 vai firewall -You did not hide the instance from the network (That is a separate setting in the network configuration) See this thread for more details: http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/fb913f622be302d HTH, Jens K. Suessmeyer. --- ht ...Show All

• ashk1860 Best practice configuring Visual Studio Solution for .SDF databases

  Hello, In our company we haven't tamed Visual Studio yet for the part of configuring the application database. Therefore I was wondering if there is someone that can give me hints or clues on what the best practice is for configuring Visual Solution to handle an SDF database (SQLCE 3.0). I have search a bit on the internet and this forum, but couldn't find a decent how-to or best practices guide that copes with this specific problem. As a matter of facts, i am also curious for guidelines and tips on the best way to configure and manage SQL Server databases under Visual Studio. I guess (read as hope ) that the configuration of a mobile and full blown database will have some overlaps somehow. I've found the Database Proj ...Show All