Answer Questions

• Orellang SSRS 2000 SP2 report cannot be exported to Excel

  We are running SSRS 2000 SP2. We have an Excel export problem with one report data. The error is: Microsoft Office Excel File Repair Log Errors were detected in file 'PPM_Report[1].xls' The following is a list of repairs: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. A search on google shows that this problem could occur on an ntext data field larger than x amount of bytes. http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c6a89889833c312c/c225157bf91e9949%23c225157bf91e9949 but the fact is one environment has the field up to 9324 bytes and still exports fin ...Show All

• Vikas H Serious error in RS licensing docs on MS web site

  Correct me if I'm wrong... There is a potentially costly error in at least 2 Reporting Services 2005 licensing docs on Microsoft’s web site. They fixed the docs a few months ago after I called and told them about it but, now they are bad again! Here are links to the bogus docs: http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx Both of these docs say that you need 2 SQL licenses to run Reporting Services 2005 on a separate server from the SQL engine. This is not true. You only need 1 license! You do of course need the correct number of CAL's or a CPU license. The license.txt file that ships on the SQL Server 2005 standard edition ins ...Show All

• GILNEI Copying a Datbase between two different servers

  Hello Everyone, I am new to SQl Server 2005. I have created a database on one machine and I tried copying it on to another machine where SQL Server 2005 is installed. Both machines have SQL Server 2005 installed. When I tried copying using copy database wizard its asking for the destination server. I have given the name of the destination server but its giving me error msg saying tht it cant connect. How to chk whether my destination server is online If it is not how to make it online Any help would be appreciated. Srividya. Remote connections are disabled by default for SQL Server. YOu will have to enable them first. For more information see my screencast on my site which covers th ...Show All

• Mike Phillips OLEDB XML Reader

  I need to read XML from an XML query using OLEDB reader. Is it possible I found code to load the XML from a data set. I tried the following code but the XML file was incorrect. DataSet dsXML = new DataSet (); OleDbDataAdapter DBAdapter = new OleDbDataAdapter (); OleDbCommand command = new OleDbCommand (); XMLDataDocument xmlData; command.Connection = conn; command.CommandType = CommandType .StoredProcedure; command.CommandText = "usp_GetXML" DBAdapter.SelectCommand = command; DBAdapter.Fill(dsXML, "XMLData" ); xmlData = new XmlDataDocument (dsXML); The XML file looked like: <NewDataSet> <XMLData> <XML_F52 ...Show All

• arogan PSSDiag Failed to instantiate an XML DOM

  Can anyone explain to me what I need to do to correct this I have ran the SAME PSSDiag install from the this particular server MANY times before. All of a sudden, it now fails to start and I find this error, that is posted in teh subject line of the thread, in teh Windows Application Event Log. If I need to install another app in order to correct this, please let me know if the installed app will need a reboot of the server to take affect. I have to schedule down time for that. Thanks ALL! Check with this http://www.microsoft.com/downloads/details.aspx familyid=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en ...Show All

• danpaul88 Question on Microsoft Association Rules

  I build a data mining model to predict what are the best studying methods for the student to pass the examinaton. Create Mining Model StudentAssociation ( Student_No long key, Gender text discrete predict, PassOrFail text discrete predict, StudyMethod table predict ( MethodName text key ) ) Using Microsoft_Association_Rules ( Minimum_Support=0.02, Minimum_Probability=0.03 ) The mining table will contain all the methods that the students use, no matter their examination is passed or failed. The value of PassOrFail will have either 'Pass' or 'Fail'. According to the above model, can I query the best studying methods Or I should only train the model with the student who pass the examination, and ignore all the failed. Tha ...Show All

• LordZoster How Do I Create Table Relationships?

  I have spend days researching this and found others with the exact same problem but there are no useful replies as people don't seem to understand our problem. Please read this carefully... What is the best way to create relationships between new SQL tables For example, say I want to create a new database with tables for Customer, Orders and Details, how to I relate these tables - Edit via the Dataset designer in Visual Studio 2005 - Use the Server Explorer's Table designer in Visual Studio (not sure how to use the 'relationship' icon) - Use SQL Server Managment Studio Express (SSMSE) Database Diagram - Something else I am using Visual Studio 2005 Standard and SQL Server 2005 Express (SP1). I created a new database in Visual Studio ...Show All

