Answer Questions

• Matt E. scan order of user defined aggregates

  Hi all! I have created (in CLR) a user defined aggregate. The scan order of this aggregate is important, because it return different results for different orders. When i use it with a single group (using order by and where) is working fine. For example select id, dbo.cmp(myclolumn) as myres from (select top 100 percent * from mytable order by id,clmdate) where id=10 group by id This works correctly. Now lets expand it by removing where id=10 clause select id, dbo.cmp(myclolumn) as myres from (select top 100 percent * from mytable order by id,clmdate) group by id I get slightly different results from what the right result must be. Any idea I inquired with the CLR user defined aggre ...Show All

• Gary Harper MSMQ

  Does anyone know or have any idea what's the use of msmq or how can this apply in ssis. Thanks can you help me how am i going to use this the "MSMQ task in SSIS" thanks Sean Schade wrote: Do you have a requirement to use MSMQ, or are you just curious about it If you're just curious about it then google both terms and do some research. If you have specific questions about either MSMQ or the MSMQ task in SSIS ask them here, and I will try my best to answer them for you. Can you help us and explain what you are trying to achieve The task is there, documented, and does what it says on the tin. Do you want to send a message Do you want t ...Show All

• Severin123 Moving Table to another SQL server using Linked Server

  Hi, I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server. How is this done Thanks in advance. If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server). That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table o ...Show All

• learnerplates Debug is greyed out?

  I know there's a trick to this, that I can't figure out. Have an SSIS package that I developed and deployed/saved( ) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right Why is the debug drop down box greyed out There's gotta be something I'm missing here. THanks, Lezza It needs to be part of a Visual Studio solution in order to debug it. I'm guessing that you just right-clicked on the package and selected 'Edit' right ou can only make changes to it when you do that - not debug it -Jamie With much digging, I finally found all the code behind ...Show All

