Answer Questions

• donbox5 Plug-in Algorithm in data mining using SQL Server 2005??

  Hi, actually i want to implement a c# component that can help third party data mining algorithm and i want managed plug-in algorithm (without wrapper),. is it possible to write whole application in c# as Analysis servisce is in c++ , can we implement it in c# thanks in advance ~Chinmay Hi chinmayv84, This is very curious issue. I will go develop some code for you in free time. Javier Luna http://guydotnetxmlwebservices.blogspot.com/ If you're trying the re-implement the COM interfaces in C#, it will be much harder than the managed C++ wrapper we've provided - you'll need to do your own research in that case. Testing the wrapper would be a combination of whitebox testing and a sample plug ...Show All

• Omar Kalala Package Configurations not so portable?

  I'm still struggling with finding a sound approach to creating configurations that are truly portable.  For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package.  This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - but how can you configure a data source at runtime by storing it as a config in SQLServer, when the data source itself is used to specify the server that stores the config information Environment variables or registry entries seem to be the most practicle because they truly are machine specific. ...Show All

• Bryant Likes Stored Procedure

  Hello, I've written the following stored procedure: CREATE PROCEDURE dbo.GetTableName ( @ConfigurationId int = 0, @TableName varchar(MAX) OUTPUT ) AS SELECT @TableName = ConfigTable FROM Configurations WHERE Configurations.ConfigurationId=@ConfigurationId; How can I get the parameter TableName now I tried EXECUTE GetTableName 0 Error Message: "Procedure or Function 'GetTableName' expects parameter '@TableName', which was not supplied". Sure, I did not supply it because I wanted to have it as return value. What is wrong I also tried: CREATE PROCEDURE dbo.GetTableName ( @ConfigurationId int = 0 ) AS DECLARE @TableName varchar(MAX); SELECT @Ta ...Show All

• Linda Shao Save a large string in database

  hi is there a datatype thatcan handel a very large string ( i dont want to save it in a file and save the file in the bd ) i want to save it as it is thanx a lot Varchar can hold 8000 characters now. Use Text for longer strings. i use sql server 2000 and its has text and it can hold up to 2^31-1 but i need a bigger datatype +1 for the file approach as if you hit the limit you will have no other chance, but consider this paper for storing a BLOB in the database or on the file system. http://research.microsoft.com/research/pubs/view.aspx msr_tr_id=MSR-TR-2006-45 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• james2887 SQLDependency Disconnects for Web application

  Hi, On my ASP.NET 2.0 application and SQL 2005 database server, i am using SQLDependency API to recieve notifications on the dataset changes from SQL 2005 server. I get the notification sucessfully (irrelevant of number of attempts). So here's the problem, i wait for 3-4 mins and make sure that there is no activity on my web server. Now if the data changes the service broker fires the event (i validated through trace). But the notification is never received by my web application. It gets lost in between. I read about this 'Abrupt client disconnects' problem in the article http://blogs.msdn.com/remusrusanu/archive/2006/06/17/635608.aspx but this didn't help much. Also i sometimes see following messages in the profiler <qnev:QNEv ...Show All

• KitGreen change visibility with fixed header

  I have a report, with a table, that has a fixed header. I have two detail rows in the table, one is hidden by default. When I click on the textbox to make a table row visible, the report refreshes, and everything shows up correctly, however the report data is under the fixed header. I have to scroll down, then back up to see the data. Is there some way to fix this behavior ...Show All

• sveroa Tools to generating database creation scripts.

  Hello, there are a tools, or a "ways" to generating "database creation scripts" from a MDF files Thank you for help. Bye Toni Hi Toni, In Management Studio Express, right-click on the database you're interested in, point at Tasks and then click Generate Scipts, this will launch the Generate Scripts wizard. Follow through the steps to script out your database. Oddly enough, this wizard doesn't seem to generate a CREATE DATABASE statement despite the help file claiming it does. I'm not sure if this is a unique limitation of Management Studio Express or if the help file is just wrong. If you are interested in only a subset of objects, it might be quicker to script just those objects, which you can do by rig ...Show All

• Romantic_touch OLAP Connectivity

  Hello all, We have Analysis Services 2000 with an OLAP cube. The cube has a role allowing access to all Windows domain users. From my development workstation we can connect to the cube, using Excel or a HTML page with the Office Web component, logged on as any user. However, from any other computer in the domain, and logged on with the same users, we cannot create a connection; the OLAP server is not visible! The client computers are all the same: Windows 2000 Pro and the users all belong to the domain. Why can we not connect Has anybody ever experienced this sort of problem We need to solve this by Monday, our deadline to show our OLAP application to the users. I would really appreciate somebody's help. Thanks in advance, J ...Show All