• Zoinky OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Gravy Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, Hi Jamie, From my front-end app, I use Execute method.. Dim pkgLocation As String 'Para que no choque con el objeto APPLICATION DE SYSTEM.WINDOWS.FORMS Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package Dim app As New Microso ...Show All

• Al Chu '.bcp file is corrupt' with dynamic snapshots

  I have merge replication set up between sql mobile and sql 2005 (just recently upgraded from sql 2000). My publication has around 40 published tables, about half of them are filtered. The other day I noticed that the initial replication to get the entire database was downloading the same tables multiple times. The last test was each table was downloaded 10 times. So I did some research which brought me to the following fix, which was to implement dynamic snapshots. However, when I try to replicate, it generates a dynamic snapshot, but it fails with the following error… An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before ...Show All

• abcdefgqwerty2 How to do multiple inserts for one row of data?

  I need to insert multiple rows for input rows that meet certain conditions. My input data is as follows. ZIPCode, Plus 4, Range, City, State What I need to happen is that if there is a value in the range column that is > 0 then I need to insert a row for every range item. For instance say I have the following data. 54952, 1001, 10, Menasha, WI What I need imported is : 54952, 1001, Menasha, WI 54952, 1002, Menasha, WI 54952, 1003, Menasha, WI 54952, 1004, Menasha, WI 54952, 1005, Menasha, WI 54952, 1006, Menasha, WI 54952, 1007, Menasha, WI 54952, 1008, Mensaha, WI 54952, 1009, Mensaha, WI 54952, 1010, Mensaha, WI 54952, 1011, Mensaha, WI Any help in pointing me in the right direction would be great. Thanks for your help in advance. ...Show All

• xyte Editing ModelGenerationRules.smgl

  Hi, I need to modify the ModelGenerationRules.smgl file to increase the mandatory filter setting of 5000 records. This is much too small for our database. I know where the file is but I need to know how to make the change. Does anyone know how to change this Thanks BB I wound't recommend changing that file, but it is possible. There are multiple instances of the file, one is in Visual Studio's PrivateAssemblies folder, it is for Model Designer. Others are in ReportingServices\ReportServer folder of every instance of Report Server, they are for server-side model generation. You can open the file in any xml editor, for example, Visual Studio. The limit must be changed in 2 rules ($MarkLargeListsRuleName and $MarkVeryL ...Show All

• enric vives Getting the domain user running a report

  Hello everyone, I've created a report that will be used by some of my users. I'm trying to get Reporting Services setup so that I can see the user that is running a report. I start a Profiler trace but it's not showing me the login credentials of the user. It shows me the user account that is set for anonymous access (IIS -> Default Web Site -> ReportServer -> Authentication and Access Control). Can someone tell me the settings for RS and IIS so that I can see the domain account of the user who is running a report via Profiler If not, can someone point me in the right direction of where to look for how the settings should be Thanks Jarret Jarret, Integrated security settin ...Show All

• Jay_Vora_b4843e Error installing SQL Express 2005 SP1 on XP Home/SP2

  As the subject says, I am getting an error installing SQL Express 2005 SP1 on XP Home/SP2. I have never had a previous version of SQL server installed. I have never had Visual Studio installed. I have tried extracting the setup files and running from a different directory. I have tried installing the advanced package as well with the same results. When I run the setup, the Client and support files are successfully installed. It then goes on to the system analysis, where I get one warning about my hardware but I have checked the help file and my system appears to meet the system requirements. After I click Next from this window is where I get the error, " Error writing to file: Access is denied. . Verify that you have access to that di ...Show All

• seco Icon not displayed correctly for custom component

  So i finally figured out how to create custom transform and add an icon to it. However - when i added the component to toolbox it appears as a file icon (when i didnt have icon it appeared as a blue box) - in the data flow designer it appears as the correct image. From BOL wrote: "The Data Flow toolbox uses the 16x16, 16-color image type, while the design surface of the data flow tab uses the 32x32, 16-color image type. Both are default image types for icons created using Microsoft Visual Studio 2005." I assume this has something to do with it - my ico is default 32x32 - however, what would be the way to fix it hi, i think this this is the same as my problem before. Your Integration servic ...Show All