Answer Questions

• Chabs Integration Services Designer (Visual Studio) is very very slow

  Hi all I have some performance issues when developing Integration Service Package ... It is very very slow for example when I try to add new connection in Connection Manages, it takes about 2 minutes just to open the property window. On another pc in the same environment (Domain etc.) it works ok. In the past I have doing a lot of SSIS Packages ... Is there any cache to empty Thanks for any comments Best regards Frank Uray Do you have the SSIS service running That can sometimes speed things up because it caches information about tasks and components. Other than that - its more likely this can be attributed to hardware or network issues. I suppose it could be a million and one things. ...Show All

• Bill Martin What is the best solution for delivery of the big tables?

  Hi! Well.. I've several big tables which take part in the merge replication (web synchronization is used) Is there any *painless* solution to delivery these tables to the subscribers Otherwise I've the snapshot with dozens of Mb.. Yes, the Parameterized Row Filters can be used, but sometimes it's necessary to get the whole table Thanks Paul Sure, I use compression, but nevertheless the snapshot size is large... how about compression. there is an option in your snapshot folder to compress the articles You can try initializing via db backup, see BOL topic "Initializing a Merge Subscription Without a Snapshot". ...Show All

• Shippa Management Studio disconnects with error Msg 0, Level 11, State 0, Line 0

  I am trying to run the following: select * from sysindexes The operation begins and results are produced but after about 200 results, I get the error - Msg 0, Level 11, State 0, Line 0 - and it disconnects. This is a DB moved (restored) from SQL 2000 to SQL 2005. Any ideas would be appreciated. I am the "make do" DBA and not very good at it yet, I am afraid. Regards, Mike Hi, you should have a look at the event log. Seems that this is a more complicated error. is there a dump produced in the LOG directory of SQL Server HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Jens, Yes, Thanks for the assistance. I loo ...Show All

• Landon Parks Can't access analysis cube from other machines

  Hi, I have created an analysis cube in my machine. Now I am trying to access this cube from other machines. But analysis server is not being accessable from other machines. Hence I am unable to acces the cube as well. Please give some light on it. It is really urgent for me... Thanks Sourav Dhar Hi Michael, I am using Analysis Services 2000. Could you please suggest what permission need to create and how I am new to this area and need your kind help... Thanks, Sourav Hi Sourav Are you using 2000 or 2005. Sounds like permissions problems between the machines and users that are trying to connect. If you are using 2005 you may also need to check the surface Area config ...Show All

• alex_ending Is there a load event or run event?

  Is there a load event or report run event for a report that can be accessed I need to have my report jump to a certain url whenever it is run but I cannot use the jump to url because that has to be clicked. I need this to occur automatically. Any suggestions I still cannot get it to work. I do see the report trying to do something but not actually redirecting the entire page. Are there any permissions I need to set to allow such actions for a anonymous user Thanks. There is an OnInit event that fires each time the report is run. The method can be used in custom code like this, Protected Overrides Sub OnInit() ' do something End Sub Ian Thank you so much! That sounds like exactly what I was looking for! Re ...Show All

• dpetrek Stored procedure issues with reporting services

  Hi all, I have stored procedures that will run fine from query analyzer windows, from other programs, etc. When I try to run the sp from vs 2005 form with in a SSRS project, the sp just hangs. It will not return any records and the app says "Not Responding. This does not happen for all SP's only some of them. Any ideas Woyler, You can run a SQL profiler to capture the exec SQL statement being pass by the report service. I have enable to track a number of issues this way. It's a good way to eliminate the guess work. I hope this helps. Ham Hi, Is it possible that the date being passed is (re)formatted by RS in such a way as to return a much larger resultset than expec ...Show All

• LarBru SQL Server Compact Edition RC1 Released

  Dear Community, The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn’t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ . Please check out the RC1 bits. Thanks Sachin, Program Manager, SQL Se ...Show All

• Eugene Ye Incremental processing and aggregations

  If I use the incremental processing option do I have to issue a separate process index command to get the aggregations rebuilt on the partitions that has been touched Or is this handled automatically by the incremental processing command Thanks - I should have remembered that. The reason I didn't is that I'm using AMO and there seems to be no way to set the affected objects parameter using the ProcessableObject.Process method. In fact looking around a little with Net Reflector it seems this parameter is hardcoded to false in the statement base.WriteStartBatch(true,false) of the Microsoft.AnalysisServices.AnalysisServicesClient.Process method. In my current case I just added an extra row doing Proces ...Show All

