Answer Questions

• Neotech Message: Missing end comment mark '*/'.

  Hi, I created a web syncronization merge replication ,both servers and clients are sql server 2005 and everything is fine with the settings , but while synchronization and after i received some sch files i got the following message at the subscribers on the initial snapshot operation: 2006-06-27 07:50:14.471 The schema script 'myfile_311.sch' could not be propagated to the subscriber. 2006-06-27 07:50:14.471 Category:NULL Source: Merge Replication Provider Number: -2147201001 Message: The schema script 'myfile_311.sch' could not be propagated to the subscriber. 2006-06-27 07:50:14.471 Category:NULL Source: Microsoft SQL Native Client Number: 113 Message: Missing end comment mark '*/'. Any idea Tarek Ghazali SQL Server MVP ...Show All

• Mark Dawson Taskkill xp command not working

  I figured this out using a different method, this post can be deleted moderator. 9-21-06     Can anyone tell me which command to use with taskkill to wait before executing it   I've tried the wait and sleep dos commands but they don't work unless my syntax is wrong below.   start C:\DocFinity\ObjectImporter-Prod\objimp.exe taskkill /f /im objimp.exe /w 30   start C:\DocFinity\ObjectImporter-Prod\objimp.exe sleep 30 taskkill /f /im objimp.exe   thanks, ...Show All

• VickyN Error when Deploying Cube

  Hey guys, Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is: Server: The Operation has been cancelled. I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into Or has anyone had this message before I am stumpped and now its annoying me as i was so close to having my first cube up and deployed... Thanks in advance Scotty Are you receiving the error when you build and deploy the cube Or does the error happen ...Show All

• mcaine How many user current "connect" to a row in table.

  Hi all... Iam a newbie and i have one question want to ask experts ... . I am current working on one App which have some user connect to database at the same time. And i want to know: how many user connect or use (read , update) to one row in a table Could it be possible to know that If you have one solution to solve this problem , please let me know :) ... Could it be done by Software , T-SQL or anything ...., iam happy to know. Thanks all. Couldn't you try to use a trigger to make such a mecanism Can you state the underlying purpose to what you are doing It is not a natural thing to be interested in what row a user might be "connected" to. Now if you are talking about locking it for modification, that makes ...Show All

• Chee Kiang Local Cube Distinct Count Behavior in SP2

  I am the lead designer of CubeSlice, a local cube generating product. Our product allows a user to create local cube files either with ASSL using an Analysis Server 2005 connection or ASSL with a relational data source connection. We allow users to include Distinct Count measures in their local cubes. When using an Analysis Server connection we convert the Distinct Count measure into an equivalent calculated measure. When using a relational data source connection we use the Distinct Count measure directly. Using the Distinct Count measure directly provides significantly better browsing speed. The local cube creation behavior appears to be changed now with SP2. When a Distinct Count measure is used in a local cube created with a relation ...Show All

• lucerias SSIS package execution

  Hi all, I am Hazara. I am trying to call a SSIS package from a web service. But package.execute() method is returning 'failure'. Though I am able to execute the same package from a normal .Net project and it is working fine (using the same code that i have used in web service). I have also tried to execute it through stored procedure for which firstly I created a .dll in c#(which is perfectly working) and then I registered this .dll in sqlserver-2005 using following command. CREATE ASSEMBLY asmPackageExecuter FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\PackageExecuter.dll' WITH PERMISSION_SET = UNSAFE GO Now on calling the method of .dll (which is responsible to execute the package) I am getting the DTS ...Show All

• geraud c Problems with date formats

  The date fromat in my country (Australia) is DMY. It seems to be quite difficult to prevent the month and day being swapped around. I had a case recently where we generating a list of dates to be presented in the report server UI (User Interface) as a list box for a parameter selection. We fixed the problem in the data set (on the data tab) by using "SET DateFormat DMY" only to find that the month and day were still swapped around in the UI list box. If this was just a presentation issue we could live with it but it turned out that the value read into the parameter was incorrect (the day and month were actually swapped). To fix the problem, we had to chnage the data type to VarChar() in the data set query, using Convert() to force ...Show All

• dvl_vn Replicating structure only not data

  I have a SQL 2005 database that I am using with a website. This basic website will be sold to other companies and ran on their servers with different URLs. Since, All of these databases will store different data, I'm not sure how I can make updates to original database and replicate those structure changes to the other DBs without changing the data also. Is there a way to automate the replication of structural DB changes without replicating the data along with it Thanks, Kirk Thanks Gary, I am not new to SQL 2005 but I have never done any replication. Could you lead me to a good reference that would explain how to do some of the things that you wrote about Any help is greatly appreciated. Ki ...Show All

