Answer Questions

• AIMDBA SQL Server 2005 SP1 upgrade results in build 2040

  I have SQL Server 2005 Standard installed on a Windows XP SP2 PC. I tried to install the SP1 upgrade from http://www.microsoft.com/downloads/details.aspx familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en , which is listed as build 2047. I installed the upgrade and each upgraded component reported success, and I rebooted the PC. However, checking the version of my SQL Server as per KB321185 results in version 9.00.2040.00. There are errors at the end of the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log log file as follows : MSI (s) (54:A8) [15:57:42:059]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' installed successfully. MSI (s) (54:A8) [15:57:42:059]: Not ...Show All

• Kevin O Donovan Image Rendering Problem with Custom Assembly

  Hi, Can you pls suggest what could be the problem the same report with images[same for test] from DB and custom assembly [it takes a id and return image as array of stream ]works fine in Visual Studio[i ve deployed to private assembly and to the reportserver-bin folder]. However the same assembly doesnot work after deploying to webserver. Note that images works fine with CUstom Assembly in Visual Studio and i ve deployed the dll to both C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin and to C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies i also tried GAced but with no result.The sameassemby although rendered fine with the Vs studio. Also it was strange that ...Show All

• Blast SQL Server Configuration Manager to change run as account

  Hi, For the past few days i have been stumped on this problem. Our environment is the following: Windows 2003 R2 64 bit  SQL 2005 SP1 64 bit active/active cluster with several instances. Right now all instances use the same domain account to log on. For security reasons i wanted to assign a domain account for each instance to use. Now the problems start when i am using SQL Server Configuration Manager. I am usually successful in changing an instances SQL server account but once i try and do it for the SQL Server Agent i start to get errors and i am unable to get both running at the same time. Sometimes i will get wmi errors and sometimes the mmc just stops responding. The WMI error i get often is: The server ...Show All

• Jonas1980 Dynamic Windows Authentication

  Hi The Parent Package has a Loop Container. The Loop Container calls the Child Package and in the process the connection manager properties are changed using package configurations. When the packages are tested in BIDS both Windows and SQL authentication work. When the packages are scheduled on SQL authentication works and Windows authentication fails. (The account which executes the schedule has permissions to all the data sources required. The SQL Agent Service Account has permissions. In addition a crendential was created using a different account which also has permissions and this also failed.) If the connection managers are made static then the schedule executes. Any ideas would be appreciated. Thanks ...Show All

• Rush hour limit number of attributes in a model

  Processing Association Rules model on SQL 2005 Standard edition produced following error: "Error (Data mining): The 'WO_3' mining model has 6690 attributes. This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm associated with the mining model." How can I limit number of attributes in a model Thank you worked!! Thank you You need to limit the attributes you feed to the model from the source data. In this case you are using a nested table, let's assume "Products". Each nested key e.g. "Product Name" becomes an attribute. You need to limit the product set you want to use to ...Show All

• Radith Restore issue

  I have one MSDE 2000 backup.I installed Newly SQL Server 2005 Express .I want to restore this MSDE 2000 backup to SQL Server 2005 Express.What and all steps I have to take to restore this backup. Filson If you are new to SQL Server 2005, use the management Studio Express which can be downloaded for free to administer the server. There you can do a backup by right clicking on the Server node > Restore... HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Alex Foygel Export to CSV fails with 3rd party web app

  From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer. Is there something special that needs to be done Could I have an old file Could it be something in my report We always have the following components: -- textboxes in the page header and footer -- page header refers to parameter values; page footer refers to globals -- 2 date parameters and 1 hidden boolean parameters We're running SQL 2005 Reporting Services, and I have SP2 installed. (I write the reports, not the web app) yt Hi, I have the same problem. But I don't have the same name ...Show All

• Ferener Upgrade.exe You have got to be kidding!!!!!

  It’s 4Q 2006, Microsoft is touting .NET 3.0; VS 2007 yada yada yada.. And along come the SQL Mobile guys with an upgrade tool that has to be executed from a DOS command. Don’t get me wrong I love DOS commands. But, are you telling me my neophyte users out in the field going to have to key: Upgrade.exe /S “\SD Card\DataDir\SQL.SDF” /D “\SD Card\DataDir\SQL30.SDF” Delete “\SD Card\DataDir\SQL.SDF” Rename “\SD Card\DataDir\SQL30.SDF” “\SD Card\DataDir\SQL.SDF” I don’t think so…… I wrote a utility to do the above. However, I launch Upgrade.exe with a CreateProcess() and I have no good way to determine if it was successful; other that reading upgrade.log and make sure there is no 0x8nnnnnn message in it; ...Show All

