Answer Questions

• Yudy Sync will work only 1 time.

  I am really stuck on this, if anyone has some insight into this problem any help would appreciated... I'll try to explain what is happening the best I can: We have a server running Windows Advanced Server 2000 (SP4) w/ SQL server 2000 (SP3) (from now on Server A). I have a publication on this machine with dynamic filters (Changing the HOST_NAME()). The publication is sending the snapshots to another machine (desktop machine). The Mobile agent is in the same machine as the snapshots. The mobile application is syncing fine when hitting Server A. The sync is done Asynchronously. Then we have Server B. Running Windows Server 2003 (SP1) w/ SQL 2000 (SP4), same publication w/ dynamic filter however the snapshots and the mobile agent a ...Show All

• yazoox Exceptions in Data Flow Scripts

  What is the "correct" way of dealing with exceptions in a data flow script component. i.e. am I supposed to catch all exceptions and then set some failure flag The reason I ask is I've got a script in a dataflow which is occasionally throwing exceptions when trying to convert an empty string to a decimal. Problem was the package locked up and had to be terminated when the exception was thrown (and not caught in the script) The only thing which differentiates this package from others I've created is the data flow has a conditional split which creates 2 seperate paths loading 2 seperate SQL tables - the exception is being thrown in a script on one branch which seems to hand the entire flow PS I have fixed the script so t ...Show All

• Krutika SharePoint Integration - FormsAuthentication & the ReportViewerWebPart

  Hi - I'm trying to get the MOSS + Reporting Services + SP2 all working together using Forms Authentication. The readme file that was shipped with the SQL SP2 CTP seems to suggest that this is a supported configuration. I've got everything setup and configured - I've tested in using Windows Integrated mode for my MOSS front end and my report renders absolutely fine. When I try to switch the Authentication Provider to Forms Authentication mode, when I click the report, I'm now getting an error message that states: "The item 'http://moss:8003/Reports/Company%20Sales.rdl' cannot be found. (rsItemNotFound)". This message is being given to me from the following URL: http://moss:8003/_layouts/ReportServer/RSViewerPage.aspx R ...Show All

• COLLECTOR Delete's Value

  Has anyone ever had an issue when they try to commit changes back to the database based on a value they enter in a application...the value that u would use (i.e Select * From Customers Where CustomerID = 'value') to get the rest of the value's pertaining to that value you enter gets deleted from the database....its really wierd but i have that problem I mean the one value i enter in my form gets deleted all the information from that row stay's except for the search value that i use... How would i use the SQL profiler to see whats being sent...I have not used it before but ill check the net too...thanks You mean that rows have been deleted by selecting them HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• programmer01 OPENROWSET T-SQL function

  Hi everyone, I have some doubts about OPENROWSET T-SQL function . According to my knowledges about this, openrowset function provide us to use a data from a different Server only that time that we use this function. After we use this function, there is no any linked server trace on the local server. So is this true I see that everyone use different parameter for this function. For instance, everyone firstly use OLE DB name and then the second srvprovider name changes programmer to programmer, so why And lastly, I wonder about the relationship between ad hoc method and openrowSet function. Thanks To create a linked server definition using the Microsoft OLE DB Provider for Jet to access an Excel spreadsheet, first create a named ...Show All

