Answer Questions
kangalert SQL Service Broker vs MSMQ
I'm in the process of doing the initial research for the architecture of a large scale, transactional messages routing platform. My initial design called for a series of MSMQ queues and Windows Services, written in C#, to process the messages in these queues. There will be incoming and outgoing queues, queues to store unroutable messages, etc. My application will be routing many hundreds of thousands (and eventually millions) of messages per day. These message are very small (< 200 bytes each) and must be routed very quickly. (<1 second processing overhead per message for high priority messages.) Using the term "routing" may be a bit misleading. The messages arrive via TCP socket connections. I will just need to take in a ...Show All
Parham&#33; Why can't I use data-driven subscriptions?
I am using Reporting Services 2005 locally for testing purposes and also on a production server. Locally, I can create data-driven subscriptions, but not on the server. The only difference I can think of between my local test environment and the production server is the versions of SQL server database. Locally, I am using SQL server 2005 but on the server I am using SQL server 2000 (but with Reporting Services 2005). Can the version difference be the reason for not being able to use data-driven subscriptions Note: I have followed various guidelines and walkthroughs that describe how a data-driven subscription is created, i.e. stored credentials on the report server and such should not be the problem. Operating systems: locally; Windo ...Show All
Mart1n0 Most time consuming SQL Queries
What are the types of queries that are most time consuming...which may easily lead to expired time out etc...thanks Regards Alu thanks. Regards Alu Thats a whole different world. If you want the quick win for the MDX side you can compare that with the aggregation on the OLTP side which is not pre-aggregated and therefore has to be done at runtime. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I wanted to compare sql queries from oltp db with mdx queries from udm. Therefore i need specific queries that using udm has the advantage over the norm. Regards Alu Could you be a bit more specific Do you mean by operation or what HTH, Jens K. Suessmeye ...Show All
Attila Fogel Can't Launch the Report Builder since applying SSL (HTTPS) certificate.
When trying to launch the report builder our users are getting a message saying: ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://domainname/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading https://domainname/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. + The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. + The remote certificate is invalid according to the validation procedure. I can launch the report builder fine from within our own network, but f ...Show All
cosminb Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?
As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition >> I guess you need a copy of STD. Which Sexually Transmitted Disease does he need (That's the common meaning of the acronym STD). It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands. Josh I think ...Show All
czy11421 Memory allocation error while processing cubes
I get this error while processing my cubes: Error: Memory error: Allocation failure : Not enough storage is available to process this command. There is plenty of space left on the hard disks on this machine, I can't find a remedy for this problem on Google either. Any help would be appreciated. Thanks in advance. Hi I am experiencing the same memory allocation error whenever I try to deploy a cube. This is without even trying to process it. The only way I have been able to resolve it is to get administrators to restart the AS service on the server. I did not have this issue prior to loading SQL Server SP2. Can someone please advise if they have found the same issue and perhaps one of the fixes in ...Show All
LouisVanAlphen error configuration
I want to use custom error configuration for a single dimension. When I set the error configuration properties for a single dimension in Visual Studio, process this dimension and process the cube then the custom error configuration settings are ignored. When I set custom error configuration settings for the cube in Visual Studio these settins are also ignored. When I set the custom error configuration settings in the Process Cube Window (Change Settings - Dimension Key errors) then these settings are applied to all dimensions. How can I use custom error configuration for a single dimension and why are my settings in Visual Studio ignored. Thanks for any reply. Thanks for your reply. I have deployed my changes. I h ...Show All
Xancholy MDX Filter Problem
Hi, I am using AS 2000 FoodMart 2000 DB . My problem is when I run the below query I am getting an error. Query 01 SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Product].[All Products].[Drink] “ Duplicate dimension across (independent) axes when calculating a query axis ” But it is understood that I can use any other slicing dimension with WHERE clause to filter instead of the Product dimension, just like the below query: SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Customers].[All Customers].[USA].[CA] This query works fine. My point is that I know AS 2000 does not use the same dimension in two ...Show All
Key_46 SSAS re-deployment failed after import - blank error description.
Hi, I have created a new project using the "Import Analysis Services 9.0 Database" from the server and moved the project to my local pc (not connected to the server) in order to use the metadata. I can't deploy the new project on my pc to the local AS database. BI studio says: Deployment failed The following system error occured: . (only a dot) Can I get hint First see if your local Analysis Server is runing. Try connecting to it using SQL Management Studio. Second. Right click on on the solution in BI Dev studio -> Properties->Deployment. Check out the server name. To deploy to your local machine you can use machine name or localhost as a sever name. Edward Melomed. -- This posting is ...Show All
mNilysg A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication
Hi, Iam trying to perform merge replication between SQL Server 2005 and SQL server mobile. It has previously been working. Recently something is causing the following problem when i try to perform the merge. I grabed the following output from the replication monitor. Error messages: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber. (Source: MSSQLServer, Error number: 2147767868) Get help: http://help/2147767868 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message ...Show All
dlevers An attempt to attach an auto-named database ....\aspnetdb.mdf failed
I've installed VWD 2005(Beta 2) and MS SQL Express and also followed the aspnet tour at http://beta.asp.net/guidedtour2 . After trying new webcontrol (login control) and trying to execute the page, I've got an error such as below: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database fo ...Show All
Pavan Apuroop Can't retrieve second resultset with jdbc sql server 2005 driver
Hi All, My java application executes one stored procedure that returns two resultsets and then deal with data. The code actually is very simple Statement stmt = con.createStatement(); con is database connection ResultSet rs = stmt.getResultSet(); //Do something rs.close(); rs = stmt.getResultSet(); //Do something Then I got the error: The result set is closed. The code worked well with jdbc sql server 2000 driver. Thanks for your help. Eric Hello lxiao, The syntax for getting the second result set is if(stmt.getMoreResults()) stmt.getResultSet(); Keep in mind that the getMoreResults() methods takes multiple arguments which controls how visited result sets ...Show All
pAbLoPiCaSsO COALESCE with parameters
I am trying to build a report table based on user supplied criteria at run time. The user may or may not enter criteria into one or more fields. I used the COLAESCE as follows (the temp vars may be passed valid data or left null by the user): select * from dbo . employee where LastName >= COALESCE ( @ln , lastname ) and LastName <= COALESCE ( @ln2 , lastname ) and FirstName >= COALESCE ( @fn , firstname ) and FirstName <= COALESCE ( @fn2 , firstname ) and hiredate >= COALESCE ( @hire , hiredate ) and hiredate <= COALESCE ( @hire2 , hiredate ) and checkdate >= COALESCE ( @chk , checkdate ) and checkdate <= COALESCE ( @chk2 , checkdate ) The problem comes when I want to return rows that ...Show All
John Sudds - MSFT Merge Join question
Hi, All, In the data flow of Intergration Service, my understanding is that the "Merge Join" only does the "join", there is no way to input the "where" clause. If I need to input the the "Where" clause or selection criteria, how should I do it in Integration Service TIA, john zhang wrote: Thanks Rafael for the input. Now I have "conditional split" worked for me even it's inconvenient Why is it inconvenient -Jamie Thanks Phil. With other popular ETL tool, in one transformation, you can do both "join" and "where". But in SQL Server 2005 Integration service, you have to use two trans ...Show All
wencey How SQL 2005 Execute a sp in master db when called from other db?
In previous SQL server version, if I create stored procedure sp_XXXXX in master database, then call it from other database (session context is other than master) with master..sp_XXXXX. SQL server will execute the sp with the environment from where it was called. However, in SQL 2005, if I call it with "master..sp_XXXXX", SQL 2005 will switch the context to master database and execute the sp in master database environment. I wonder if I did something wrong or that is the way SQL 2005 execute the sp. If this is the way SQL 2005 does business, then, how to exec a sp in master database with local environment Thank you for any help. sp_foreachdb is still around... ...Show All