Answer Questions

• Thorri RAISEERROR from CLR stored procedures

  I'm writing: SqlContext .Pipe.ExecuteAndSend( new SqlCommand ( "RAISERROR ( '" + e.Message + "', 11, 1)" )); to execute a RAISEERROR from a CLR stored procedure. It works, but in the SqlError list I get in the client, there are two more errors that say something like '{System.Data.SqlClient.SqlError: A .NET Framework error occurred during execution of user defined routine or aggregate 'Customer__Update': System.Data.SqlClient.SqlException: noupdate ...' ... Is there any way to just get the message I'm sending Thanks I tried this but the error is not caught by a begin try/end try ... begin catch/end catch block in transact sql code. Is there a way to send a custom error which can be caught in TSQL ...Show All

• Hoopla Sql Management Studio Express

  I recently installed Sql Server Management Studio Express on my computer. I am unable to connect to a remote instance of Sql 2005 using this program on my computer. I have shut off windows firewall as well as my third-party firewall but have come up with the same error message. TITLE: Connect to Server ADDITIONAL INFORMATION: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) I installed Management Studio on another computer and was able to ...Show All

• lzhs Gurus, Is it possible to pass a DateTime parameter to a subreport

  Is it possible to pass a DateTime parameter from a master report to a subreport. I have managed to pass a string, but when i pass a DateTime parameter some error regarding its type is thrown. Please point me in the correct direction. Many Thanks. Ok, it took me a while but my language settings were set to en-US. Hence the date format changed. Its all working now. Many Thanks, this is the exact approach i took. Does anybody know how to pass a datetime parameter from a master report to a subreport. When you insert subreport component into you report, this subreport has Parameters property. Using this ...Show All

• Rattlerr Parameters Changing Parameters

  I have two parameters, Vendor and Status and I need to change the value of Status when the user changes the vendor from all to a single vendor and grey out the status parameter or just have it show all. Any Guildence . I ened up finded that this could not be done. So I created a textbox that would come up when the users query would not return any results and tell them that they would need to select All to find out the info they were looking for. Are you viewing your reports through the web browser, or through a viewer control in a program I don't know if this is possible for doing it through the web browser. But if you're doing it through a program, you could writ ...Show All

• JRV2 strange refresh of the parameter area

  Hi, I have a couple of parameters on a report that prompts the user. My problem is that I fill a value in the 1st parameter and to fill the next one I have to click twice on the input because of a strange refresh that my browser does when I left the 1st parameter. This is happening for all parameters, not only between the 1st and the 2nd. Do you have any idea how can I make to avoid this because is so unfreandly for the user! We have the same problems with our report parameters in several of our reports but we dont use expressions nor dependencies. All report parameters are mainly connected to 2 data sets. 1 for populating the dropdown and the other is for populating the default values. My question i ...Show All

• Patrick Tremblay Defragmenting for SQL server performance???

  Can Anybody guide me whether DEFRAGMENTING the drive improve the SQL Server performance in general. What should be the location of the DATABASE files and the TRANSACTION log files. Should they be in a single drive or seperate drives Thanks in advance Jacx For best I/O performance they should reside on different drives. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Declan_ Is ProcessAdd done within a transaction mode?

  Is ProcessAdd done within a transaction mode This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. You will need to wrap everything into transaction. I am not sure whether standard SSIS processing task can reuse existing transaction, but if not - it will be very easy to write custom transform using AMO, and keep session ID at the pipeline level. Your first task will be to begin transaction, and last task to commit it. Mosha Thanks,Mosha. For example, In SSIS, I ...Show All

• NiklasECG2 Formatting With Multiple Columns

  Hello, Is it possible to view the contents of a report in 2 columns for example, if i had a report contained a table with 1 column, could I, rather than epanding that table column down, use some of the room to the right of the table to "repeat" the columns in the table to show more of the data In crystal reports you could achieve this effect by using the "format with multiple columns" option. If you need a better explanation please let me know. Thanks in advance. All I want to know is confirmation that this can't be done. thanks ...Show All