• Danny Tuppeny analysis services 2000 (data mining)

  i create a model mining CREATE MINING MODEL [a'S] ( [Cusid] LONG KEY , [Orderdetails] TABLE PREDICT ([Productid] LONG KEY ) ) USING Microsoft_Decision_Trees i can show for customer some products other when he choise a product. ect: he choise A, i show he B, C, D .... but for that, i must know his cusid. now i want show B,C,D when one man choise A ( i don't know his cusid). how i do that. ( i'm using sql server and analysis service 2000) i can't do. i use select query: SELECT FLATTENED [t1].[cusid],TopCount( Predict( .[Orderdetails], INCLUDE_STATISTICS, EXCLUSIVE), $ADJUSTEDPROBABILITY, 3) FROM PREDICTION JOIN SHAPE { OPENROWSET ( 'SQLOLEDB.1', 'Provi ...Show All

• Wajdi Georges SSRS and Teradata

  Is anyone out there using SSRS with a Teradata data source R Regarding immediate execution if all parameters are satisfied: this behavior is currently not configurable. One option here is to not include a default value for at least one parameter. Another option is to implement your own parameter UI and logic and then e.g. use the Report Viewer control to execute the report in Server mode on a RS 2005 report server (see also www.gotreportviewer.com ). -- Robert Ron, A couple of things. First off, thanks for the dynamic string. The above code does work for me in VS Designer when I select the 'All' option. Are you running SQL Server SP2 like I am Second, I talked to some of the MS folk ...Show All

• AgWells Oracle with Reporting Services. "illegal variable name/number"

  I'm developing a report with SQL Server Reporting Solutions (obviously ;)) against an Oracle DB and have run into a problem. This is the code that I'm using for the dataset query that my report is to be based on: ="SELECT * FROM IRMFE_*************_V WHERE " & IIf(Parameters!Invoice_No.Value(0)<> "ALL", "SUPPLIER_INVOICE_NO IN (:InvNo)", "SUPPLIER_INVOICE_NO LIKE '%'") The parameter ":InvNo" is a paramter in the report and the user can select multiple values. I also included an "ALL" option manually in the query for the parameter. The query works fine with single or multiple options but if I select "ALL" I get the following error: "Query execution failed ...Show All

• shmulik_segal Backup Transaction logs

  Hi: I have configured maintenace plan to do a full backup of sql server at 5:00 Am followed by transaction log backup every 15 mts.The transaction log backup basically appends to existing backups so there is only one file of transaction log backup. I want to modify that the transaction logs backup only has transaction logs after 5:00 Am full backup.Right now the transaction backup has backup of all the transaction logs since i have scheduled. Thanks for your help. Ganesh > True as the backup of database also takes care of transaction logs and there is no problem of duplication in your case. Note that the portion of the transaction log which is included in a full backup is NOT a substitute for a log backup, nor ...Show All

• Igor B. Errors: SQL Reporting Services with CRM 3.0

  Good Day All ... I am currently trying to install CRM 3.0 onto one of our test servers. I have managed with no problem to get everything ready for installation ... but having a problem with reporting services. On the system requirements results page i have green for everything but reporting services. ERROR; Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found. I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working. Thanks Do you habe any Sharepoint Server installed on the machine or any other program which tries to bind port 80 to itself HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• GavH SqlExpress Bootstrapping

  Hello I'm building an app for retail commercial distribution, and I'm agonizing over which database to use. I'd like to use SqlExpress, as it's supported by the code generation tool I use, but I'm wary of the download size.   SqlExpr32.exe is 35 megabytes, yet Microsoft maintains that it's a " fast download ", a claim whose logic escapes me. If I try to force something like that on my buyers, I won't have any buyers (Framework 2.0 is going to be hard enough for them to swallow).   I recently made the difficult decision to forfeit the use of my preferred code generator ( DeKlarit ) in favor of the VistaDB embedded database , but this article has got me thinking about SqlExpress again.   Is there a lightweight distributi ...Show All

• qwv Moving from 2000 to 2005: issue Accessing cursor returned by sp

  I have a number of triggers that call a stored procedure that returns a cursor. The triggers then use the results of this cursor to do other actions. My problem is that this works fine in SQL2000 but just won't work in SQL2005. When I try to access the results of the returned cursor, I get an error -2147217900 could not complete cursor operation because the set options have changed since the cursor was declared. If I port the code contained in the sp into the trigger, it runs fine. But having to port over the sp's code defeats the whole concept of being able to re-use the sp. Does anybody have any ideas of what could be going on I look forward to a quick response. Dennis I ry need your ...Show All

• SatishThumar Pass parameters to complex procedure.

  Hello, I have this Stored procedure, a very complex one, and it works fine with the parameters wrote on it. But when I try to change the number to variables @param1, I got errors, can somebody tell me how to replace this please. DECLARE @return_value int, @lvaIndicador varchar(4000), @ecuacion varchar(4000), @numerador int, @denominador int, @lvaIndicador2 varchar(4000), @ecuacion2 varchar(4000), @numerador2 int, @denominador2 int, @porcentajeCumple numeric EXEC @return_value = [dbo].[SP_CUMPLENCONNIVEL] @nmtipoCompetencia = N'12,13,14', @nmdivisioncorporativa = N'18,19,20', @nmciclo = 9, @nmcicloCompara = 12, @nmempresa = 72, @nmcargo = N'20', @lvaIndicador = @lvaIndicador OUTPUT, @ecuacion = @ecuacion OUTPUT, ...Show All

• Antonio Neeves Active Directory Sql Servers

  Hi everyone, how to retrieve programatically the list of the AD's Sql Servers You've been looking at SMO classes but it seems that it depends of your own workstation. Thanks in advance Your best bet is to do something like an LDAP query specifying the OU (Organizational Unit) the servers were defined with. The EnumAvailableServers method will scout the SQL Server browsers on your network and bring back everything that responds to a ping, whether the server was defined in AD or not. (Joe Developer may have SQL Server Dev Ed running on his laptop, and you're probably not interested in that server.) Here's a starting point for you: Dim mySearcher As DirectorySearcher Dim resEnt As SearchResult Dim colRes ...Show All

• sfx1 Unable to view the updated Data URGENT

  I am executing this code from asmx.vb page in ASP.NET It is not giving any error It is taking some time to process this request. But I am not able to see these changes in the cube's data Please help! I am using Following code to update the cube. Dim str As String Dim cnn_oledb As New OleDb.OleDbConnection(strOLAPConn) Dim s As New OleDb.OleDbCommand(str, cnn_oledb) str = "UPDATE CUBE [DEMO] SET ([MEASURES].[BY],[center].[Ames Research Center],[Budget Year].[2007]).VALUE=5" cnn_oledb.Open() s.ExecuteNonQuery() Thanks in Advance cnn_oledb.Close() I don't think there would be any problems with commits or transactions. I think it is more likely that there is an error ...Show All

• IanR Unable to delete anything!

  HELP! I am unable to delete anything on the report server. I have looked in the logs and reporting services dumps every time I try to delete a report or a report model. I get the following in the RS logs, aspnet_wp!library!6!09/05/2006-18:30:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details And in the event log, it is telling me it cannot find itself!! Error: 50911, Severity: 16 ...Show All