Answer Questions

• Normand43 Creating referential integrity constraints

  Two ways to do this... Creating the constraints when creating the data model OR using SQL to use the 'reference' constraint. Does 2005 provide any other automated method of creating the Primary Key - to Foreign key constraints without writing the SQL to do this Thx I don't know of any such rule. There are cases where using computed column is useful. But it is a proprietary feature anyway so for data modelling purpose probably you shouldn't worry about it. If you hit some design issues in SQL Server due to limitations you can use computed columns & indexes on computed columns. What do you mean by automated method Using DDL is not automated enough You could use SMO to create the constraints but you have to write VB.NET or ...Show All

• MNaveed Connection string from outside

  Hi there!! I want to make a package and pass connection string from outside say through .ini file, so that I can put package on any system and use some external source to pass connection string. How do we do this in SSIS Rahul Kumar, Software Engineer, India Hi, Package Configurations in SSIS are used for the same purpose that you are looking for. Package config can be used to pass on the values to the package at run time. For more details, please check http://msdn2.microsoft.com/en-us/library/ms141682.aspx Let me know if this solves your issue. Thanks, S Suresh When you go through the Package Configurations Wizard choose the ConnectionStri ...Show All

• Guustaaf Log Shipping between SQL 2005 and SQL 2000

  We have an environment where 3 SQL 2000 servers exist; one production servers and two standby servers that receive logs via log shipping. Everything works fine and it is stable. My client wants to get a new 64 bit server and run SQL 2005 64 bit version for the production box. Can we still do log shipping with the two remaining SQL 2000 boxes or do they all have to be on the same version and bit version Thanks Bill moving to HA forum. Hey Paul, When applying a transaction log built from a SQL2000 (version 80) instance to SQL 2005 instance but the database is in a (version 80) configuration I still get the following error: This backup cannot be restored ...Show All

• UmairKhan Error in installing SP1 or sp2

  I have a sql server 2005 developer edition installed on my windows xp system. I apply sql server 2005 sp1 then sp2 all does successfully. Now I have installed same sql server 2005 developer edition on windows 2003 server When I installed sp1 or sp2 i get the following error --------------------------- Invalid Login Information --------------------------- Your account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To proceed further deselect the instances to which connectivity cannot be established. --------------------------- OK --------------------------- I have done every thing.PRovided sql server as wel ...Show All

• David Beavonn Problem rendering embedded images

  We render a MapPoint map image using a plugin in a number of reports. Up until recently it was all working fine but now we get the following exception: The 'V_DownloadValuerRunImageButton' button caused an error:\nSystem.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException ...Show All

• hrvat Reporting Services SP2 CTP "Select All" back in preview but not on web

  Hi I've installed SQL Server Express 2005 SP2 CTP specifically because I require the "Select All" checkbox to reappear in multi-value parameters. This was successful in Business Intelligence Studio and when i preview the report the MV params have Select All options. However, when I deploy to the web the MV params do not have Select All options. Why would this be Regards Adam Whitehead Thanks Damn wish I had known that one was available on the web! I have already updated to SP2 CTP and am unsure if I can roll it back and then apply that hotfix to SP1. Regards Adam Whitehead Is your webserver pointing to the DB you have applied SP2 to or to another Live server ...Show All

• AndrewBadera understanding execution plan

  can anybody explain wht each attribute means in execution plan and also in wht terms do you use the values say estimated cost: 0.003283(99%). wht does it mean. Estimated Row Count: 1 Estimated Row Size: 18 Esitmated I/0 Cost: 0.00320 Estimated CPU Cost: 0.000080 Esitmated number of executes: 1 Estimated Cost: 0.003283(99%) Estimated Sub tree cost: 0.00328 Thanks Sandeep, the following has a pretty good overview of the info provided by an Execution Plan: http://www.sql-server-performance.com/query_execution_plan_analysis.asp Please see the following BOL topic: http://msdn2.microsoft.com/en-us/library/ms178071.aspx You are also looking at the estimated ex ...Show All