• MirnaHAnna Installing SQL server 2005 express

  Hello, I have a problem installing SQL express from a CD, it installs fine but the installation wizard does not load automatically, so I have tried to setup manually through Add and Remove programs. But when I get pass System configuration check menu, i do not get the Registration info menu, it goes straight to SQL server express setup and then to another server express setup menu (it skips 3 menu pages) it should have MSML5 components such as SQL setup files, SQL native client, SQL VSS writer etc but it is completely empty. Then I get the finish screen. However, when I uninstall SQL express, I see the MSML screen with all the components listed before it uninstalls. I hope this makes sense and I hope someone can help. Thanks ...Show All

• Eli.weiwang Attribute Limit of 5000 When Mining a Cube

  I'm trying to build a association model in the Standard Edition based on an existing cube. I keep getting the error: Error (Data mining): The 'Product Recommendations' mining model has 60385 attributes. This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm associated with the mining model. I created Cube Slice filters and those limit the Customer and Product dimensions (Product is Nested) to well under 5000. The error message also does not change. The number of attributes is equal to the number of rows in the Product dimension, but I expected the cube slice to reduce the number. I tested all the SQL used while it processes and with the MDXFilters the number of rows returned is ...Show All

• Philip Wolfe BIDS - Error on design surface of Calculation tab in Cube

  Has anyone seen this Within 'Business Intelligence Development Studio' (BIDS) with a cube opened and the calculations tab selected, the design surface displays a message that reads: Unexpected error occurred: 'Error in the application.' This occurs in any project I open and it still occurs when I restart BIDS or the computer itself. Any ideas Can anyone suggest a remedy Here it is: C:\Program Files\Common Files\System\Ole DB\ Filename: msmgdsrv.dll, Version: 9.0.3009.0, Date: 8/16/2006 10:36 AM Filename: msmdlocal.dll, Version: 9.0.3009.0, Date: 8/16/2006 10:36 AM So what action do I take Do I rename the existing (older) files (to something like msmgdsrv.dll.old ...Show All

• Jabber Upload a Sql website to a host server

  Hi I have built a site in Visual Web developer Express 2005. it works fine on my local machine but when I load it up to the server I get the following error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My connectionstring in my web config file: < add name = " ConnectionString " connectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True " providerName ...Show All

• Keith Chapman How do I update a field only if update value is not null?

  Hi. I'm not  such an expert in sql and I wanted to update a table's fields only if the value that im going to update it with is not null. How do I do that What I mean is something like: --------------------------------------------------- Update database.dbo.table set if(@newvalue !=null)      afield = @newvalue; -------------------------------------------------   Really need your help on this. Thanks. What about this by using ISNULL in the SET statement: UPDATE Crmworks . dbo . Lead SET Lead_PersonFirstName = ISNULL(@firstname, Lead_PersonFirstName), Lead_PersonLastName = ISNULL( @lastname, Lead_PersonLastName), Lead_Company ...Show All

• Frame format issue

  I've created a new calculate member in (SQL Server Business Intelligence Studio 2005) with the following format string: "#,#0.00". This measure is displayed like this: 22,250.22 Then I created a Measure in the Cube structure menue and used the same format string:"#,#0.00" and this measure is displayed like this:0,66 --> Comma and decimal point are changed in the display of the measures!!!! Can anyone help me with this I just like every measure to use a decimal point for the decimal place or the other way round. But I want every measure to be displayed in the same format! Thanks a lot! OK. What is your regional/national settings for the O/S What thousand separator and what decimal sign are you using wit ...Show All

• TPECI Executing DTS from Stored Procedure in Sql Server 2000

  Hai .....,           I have created a DTS package in the Server machine (Server=machine7 and my machine is machine3). When i execute the DTS directly by selecting it, it completes successfully. But when I try to execute the same DTS thru my stored procedure, I 'm getting the following error message:(I Executed the procedure thru Query Analyzer window and got the following message) DTSRun:  Loading... DTSRun:  Executing... DTSRun OnStart:  DTSStep_DTSActiveScriptTask_1 DTSRun OnError:  DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)    Error string:  Error Code: 0 Error Source= msxml3.dll Error Description: A connection with the serv ...Show All