• Peter Bernhardt Error: The component has inconsistent metadata

  I have a Source Query with this sql set as a property expression: "SELECT Category, Server_Name, Entitle_UserID,User_SubID,Start_Time,End_Time,Entitle_User_Name,Stat_Name,Stat_Count,Stat_Type,pk,create_date,run_num,Average,Median,Maximim FROM tbl_ws_stats WHERE pk > " + (DT_STR, 100, 1252)@[pk_var] There is a message : 'The component has inconsistent metadata.' Then when I click on the Source Query: 'The component is not in a valid state. Do you want the component to fix itself automatically ' I also notice that there are no columns on the Column Mappings tab and no way to add columns. How can I correct Thanks You could do worse than to (a) back up your package, and (b ...Show All

• R.Tutus help needed to drop a table!!!

  hi, can any one tell me how to drop a table...i tried to delete using the command : drop table sample; but it displays an error stating that, Cannot drop the table 'dbo.sample', because it does not exist or you do not have permission. pls post the reply asap -Sweety May be that table actually does not exist sweet_salt wrote: hi, can any one tell me how to drop a table...i tried to delete using the command : drop table sample; but it displays an error stating that, Cannot drop the table 'dbo.sample', because it does not exist or you do not have permission. pls post the reply asap -Sweety Check that the account that you are using to run this que ...Show All

• JohnGrabau Replace Non-Numeric Values With Zero

  Hi All, I have a problem that I have no idea how to fix, not even sure if its possible but hopefully you can let me know. So I am pulling data from one table to another table in a DTS. But I need to check if data in one of the columns contains a non-numeric value and if so change it to a 0. This is basically the code i'm using: SELECT Product, Descript, Qty FROM Products ORDER BY Product, Qty, Descript Does anyone know how to check for non-numeric values and perform this change Rgds, Paul You might consider changing ISNUMERIC ( Qty ) with ISNUMERIC ( Qty+'E0' ) Also, give this article a look http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.ht ...Show All

• ggo6 Full-Text Search Problem

  I am trying to create a full text index on a column in a table and the data type is Image, but the TYPE COLUMN FILE EXTENSION is in another table. there is no way of creating the type in the same table. the wizard will not allow me to pick the data type field from another table. is there a work around this issue Emadkb Sattva, The behievor you are experiencing with your SQL Server 2000 Enterprise Manager (EM) is typical and expected. The EM cannnot "see remote" services such as the "Microsoft Search" (MSSearch) service on remote servers when accessed across the internet or the server is registered as an IP address. However, SQL FTS is still functional and you can use the system sto ...Show All

• NamelessJuan Using an attribute from 2 different dimensions to create a hierarchy ?

  Hi I have the following: 1 fact table containing amount, projectID, EmplyeeID, organisationID 1 Project dimension 1 Employee Dimension 1 organisation dimension Within each dimension i have several atributes Let's say i want to make an hierarcy where the user can drill down the following levels. Division(organisation dim) -> Area(organisation dim) -> Project(Project Dim) Is it possible to build that hierachy, and where should it be build. I know that in the browser i could just drag down organisation dim and then the Project Dim in front of it, but in this case i want it in one hierachy. Are the Organisation and Project dims related, except through the fact table If the ...Show All

• SCarmeli Login Failure

  I have the default instance of sql server (2005 express) installed on my machine. I can log on with no problems using the windows authentication but I had to create a new login account with a username and password. I have added the new user using the Management Studio under the Security>Logins folder. I have assigned this new user has a server role of sysadmin and I have mapped the user as the db_owner of each current database on the server (default system db's). When I try to connect to this server (keeping in mind it works fine with the windows account) using sql server Authentication and the new username and password, I get an error that says "Login failed for user 'WblsUser'. The user is not associated with a trusted SQL Ser ...Show All

• COREY H Newbie - sa password error after ACT! install - Need pro's help!!!

  Hello, I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated! Sounds ...Show All

• CFIG Sql Express SP2 and Visual Studio 2005

  Will the SQL Express SP2 update the Installer package that comes with Visual Studio 2005 so that SQL Express SP2 is included with a ClickOnce or MSI based installer Including SP2 on Windows Update is a step in the right direction, but I (and I assume others) really hate the idea of burdening our users with the additional step of obtaining the SP2 update immediately after installing our application. This is especially cumbersome if they are using dial-up Internet connections which, unfortunately, many of our customers continue to use. Thanks, Travis You need to be made administrator. Open the Surface Area Configuration Tool and click Add New Administrator. Hi i have ...Show All

• Mule Nested Transactions

  Can anyone verify for me whether SQL Server CE 2.0 does or does not support nested Transactions when using the SQLServerCe Data Provider The SQL Server CE Books Online documentation definitely states that SQL Server CE supports nested Transactions, but the example provided uses ADOCE Data Provider. The error message that I get when trying to begin a new Transaction with an existing Transaction still uncommitted on the same SqlCeConnection is "SQL Server CE does not support parallel transactions". Is it not possible to nest Transactions with SQLServerCE Data Provider SQL Server CE 2.0 Books Online - under the topic "Using Transactions", the second bullet point under that topic stat ...Show All

• kubaw dimension design

  In my telco cube, I want to analyze usage. Eg how much sms's a subscriber has sent. The fact table is completely denormalized and has lots of columns with different types of usage. For example, following columns occur: MO_VOI_PEAK MO_VOI_OFFPEAK MO_VOI_WEEK MO_VOI_WEEKEND Now the sum of these fields overlap. Evenings during the week are also offpeak... This is only an example. Different categories occur for different products, like voice, sms, mms and so on. And not all categories apply to all products. Eg, mms does not have the peak and offpeak distinction. Is it possible to put this into one dimension, without aggregating double I have already normalised the fact table, meaning tha ...Show All