Answer Questions

• Luke137 SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Josh Christie MSFT error trying to import packages to the MSDB

  When I try import a SSIS package into the MSDB I get the following error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: The SQL server specified in SSIS service configur ...Show All

• DarkNite AS2005 Cube Processing

  I have problems with processing cubes on AS2005. I get this error message while processing: Memory error: Allocation failure: Not enough storage is available to process this command. Error in the OLAP storage engine. This machine has 6GB of memory and once it hits 3.5GB the processing stops. AWE is turned on. I would appreciate, if anyone can help on this. Thanks, Gopal Analysis Services is not ...Show All

• Shajan Dasan Primary key error Uppercase/lowercase

  Hello, I've got a problem with 2 tables, the first one has not constraint and is used as a data source, the second one as primary and foreign key constraints and is the destination. In the first one the columns are : TABLE PROMOTION : PROMOTION_ID; PROMOTION_DESC; 16a;-20% discount; 16A;-30% discount; AbC;no discount; aBc; -90% discount; The second table, TD_PROMOTION, has the same structure, but the column PROMOTION_ID column has a primary key ...Show All

• Tobias Manthey How to: SQL Server 2000 Replication?

  Hi, Can anyone help me How do I implement SQL Server Replication Where, and how Do I have to download specific software to do this, or how What would be the right option Thanks SJB start by reading Books Online, see topic "Replication" ya thanks, I saw that after I posted the message. thanks ...Show All

• dpolyakov Object Explorer/Server Explorer Error

  I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM componen ...Show All

• Raja Pratap Reddy Complicated Query with Subs for Grand Total

  I'm trying to get the syntax right below.  Know that what I'm trying to do is correct (I don't want to explain why or the entire thing but just need help with correcting the syntax issues on the join and stuff: Errors: Msg 156, Level 15, State 1, Procedure IT_Get_ProjFee_GT, Line 205 Incorrect syntax near the keyword 'INNER'. Msg 156, Level 15, State 1, Procedure IT_Get_ProjFee_GT, Line 213 Incorrect syntax near the keywo ...Show All

• vivekr Limited number of assemblies available in Visual Studio SQL Server Projects

  Hi, When starting a SQL Server Project in Visual Studio, there are a very limited number of assemblies available to reference. Does anyone know why Specifically I would like to use "Microsoft.AnalysisServices.AdomdClient". Does anyone know how I could do that Best Regards, Johan Ahlen, IFS Thank you for your answers. It seems impossible to reference AdomdClient from a SQL S ...Show All

• developer74 Changing SQL-command with a script

  Hello I want to change the sql-command that is behind a ole db datasource with a script So that first the script is run and that the sql-command is changed Somebody who has any idea Thats indeed a dramatic change Can you do it then in Microsoft Visual Studio for Application Thx   g4rc wrote: can you give me a link to the post I cannot find it Its at the top o ...Show All

• vbBigNelson performance of indexed views

  I see their benefit -- trust me. one question I have is that it looks like my indexed view has to get updated each time the underlying base table changes. What happens if I do an insert or bcp into the underlying table -- will me table go offline while this data gets re-aggregated -- is there a way for me to schedule this I see UDAs as well, and I think they are more flexible, but I'd be concerned that they are getting too far away from the opti ...Show All

• Matt Olson Problem creating SQL Server Mobile Subscription

    Hi there When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process: Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x80004005 (29061)   An ...Show All

• Ubon94 Webbrowser navigation

  HI all, I am customising the MSreporting services browser out put. While creatting my customised reports viewer i found difficulty in navigating thru pages. Can anybody help me. In the MSReport viewer when report is generated it will show the number of pages and we can go next and last etc... In my viewer i put a webbrowser control and used the navigate method of the browser to get the report. But the problem is it only shows ...Show All

• Joel Just Joel Modify SSIS package saved on server

  I have saved an SSIS pacakage on my sql server. I am able to see and run the package through Integrations services. My question is, is there a way to edit the package through Management studio Thanks Jim Naturally you can import the package from the server into your solution, edit the package in the solution + test and then save to server. As Craig pointed out we do not enable editing of depl ...Show All

• Mandy Sweet 2005 Maintenance Plan or Security bug?

  Curious if this scenario is by design or a possible bug.   As recommended by MS best practices for SQL 2000 we always removed the BUILTIN\Administrators login.  After doing the same on our 2005 installations it appears to have caused errors in the edit\view functionality in the Maintenance Plans and jobs.  One example is to open a plan in modify mode and then select the logging button. - 'Unhandled exception ha ...Show All

• AMG44 DataBASE Mirror Resource

  Are there any good resources for data mirror in SQL 2005 SP1 I tried to search on microsoft.com, there is an article, but it is outdated, it only described data mirror in SQL 2005 RTM. appreciate any links or input. Owen What do you want to know There's: Functionality: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Best Practice: http://download.mic ...Show All