Answer Questions

• Bene_Ries Freeze Panes?

  Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report Similay to the freeze panes functionality in Excel. Thanks Hi, I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error [rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ inclu ...Show All

• PF Change the type of an expression container

  Hi, I use expressions to build the SQL query that is executed by the data flow. Today, I ran into an issue. For the first time the SQL query has exceeded 4000 char so the expression cannot be validated and it is not possible to use it. Is there a way to change the expression datatype to nvarchar(max) instead of the default nvarchar(4000) Thanks, Philippe Is there any way around the 4000 literal ...Show All

• PSuo SQL Server Stored Procedure Transaction Problem

  Hi, I got a problem when executing a stored procedure in SQL Server 2000 Query Analyzer. The first time I run it without using 'Begin Transaction' & 'Rollback Transaction', the stored procedure works fine. The second time when I use 'Begin Transaction' & 'Rollback Transaction' to test it, the procedure keeps running but halts at the end of the cursor and never jump out from it.  However, no error return by the query analyz ...Show All

• grim1208 Add filters dynamically

  Hi, I am using a ReportViewer control on the windows form to connect to Report Server, process the report remotely (ServerReport) and render the report in PDF format. The user wants to add some fiter(criteria) each time before the report is rendered. The filter (criteria) is generated separately. The original content of RDL should not be changed. I know, Report Builder is an option available. But, the end-user doesnt want to use Report ...Show All

• massiveoni Confused as to which SQL Server version the Express languages work with

  I have SQL Server 2005 Developer Edition installed on my PC. I also have the Express Editions of VB and C# installed. Is there any purpose served in my installing SQL Express, also I've read comments that the Express languages can only connect to SQL Express databases and not SQL Server 2005 databases; however, I'm not sure how that is enforced. The 'connect to database' wizard does seem to be different in the Express IDE than it is in Visu ...Show All

• net_starter Errors in relational and OLAP Engine

  Hi Edward, You told me to look into my data source view yesterday. In my data source view i have the dbo.Prescription instead of dbo_Prescription though the error message indicates that the dbo_Prescription table is missing in the data source view. as below. <Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Parallel> <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " ...Show All

• rkin005 Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Hi there, di you get a reply to your query as I am experiencing the same problem. Please e-mail me & let me know. Many thanks I got the same issue, it also w ...Show All

• E. Richards will SQL and windows authetication applied during setup has other implications?

  I choose SQL and windows authetication during SQL Express 2005 install. Will this has any impact on the connection string in my Visual Studio 2005 environment ok thanks!!!!!! The setup during installation only predefines what you *can* use. If you chosse mixed authentication, like you stated above, this should be no problem, you can use WIndows authentication which would be ...Show All

• Almero Copy data from one table to another

  On the OLE DB Source, I have as following: select field1 , field2 , field3 from table_source On the OLE DB Destination, I used fast load option with table lock checked, and check constraints to copy data to table_destination. Both table_source and table_destination have the same table definitions. After the dtsx package ran, the number of rows copy over to the destination is not same. I got different results from different runs. This ...Show All

• Mike Turner - MSFT Scripting Options in Management Studio

  How do you change the scripting options in Management studio For example, I want to script the create statement and permissions for a sproc; however, it won't add the permissions - I have to manually add it. The lack of scripting options is a HUGE discrepancy with this tool. The old Enterprise Manager tool did a much better job at this. Am I going to have to use 2 tools Works. Would be nice though if the o ...Show All

• DigDig Two strings to be compared have different collation.

  I've written a stored proc which passes in an SqlString parameter and compares it with an SqlString read from an SqlDataReader. I get the following exception: System.Data.SqlTypes.SqlTypeException: Two strings to be compared have different collation. Any ideas on collation inside CLR stored procs Thanks. Thanks Jens, That link really helped. I've got it working now. ...Show All

• Niksta Should I use Notifications for this?

  I'm new to learning the notifications architecture and would like to know how heavy into learning it I should go for my project. I have a service the will allow websites to send info to a client application. The app gets downloaded by members of their service. There is the client and the website module for the client. The user can have mutliple website modules. The websites send a soap update of the info that they want to se ...Show All

• Cryo75 Report Builder limitations

  Can anyone confirm the following 1. Can't add images to reports. 2. Can't have fields in a non-tabular layout (e.g. mailing labels, letters, etc.). 3. Can't control column or row spacing of fields or have details that span more than one row. Thanks. Alrighty then. Can anyone at least tell me if there are any 3rd-party products out there that might be more robust than Report Builder ...Show All

• kiewie impoert and export data

  where is the import and export data function in sql server 2005 express i have a data in ms access which i want to import to sql server 2005 express.. thank you i tried installing the books online, but after installing it my mgt studio express wont work anymore..whats seems the prob i installed sql express through the visual basic 2005 express thanks. i dont understand what y ...Show All

• Andrew_J There is already an open DataReader error when scripting a view

  SQL Server Management Studio: When I try to script a view by right clicking on the view and select Script View / as CREATE TO I get the following error: Exception has been thrown by the target of an invocation. (mscorlib) There is already an open DataReader associated with this Command which must be closed first. (System.Data). This must be a bug Charles http://lab.msdn.microsoft.com/productfeedback/ This looks like a bug can you ...Show All