• Kardath Connect to SQL Server 2005 Problem

  Hi all, I have created an Outlook Add-in using VS2005, which basically populates a custom WinForm with some data retrived from the backend SQL Server 2005 database. The SQL Server is installed on the same computer as the development environment (VS 2005). The add-in code compiles OK and I have created a setup package for this app, which installs the required files with no problem. The package has been tested working on the development machine. But as soon as I install it on another computer (installation was no problem, and outlook launched the add-in as expected) and click on the add-in button I made on the menu bar, the add-in hangs up. I have checked the tables on the sql server and found that no operations was performed whatsoever. Sus ...Show All

• Adrian Foot Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0)

  I am using framework 1.0 to do the above tasks. Since there is no fileupload function in .net 1.0, i will be using the html control tools (file field) to do the upload option. i have totally no idea of how to start coding it...can anyone guide me through the steps thanks Hi, try the following links to get the code for loading excel information. http://www.codeproject.com/useritems/Excel_Application_in_C_.asp You will have to grap the information (whereever this is stored in your excel sheet and create new datarows of your table you want to update or compose your insert / update statements on the fly / or use a stroed procedure) if you need any assistance here, just raise a hand ...Show All

• merwy Report Server Project Template missing

  Hi - I have installed VS 2005 Professional Edition and SQL 2005 Developer Edition with all the options(Reporting Services etc...). When I try to create new project, there is no "Report Server Project Template" under "Business Intelligence Projects". How to get that tempalte Can any one help on this mail to : sugunsg@yahoo.com thanks in advance sugu Try reinstalling the client tools from reporting services again, there might have been a problem that could take longer to investigate than reinstalling the client components. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SnakeSV Excel Destination appends the excel file everytime a package is executed

  i have an SSIS package that exports to an excel file. This works fine. the problem is that it appends the data instead of overwriting the file. Is there any way to overwrite the file like you can with a flat file I have to email the file everyweek and don't want to have to clear it out manually. Any help would be appreciated Perhaps you can use an Execute SQL statement with a delete statement before the data flow task. That way you delete existing rows before loading the new one.   Update : I just tried that and did not work: [Execute SQL Task] Error: Executing the query "delete FROM         [Sheet1$]" failed with the following error: "Deleting da ...Show All

• eureka-eureka Crystal Report

  I would like to automate the printing of some Crystal reports that I run daily and was thinking about setting up a scheduled task to automate the printing. Any suggestions Cheryl I think you are in the wrong forum. This is for microsoft reporting services (similar to Crystal Enterprise). ...Show All

• BlackPepper Truncation warning, how to reset data flow columns

  I keep getting a waring: [Production IDW [1]] Warning: Truncation may occur due to retrieving data from database column "Industry" with a length of 16 to data flow column "Industry" with a length of 8. When I look at the industry lookup table the column size is 50. But the data flow metatdata is saying the oclumn is 8. How can I change the data flow column When I try to edit it and click on metadata it is uneditable. The field it is matching to is 50 and the field it is coming from is 16. I don't even have to close the window. I just click on another column properties, then go back to this one to see the value changed back. ixul. Sorry ...Show All

• Michael_317 Join on agragate function between tables

  A have a number of similar tables and what I want to do is to get the count of records grouped by day of week. All tables have date as an indexed unique column but the actual timestamps differs and have no relation. For one table I use this simple querry: Select DatePart ( dw , dato ) AS DOW , Count ( dato ) AS NOR FROM AWP2 where dato > '2006-08-11' Group By DatePart ( dw , dato ) A typical result: DOW     NOR 3           8934 6           22397 7           23328 1           23401 4  ...Show All

• _Michael_ Problem Installing SQl express

  hi, Im trying to install SQL express 2005 on my Desktop Computer and I keep running into the error "Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed .Net Framework 2.0 is either not installed on this system or is corrupt" when infact it is installed.. any sugestions By the way im Running Windows X64 Pro with a AMD athlon X2 3800+ CPU and 2GB of Corsair DDr2 ram I would try removing and then re-installing .NET Framework 2.0, the error would seem to suggest that there is a problem with your installation. I would assume that the .NET Framework 2.0 installer would tell you if you tried to install the 32-bit version on your x64 computer, but just the same, m ...Show All