• Horea Soanca MDX Performance Issue with TOPCOUNT Using Calculated/Derived by Time Specific Members

  I am new at The MDX game and need some help. I have the following MDX that executes a wee bit to slow when I specify one of the following members (See MDX below) [Measures].[Prio Shp Unt], [Measures].[Unit Variance], [Measures].[Prio Cst Ttl], [Measures].[Prio Awp Ttl], [Measures].[BM Variance] in the TOPCOUNT statement. I have arrived at the conclusion that the problem is because I speicfy a period at the member selection that is different to the period on my where clause. Now the problem is that both the periods are user driven and can be anything from current back for the last three years. In other words the users have the option to specify which two periods they want to compare. Also the TOPCOUNT measure is user driven and can be ...Show All

• simon burgess Analysis Services error

  I was able to build SQL 2005 cubes from my project. However, for some reasons, it doesn't work any more, and I have the error below. Anyone can shed some light would be greatly appreciated. Error 1 File system error: The logical file cannot be found inside the physical file. Physical file: \\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.6.dim\14.ERP Effective Month.Tbl Policy Coverage Data.dstore. Logical file: . Errors in the metadata manager. An error occurred when loading the Coverage dimension, from the file, '\\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.16.dim.xml'. Errors in the metadata manager. An error occurred when loadin ...Show All

• erikkl2000 Cannot open database

  My mdf file was deleted. I was able to restore the said file but unfortunately I can no longer open it. I have also noticed that the recovered mdf file was smaller than the file before it was deleted. What can I do to open the database file I have tried the following lines using osql utility. 1> use db1sql1 2> go Msg 946, Level 14, State 1, Server JDI11-31, Line 1 Cannot open database 'db1sql1' version 525. Upgrade the database to the latest version. ok - so the sp_attach_db you executed in the previous mail failed, but at least attached the DB in some form. There's still no way for you to get anything from the database - its metadata is corrupt in some way (as I explained previously) which is pre ...Show All

• Krasshirsch xml validation date type error

  This is my first attempt to load some XML validated against a schema. The schema is more complicated than this but I've been able to narrow it down to show the problem. After I load the schema and create the table which are successful, I try to perform an insert. The insert fails with the following error. Any help would be appreciated. Msg 6926, Level 16, State 1, Line 1 XML Validation: Invalid simple type value: '2006-08-08'. Location: /*:myReport[1]/*:Criteria[1]/@*:myDate CREATE XML SCHEMA COLLECTION myrpt_xsd AS '< xml version="1.0" encoding="utf-8" > <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs=" http://www.w3.org/2001/XMLS ...Show All

• MuscleHead sql 2005 install error. MODIFY FILE failed. Specified size is less than current size.

  I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size. I'll try to post the full log in a new post. I think the problem is coverd on the following knowledge base article: http://support.microsoft.com/kb/932593 Hi Could you please let me know which sort order you have used ( ...Show All

• John Petritis Using SQL-NS 2K5 -- a good investment?

  We are contemplating using SQL-NS 2K5 as a notification engine. After putting some time into it, going thru MSDN topics, tutorial and samples, trying to map it to our needs etc, I must say the jury is still out... I saw the following link and I identify with the notions expressed there on using NS (see highlighted quotes below): http://community.rampgroup.com/blogs/ramp_technology_group/archive/2005/12/03/59.aspx The point is that developing an NS-based application requires siginificant effort and frankly on various issues we could use some help (beyond "read Shyam's book"), and my feeling is that it is hard to get help. This is even more so considering we are developing a solution that we would like to deploy as part o ...Show All

• Alba Earlier question on ODBC compatibility

  Hi Chris: I am sure as you are aware only data adpaters in SQL 2005 out of the box are .NET Frameworks, in your answer to Stoobs, you state the ADO.Net framework does not have all the APIs. We're experiencing the same problem with the product and ODBC. Unfortunately we have a legacy MUMPs DB (that KBSQLODBC layer sits on top of, its a flavor of SQL from Knowledge Based systems) that our vendor is not going to update. Given that, how can we address the ODBC driver problem with SQL 2005 Is there going to be an update to ADO.NET Thanks, dfreshman ADO.Net v2.0 hs new APIs to support metadata retrieval. Note that you can transfer data via your existing ODBC driver and the .Net managed provider ...Show All