Answer Questions

• Dan Christie New Subscription fails with "Object reference not set to an instance of an object"

  Using the web interface, when I click on the New Subscription icon for a report I get "Object reference not set to an instance of an object".  However, I can start the creation process for creating a new Data Driven Subscription via the web. From Management Studio, I can successfully create a New Subscription (the same one I was trying from the Web).  I am using the same user account in each case to start the process, and it has admin ...Show All

• Ron Loxton SSEUtil

  I'm trying to list the databases that are currently attached to a user instance using SSEUtil, and it doesn't seem to work. I use the following command line > SSEUtil.exe -l -s .\<InstanceName> -child <username> and all I get in return is Using instance '\\.\pipe\F11E6321-6991-47\tsql\query'. And nothiong more. Am I doing something wrong ...Show All

• vidh2005 Improving Cursor Performance

  Hello Can we use rowsets in sql server triggers and stored procedures for improving cursor performance. Any other solution in this context is welcome Chikuu Why are you using cursors There are very few problems that require use of cursors. And using them within triggers is even more of a performance hit. Try to use set-based operations inside triggers so it can execute quickly and reduce b ...Show All

• Ashish Kaila AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous ...Show All

• percent20 System Tray Icon Missing?

  Hi all, I apologize if this question has already been asked a dozen times, I ran a search and came up with nothing, soooo... I installed SQL Server 2005 Express Edition SP1 + SQL Management Studio Express. I attached all my old databases, and setup named pips, tcp/ip, etc, but for some reason, I don't see a SQL 2005 Express Icon in the system tray to indicate to me if the Server is running or not. now I undestand Express doesn't come ...Show All

• Tom Gilkison using SSIS package to connect a remote sql server--login failed.

  Hi, i created a SSIS package to import data to a remote sql server, using the following connection string: "Data Source=My-SQL;User ID=PortalUser;Password=Password;Initial Catalog=TestOMIWarehouse;Provider=SQLNCLI.1;Auto Translate=True;" ; and got an error "Login failed". When i give PortalUser a sysadmin server role, it works. But i don't want to give PortalUser a sysadmin role. Any suggestions Is sysadmin role ...Show All

• Dave19 I want make table 4 like this one in SQL server 2005

  I Have 3 table Like this: Table 1: Name = Tbl_Mian_code M_Code Master_Code Master_Name Main_Type Main_Gruop Main_Txt 1001 1001 Bank 01 01 1002 1002 Cash 01 02 1003 1003 Good's 02 01 Table 2: Name = Tbl_Mian_code Id_2 Main_Code Sub_Code Master_Code Master_Name Sub_Txt 1 1001 0001 1001 0001 Bank_Visa ...Show All

• EnzeroX sql server 2005 RS multi-value params june ctp

  I have a very simple report with two non-queried values in my param list and the multi-select params box checked.  The dataset only has two records, represeneted by the two params.  The report always returns both records in VS and report manager whether I select one param, both, or the "select all" option.  Anyone esle have this experience Microsoft SQL Server Report Designer   Microsoft SQL Server Report Designer Versi ...Show All

• Tomas35595 Executing .sql file using SMO

  Hi all, Is it possible to execute a .sql file using SMO. like in old days we used to use osql.exe to execute the sql files Thanks in advance Rujith Either replace the GOs in the script or slit the string into a string array which can be executed one by one. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi This code exevuted for some .sql file ...Show All

• DaveAnson Apply buttons not submitting changes

  Hi, None of the submit "Apply" or "OK" buttons are submitting any changes with in Report Manager. The page does not go any where when these buttons are clicked. Is this a limitation of the Evaluation version of RS 2000 Thanks, Drew http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=146347&SiteID=1 ...Show All

• Carlos Adriano Portes XML Schema extension behaving differently between SQL2005 and VB.Net 2.0

  In summary my problem is: - I have two schemas 'Parent' and 'child' - The child schema extends the parent schema by adding one attribute and redefining an attribute from the parent - VB.Net permits the two dependent schema definitions in a schemaset - Creating the two schemas in a SQL2005 xml schem collection results in the error "Derivation by extension may not redefine attributes" I would like SQL2005 to exhibit the same behaviour as VB.Net ...Show All

• chmur getting data from Sharepoint lists

  Hi, I'm trying to get data from WSS lists by web services. I think there are two ways: - using SSIS standard components (Web Service Task) and - creating a custom source adapter. My problem with the Web Service Task is, that the WSS method GetListItems has some non-standard parameters (see part from wsdl-file below). Thus, after selecting the method in the editor an clicking on "Ok", I get the error message "The selected ...Show All

• smilek Unable to link except to SQLClient

  Unable to create a linked server. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server with these: Provider: Microsoft Jet 4.0 OLEDB Product Name: Microsoft Office Access 2003 Data Source: C:\Documents and Settings\Jay\My Documents\nwind.mdb Provider string: [copied from a Datalink file Acc.udl which tests OK for connectivity with Microsoft Jet 4 ...Show All

• Masud Moshtaghi Default FontFamily and FontSize

  Hi all, Is there a way that I can change the default values for the FontFamily and FontSize of the controls Currently, each new control that I use is set to Arial - 10.  Even if I copy and paste a control that has been changed, the values will still be defaulted to Arial-10. Thanks. ...Show All

• Oso Hada Problem selecting Group header should remain visible while scrolling

  I selected this option in a report and when I try to open it from reportserver it raises this exception An error occurred during rendering of the report. (rrRenderingError) An error occurred during rendering of the report. Object reference not set to an instance of an object. Any Ideas If I uncheck this option the report renders fine, but I need to show the first column of the matrix while scrolling the report. Thanks in advance. ...Show All