• moke48462 Problem with Date query

  Hi! I'm trying to query an Informix linked server to import data into a SQL database. The OLE DB Provider is ifxoledbc. I can do general queries such as Select * from openquery ( INFLINKMON , 'SELECT * FROM mydatabase:mytable_t ' ) but when I try to add the where clause Select * from openquery ( INFLINKMON , 'SELECT * FROM mydatabase:mytable_t where mydatabase:mytable_t.d_thisdate = "04/12/2006"' ) I get the error: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "SELECT * FROM mydatabase:mytable_t where mydatabase:mytable_t.d_thisdate="04/12/2006"" for execution against OLE DB provider "Ifxoledbc" for linked server "INFLI ...Show All

• TheViewMaster Default Report Server Web Page

  I've only just started working on Sql Server Reporting Services 2005, My role is mainly that of administrator (some other unfortunate sole will be doing the development) However, I'm having some problems configuring the "Welcome" screen on the server. Currently it looks like a default web directory, I can click through to Data Sources and a directory containing the current test reports: Looks like: Wednesday, January 10, 2007 4:14 PM <dir> Data Sources Wednesday, January 10, 2007 4:14 PM <dir> Test Reports Clicking on Test Reports gives: [To Parent Directory] Wednesday, January 10, 2007 4:14 PM 15193 Basic Test Report Question is: Is there an XML (Or XSL) file somewhere where I can define how the websit ...Show All

• Fille Setting Local Report Data Source

  I am a college professor and am updating my undergraduate database course to use Reporting Services as the reporting tool. The student labs cannot run IIS so I assume that using server-based reports is out and am looking at using local reports and the VB ReportViewer control. For several reasons (waaayyy too long to list here) I do not wish to use the drag-and-drop datasets that seem to be the core of the ADO.Net 2005 architecture. Instead I prefer to create connections, commands, and datasets in code and to set data binding and manage data updates in code. All command objects map to SQL Server stored procedures. I need to be able to do the same thing with reporting services local reports but have run into a brick wall in getting the ...Show All

• Mohammed Aquil Cannot connect locally to SQL Server Express

  Hi, I'm trying to connect to a SQL Server 2005 express on my local Windows XP Professional machine. I've searched the the MS fora and Google but all the answers I find relate to trying to connect to a remote DB, not local. I run the aspnet_regsql.exe program in the interactive wizard mode, and in the Select the Server and Database step when I click on the Database drop-down list an error box pops up: Connection failed Failed to query a list of database names from the SQL server. 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: Named P ...Show All

• Saravanakumars38 Drillthrough results conditionning

  Hi, I would like to be able to set a condition to define the results of my drillthrough in AS 2005. Let's use an example to explain what I am trying to do : We got a Cube with 2 dimensions ( Time, Products ) and a measure ( Sales Amount). In our cube we have stored detailed informations about our vendors, customers and stores. The following statement should return all rows from the columns Customers, Vendors and Stores names. DRILLTHROUGH SELECT {[Time].[Time hierachy].} on Columns, {[Products].[Product.hierarchy]} on Rows FROM My_Cube WHERE ([Measures].[Sales Amount] RETURN [Fact].[Sales Amount] ,[$Vendor].[Vendors name] ,[$Customer].[Customers name] ,[$Stores].[Stores name] I wonder if it is possible to set a conditi ...Show All

• Konstantin Kamanin upgrading to 2005

  I have been assisgned the task of upgrading to sql 2005. I was given a dell poweredge 1850 and the sql standard edition 2005 w/ 5 cal disk. I have only used sql a little to make data changes in tables. My boss expects me to figure this out on my own which I like to do anyway. I remember he mentioned when I am ready he would tell me the path to a backup. I guess there is a server on the network that is only in place in the case of the current live one going down. I have been reading this helpful site and hope someone can give me some basic logical steps to take. I feel overwhemed by all the data posted. Please help me if you have time. Oh ya, right now we have sql server 2000 running with about 20 databases on it. It has some tables that t ...Show All

• QWERTYtech SSIS CAL licensing

  Hello, How does licensing of SSIS work on a CAL basis As far as I'm concerned there are no users of it per se cos its a back-end process. Therefore, do you only need one CAL Thanks Jamie   The real question is how does MS view users. Based on their licensing doc, MS views each physical person as a user and not necessarily the number of user accounts.  Since running your packages doesn't require a physical user connected to the DB, I would assume you don't need any CALs.  I've run into these type of questions with licensing before and you may get different answers depending on who you ask.  I'm almost certain you need either 1 or 0 CALs in this instance.  Its better to play it safe and ...Show All