• A.Issa SQL 2005 SP2 (CTP) installation

  Hello I am trying to install PPS (CTP) this requires SQL 2005 SP2 (CTP) but during the install of the SP2 I get the following error while trying install it: Unexpected Error Occured Unable to create backup Folder Next thing is that A Send don't sent error is created for the hotfix.exe. The install terminates at this point. I am working in a VPC image, logged on as Administrator, anyone give a hint as to what this could be Many thanks We had the same problem. We recognized that C$ share did not exist. We created the C$ share. But because of default readonly permissions the problem still exists. After giving read-write share permission to C$, then the setup succeeded . ...Show All

• akin_l How can one find out if two tables can be joinned dynamically

  Hi All, Given a table, is there a way to programmatically find out what other tables and views it can be joinned with Essentially, given two tables, two views, or a table and a view, I want to be able to find out if they can be joinned. I was able to find related tables with sp_fkeys, but this does not work all the time, and does not work at all with views. I also played with the information_schema but got mixed up and confused quickly. Any help would be greatly appreciated. Hi Try it in SQL 2000 select t2.VIEW_SCHEMA, t2.VIEW_NAME, t1.TABLE_SCHEMA, t1.TABLE_NAME from (select VIEW_SCHEMA, VIEW_NAME, TABLE_SCHEMA, TABLE_NAME from INFORMATION_SCHEMA.VIEW_TABLE_USAGE where objectprop ...Show All

• tokie AS2K5. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileSto:HandleDataPageFau

  I have a simple query, that produce internal server error. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault'). WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT ([Date].[Fiscal].[Fiscal Year ].&[ 2005 ]) ON COLUMNS, CROSSJOIN({[Product].[Days to Manufacture].[All Products],[Product].[Days to Manufacture].[All Products].children},{[Measures].[Internet Sales Amount]}) ON ROWS FROM [Adventure Works] WHERE ([Product].[Product].Slicer) Another MDX query produce wrong result. WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT {([Date].[Fiscal].[Fiscal Year ].&[ 20 ...Show All

• RhysDavies Dependant assemblies in CLR

  This is related to one of my previous posts. I am running a CLR stored proc that goes to an EDS (Novell) server with LDAP and returns records into a SQL table. I am using the Novell ldap library. I want to do this with SSL so my code referneces the Mono security library as well. However when I make the call to the stored proc to run in SSL, I get an object not found error. I do not think that the the Novell assembly can "find" the Mono assembly. Two points: 1/ I can do the SSL if I run it as an asp.net page (so I know the SSL works) 2/ The proc runs and pulls all the records in non-SSL (so I know the proc works) Any ideas Thanks, BIG That is the solution for a different problem where Xml S ...Show All

• Olle SW How to Setup JDBC for SQL2005 in Webshpere 6.0

  Does anyone know the steps on how to get SQL2005 to talk to a Websphere application via the MS JDBC We are trying to setup the Niku Clarity system with a new SQL2005 Database. Thanks Hi There, I am aslo trying to setup the SQL Server jdbc driver with WAS6. I followed the above steps exactly. When I try to test the connection from the WAS admin console, I am getting the following exception: javax.management.RuntimeMBeanException: null nested runtime exception is java.lang.SecurityException: Signers of 'com.microsoft.sqlserver.jdbc.SQLServerXADataSource' do not match signers of other classes in package. Below is the full stack trace: Failed to connect to the DataSource.  Encountered "": java.lang.SecurityException: Signers ...Show All

• MKBender add report subscriptions programmatically

  hi! is there any way so that i can subscribe users to a report programmatically i have this page where they will initiate the download process of the report and then once the report is generated, their copy of the report will be automatically saved on their user folder in the server. is this feasible if there is another way of doing these, please let me know. thanks! ...Show All

• jkirk starting SQLServer 2000 "network path was not found

  Hi, I have sqlserver 2000 running on winxp sp2. I recently had the HD changed to a larger drive all programs and files seemed to have transfered over ok. I just installed VStudio 2005 which put a copy of sqlexpress on the machine. Now when I try to start sqlserver2000 with the name of the machine I get: "An error 3 - (The system cannot find the path specified.) Occrued while performing this service operation on the MSSQLServer service." When I try to start it as local I get just "network path was not found" When I look at MSSQLSERVER Properties (Local Computer ) the path to executable is: "C:\PROGRA~1\MICROS~4\MSSQL\binn\sqlservr.exe" When I use windows explorer to look at: "C:\Program Files\Microsof ...Show All