• DigitalPenguin what s the equivalenet of object_definition in sql 2000 pls

  This is not working for me in sql 2000. It works well in sql 2005 use mosaikdb741 select object_definition(o.object_id),o.name from sys.objects as o thanks a lot OBJECT_DEFINITION is a new function in SQL Server 2005. The nearest equivalent system stored procedure for this in SQL Server 2000 is the sp_helptext, which will only work for stored procedures, user-defined functions, triggers and views. SQL Server Helper http://www.sql-server-helper.com how d this translate using sp_helptext then exec sp_msforeachdb ' select '' '', o.name, object_definition(o.object_id) from [ ].sys.objects as o where object_definition(o.object_id) like ''%mykeyword%'' and o.type=''P''' Than ...Show All

• China Subba Rao Slowly changing dimension - always shows rows as changed?!

  I created a simple type 1 slowly changing dimension, setting all the columns to "Changing Attibute". The first time I run the package it sees all rows as new and imports them into the dim as it should. Next time I run it put 100% of the rows into the "Changing Attribute Updates" and runs an update on all 90,000 rows - updating the rows to exactly what they were before If I take the DIM and the Source in SQL and join on every row the join succeeds (meaning the rows match perfectly). Shouldn't the SCD object just ignore the rows if they match Or does it assume that ALL incoming rows are either new or changed (if so why is there an output called "Unchanged Output" ). Is there some "gotcha" I am mi ...Show All

• thelonesoldier Separate data stuff from applications

  Hi, This is probably for most of you a very basic question. My goal is to define in a seperate instance from application all infos related to DataSets and DataAdapters that are needed when connecting to a specific database. Why First, I would like to be able to have in a single instance everything needed when hooking to a SQL Server Express database and in an other everything needed when hooking to a SQL Server CE database. Then, from application, I would like to be able following a few basic configuration steps to choose from one or the other, or even both in specific cases. Second, I want to be able to seperate Database related stuff from application so that I can re-use everything from any other application when needed. ...Show All

• creaturita Tables don't show up in SS Management Studio Express

  Hi Folks, I have a strange problem where I run SQL Scripts to create tables in SS Management Studio Express. The Scripts run OK but the Table names don't appear in the left-hand Object Explorer window. I know they are created because I checked with Toad and I can also INSERT and SELECT data from them. How do I get them displayed I'd appreciate any suggestions. Thanks very much. Barry Hi Barry, Try Refreshing the node. Right-click on Tables and click Refresh. SSMSE doesn't automatically refresh the list of objects displayed. Mike Mike and Jens, Thanks for both your fast responses. Unfortunately, I still have the problem. How do I find out which Datab ...Show All

• RueSam Cannot create diagram in SQL 2005

  i get the following message Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. I am the db owner but still wouldnt let me install and create diagrams. help! cheers I moved this thread from SSIS forum...I hope you can get better luck here... hey i found the answer you gotta set the owner to sa and then go to the database properties, then options, then change compatibility fromn sql 2000 (80) to sql 2005 (90) too easy.. thanks buddy ...Show All

• M.N. Ahmed Sahib Deployment problem with protection level

  Hi all, I have a problem while trying to deploy my packages that are configured in ProtectionLevel=EncryptSensitiveWithUserPassword I use the Deployment Utility to deploy my packages. I set the password when deploying and the deplyment works fine. But I run the packages I have the following error : " Failed to decrypt an encrypted XML node because the password was not specified or not correct." Did I miss something Why not use protectionlevel = 'DontSaveSensitive" Well yeah you can still debug but you have to open each package to set the sensitive data back as they were removed when saved with ProtectionLevel=DontSaveSensitive Indeed I'm not providing the password when ...Show All

• ahmedilyas ReportServer DB and ReportServerTempDB databases

  Hi all, Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance. Thanks, Prashant You need CleanupCycleMinutes in rsReportServer.config -- The default is 10 minutes. <don't get me wrong here...> It doesn't really sound like you know whether large orphaned snapshots are a perf problem in your scenario...by definition, they shouldn't be, as they are just blobs sitting around doing nothing. Even if you clean up more often, there ...Show All