Answer Questions

• Asem Masri More questions about data mining plug-in algorithms?

  Hi, all here, I am having a more considertaion about Data Mining plug-in algorithms. When we say we are going to embed a uesr plug-in algorithm, so what is the context for that I mean in which case then we thing we need to embed a user plug-in algortihm I know when we say we are going to embed a user costomermized plug-in algorithm, it means we want something more costomized. But what kind of customized features are generally concerned Is it ...Show All

• Jack Diamond Report Parameter- 'All'

  I am trying to make a report parameter that allows the user to select one of three values. Two of the values are what;s stored in the view's field right now: (as char 1) 'O' (open) or 'C' (closed). I need to add the choice 'All' that will show BOTH open and closed. I made a dataset for the parameters as select distinct valve_position from view monitoring where (not(valve_position is null)) Of course, that only yields choices o ...Show All

• Sharat SQL SERVER & Coldfusion connection problem - server newbie

  I've just updated my XP and installed SQL Server 20005 Express but can't connect to my Coldfusion server. I opened up Studio Express and created a new database. I tried to go to Administrative Tools and establish an ODBC connection there but can't get a validation. The Coldfusion Admin won't validate it either. Where do I start to solve this problem. Thanks for any help! Rob Painful! - well I think I have good ...Show All

• Moody2006 Cannot Install SQL Server 2005

  I'm trying to install the final releases of Visual Studio 2005 Pro and SQL Server 2005 Developer's Edition. Unfortunately, I uninstalled VS Apr CTP "first"  INSTEAD OF SQL Server 2005 Apr CTP. I was then able to install the final release of VS 2005 without any problems but now I cannot install the SQL Server 2005 because it finds the beta components that must be uninstalled before proceeding. I tried using "Add/Remove Programs" but when I ...Show All

• Stubabe D Connection to SQL Server 2005 Express?

  Hi all, I've been reading other posts for awhile now and I can't figure out what I'm doing wrong. I'm a Web Developer and not a DBA. I have SQL Server 2005 Express installed on my machine and it's working just fine. I also have the Management Studio Express CTP installed and working. I'm trying to connect to a database using a username and password (from ColdFusion Server which is working fine for external Oracle and Access databases, so t ...Show All

• Devendra Chandola SELECT INTO using a data-flow

  Hi, A T-SQL INSERT INTO operation inherently expects that the destination table already exists. However, the T-SQL SELECT INTO operation works by creating the destination table as it inserts the data. Like INSERT INTO, an SSIS data-flow inherently expects that the destination table already exists. Can anyone figure out how you might be able to do the equivalent of a T-SQL SELECT INTO operation using a data-flow I'm thinking a custom de ...Show All

• vivisad Importing from Excel to SQL Server 2005 Express

  I'm trying to import a database. It seems my most likely route is via Excel, so I've moved my tables in there. Then I tried setting up Excel as a linked server as described in http://support.microsoft.com/default.aspx scid=kb;en-us;Q321686 My linked server gets created apparently with no errors, but I can't see any contents when I click on it in the object explorer. Anyone with more clues than me thanks Dif ...Show All

• DannyArcher Copy Database or Database Restore

  Hi, I am restoring one of my database from test box to production box. I don't have all the logins defined(users for copied database) in production box, What happen if user tries to access the database. I guess they will not be able as user is defined but there is no matching logins. Will Copy Database wizard creates all logins as Restore Database does not Thanks No. When you copy the database as well as when you restore the data ...Show All

• Aner Scalar Function with the field name and table name as paramater

  I wanted to create a scalar function where the tablename and fieldname are part of the paramater. This function will be generic to all my procedures, since I'm just doing or getting the same thing to count. Create Function [dbo].[getMaxCount] (@name, @fieldName, @tableName) Returns varchar(500) as begin declare @count numeric declare @message varchar(500) select @count = count(@fieldName) from @ta ...Show All

• nzhu SQL Express: Report parameter 'Non-queried' works, 'From query' doesn't

  My report works fine when setting report parameter to 'Non-query'. Setting it 'From query' it gives the following error : "The report parameter 'par1' has a DefaultValue or a ValidValue that depends on the report parameter 'par1'. Forward dependencies are not valid." Please help me, how to solve this problem! I think that error message is very clear. Do you use that parameter in a query ...Show All

• Strauslin Can't find the index key of Attribute

  Hi, When I process a cube, it result in an error message: Can't find an index key of Attribute:xxx What is the problem ...Show All

• swfisher Xml retrieving is slower after adding xml index, any idea?

  I have  a table, it has a field call extrafield, it stores xml like <field name="name1"></field> <field name="name2"></field> ... I tested on 30k records, query like select * from thetable where extrafields.value('(/field[@name="name2"]/.)[1]','int')<3000 takes around 8 seconds to run, but after I created xml index, I tested after each index created(primary, three different seconary on value,path and property), i ...Show All

• Aaron Cheng Compare SSIS to wherescape software?

  I am just a beginner in SSIS and I like it, and somebody that has many years of experience in datawarehousing recommend me the software from this company, http://www.wherescape.com/ , I just wanted to know if somebody has tried it, because I think its interface is poor and I dont think its better than SSIS, the only thing good I think, is that it can make datawarehouse in oracle and sql in the same tool. If you can review it please advice me. ...Show All

• Centuri0n running replication jobs

  Hi all,  We have 2 merge replication jobs. I want to complete one job and then start another job after the first one is completed. Is there any way, that I can make the first job to trigger the second job as soon as it is over Thanks in advance. Thanks, Preeth. Some options I can think of over the top of my head are: 1. Schedule them at different times in the required order 2. Add a 3rd dummy job ...Show All

• Andreas &amp;#214;hlund SQL Mobile Embedded XP support?

  I am building a mobil application using Windows XP embedded. I need a database that will run on xp embedded as follows: Client mode: Sometimes connected to server(local) sometimes disconnected. Server Mode: Ready access to database from client and system running server. Client must be able to switch to server mode in event of failure. Does SQL Mobile support running Windows XP embedded on the Server Does SQL Mobile support running ...Show All