Answer Questions

• Vonfranzken Installing SQL Server 2005 on Windows XP Pro x64

  On MSDN, I have downloaded "SQL Server 2005 CTP - September 2005 - Enterprise Edition - 64-bit Extended - Servers (English)" that I am trying to install on WinXP Pro x64 (EMT64 machine). Unfortunately, I am not able to install SQLSRV2005, indeed during the setup the option such as "SQL Server Database Services" are grayed (i.e. not clickable, idem for Analysis Services). The only thing that I can select is "Workstation components". Is it possi ...Show All

• rzddr How would you archive a subset of your db if you had to?

  I have a database with 6 tables that are all joined together in one way or another. At certain points in time I want to take a subset of the records in one table(based on a criteria in that table) and 'catalog' them somehow along with the related records in the other tables. It's somewhat hard to explain. I want to preserve a point in time in the db so that at a later point in time I can reinstate the records as they were in the past. Is this ev ...Show All

• captainsilver Source Code control and SQL Server express??

  Hi, I was wondering if anybody could advise on source code control for SQL Server express, for the table schema and stored procedures I currently use Sourcesafe V6 to work with visual studio 6 and 2003 (although it isn't integrated in 2003), and wondered if that can be used Any suggestions would be greatly appreciated, as I see this as a disaster waiting to happen! Thanks in advance. Mark There ...Show All

• KyleT is this possible in SSIS?

  I got a OLE DB source pointing to 1 table and 1 flat file destination. currently this is how i export data from 1 table to 1 flat file. To make things easier, I was wondering whether i can have only 1 OLE DB source pointing to few tables pointing to few file destinations so I dun need to create 1 SIS project for each table data exporting. anyone can help me ok Jamie, lets look at i ...Show All

• Pastor Rod Automatic synchronization of lookup columns

  Data Flow: Step 1: I use a OleDb Source Task to read data from a table (say table A) with 5 columns. Step 2: Then I use a lookup task to add a sixth column (resulting from lookup on table B). Step 3: Then I save the 6 columns to table C using a OleDb Destination Task. Now, I go to underlying database and modify the tables like: - remove 1 column from table A (not the column used for lookup later). - remove 1 column from table B ( ...Show All

• nadlerb WebParts not found for Reporting Services

  I created my first Webpart .aspx page in SharePoint 2003. I created a new Document Library and assigned my webpart page to that library. Now when I go to Document Libraries, click on that webpart, I get the page but I no longer see the buckets for the layout..nor do I see the Explorer to allow me to try to add webparts. How do I get to this screen again that allows you to drag and drop items into my page It's just a blank page with a header righ ...Show All

• Michael O. Schoneman Count CustomersOrders

  Assuming you have the CustomerID in the Orders table as a foreign key back to the Customers table, you can do a group by on the Orders.CustomerID and do a count. Using the Northwind database schema:   select CustomerID , count ( OrderID ) from Orders group by CustomerID This will only give you results for the customers that have orders. If you need the customers without orders as well, ...Show All

• AlinB Installing SQL Server 2005 Express

  Downloaded the program and followed the instructions (as vague as they are) the only thing I see to execute is the configuration tools. I am certain I have missed something. Can anyone assist Many thanks!! thank you SQL Server Express, like most independent database systems these days does not run as a visual application the way Internet Explorer or Notepad do, instead it runs automatically behind the scenes as a system servi ...Show All

• HockeyNut SSIS doesn't start after applying sql2k5 sp1

  Got following error in windows app event log when tried to start SSIS after applying sql2k5 sp1, event id is 260: Microsoft SSIS Service failed to start. Error: Method 'GetVersionInfo' in type 'Microsoft.SqlServer.Dts.Server.DtsServer' from assembly 'MsDtsSrvr, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' does not have an implementation. Anyone got same issue and how to solve it ...Show All

• SHWoo creating document map using first letter of customer name

  I have a report that displays a list of customers with some drill down ability. I'd like to have a document map that would be a list of the first letters for each customer name e.g. A,B,C and then when clicked would go to the first occurance of a customer name starting with the letter that was clicked. I believe the only was to do this is to create another group above the customer name group with a field that is "=left(Fields!Customer ...Show All

• Ryan Rinaldi Passing Collections to Custom Code

  In RS2000 it was possible to pass the entire fields or parameters collection to a custom code function. So for example, Custom Code: Function Calc(pFields) as String Return pfields("fldname1").Value + pfields("fldname2").Value End Function Report Expression: Code.Calc(Fields) This also worked with the Parameter Fields Collection. It made it possible to move a considerable amount of logic to the custom code section. In ...Show All

• Reuomi Customizing the connection string to the server where sp will be created???

  When you create a SQL server project, it asks you for the connection string to the database. Can I change this connection string at run time . By the way it is included in the project properties at desing time. I don't really understand the question - the connection string you mention is the string which tells VS where the assembly and procs etc will be deployed, when you do Deployment - at wich stage would you ...Show All

• Matt Foley [264] An attempt was made to send an email when no email session has been established

  [264] An attempt was made to send an email when no email session has been established is the error I get when I try to send mail on the database. It is a SQL Server 2005 Standard edition. I have configured database mail and tested it and it works there, then I configured a database operator. then I just created a test job to notify the operator of the job completion, and the email fails. Any ideas Ryk Hi, ...Show All

• Galb How to Insert One Row with Multiple time depding on Source Column value in SSIS Pacakge

  Hi ! I need help for SSIS Pacakge. using condtional Split How to insert One records with Multiple time depending on Source column value .Is there possible to wrtie the condition in Conditional split. For Exmaple : Source Table Name : tbl_source following Column Name: col_Name1,Col_Name2,Col_Name3, col_Id,Col_Descrip table contain only one records:GRD1,SRD1,FRD1,100,Product I want Insert the Destiantion table the F ...Show All

• Laurent Liegeois my problem in detail

  How I can rectify divide by zero exception in stored procedure OK - so your database design is not so great You create a table for each month I don't know of any way to make SQL Server return 0 when you divide by 0. You can do something like: select coalesce(@i/nullif(@j, 0), 0) -- or select case @j when 0 then @j else @i/@j end when i write Query like select 4/0 then it display error msg - 81 ...Show All