Answer Questions

• NateF SQL Server 2005 Sept CTP - Failed Installation - It Wants Disk 2????

  I have a brand new Dell server with a clean installation of Windows Server 2003 on it.  This server has never had SQL Server, Visual Studio, etc. installed on it.  So, this is the first attempt at installing SQL Server 2005 (in this case it is the Sept CTP). Everything appears to be working fine for the installation.  Then approx. half way through a message box pops up with a very generic message.  The message simply says to ...Show All

• VJ8 Unhandled Exception in Management Studio

  At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when ...Show All

• Im Greatest trigger issues

  I am running a trigger on a table (cusomfields) that is to fire when the table is updated or inserted. The trigger takes the new data and moves it to another table called search_products. Search products is made up of 5 columns (product_id, search_terms, name, vendor and keywords). The search_terms column is a combo of the name, vendor and keywords columns. When the trigger fires, the column in the customfields table that updates the keywords ...Show All

• Bets Package won't run correctly when called

  I have a stiuation where I need to import data from Excel and of course I'm using DTS to do so. Because the spreadsheets have a variety of datatypes in them, I have to make sure that DTS recognizes certain rows as INT so they will import properly, to do so I add 5 rows of 1's to the top lines of the individual sheets in the correct columns. After the 1's are entered I import to staging tables and then into the production tables. The package itse ...Show All

• Ben Music How to insert only new records (not already in destination)

  Greetings from a SSIS newbie still on the learning curve... I have a SQL query OLE DB Source that yields a result set that I'd like to put into a SQL Server Destination, but only those records that don't already exist in the destination. Is there a recommended (read: easy) way to accomplish this Perhaps a handy transformation I have tried to incorporate a subquery in my source query along the lines of: SELECT fields FROM table1 WHER ...Show All

• Rajiv Kumar Drillthrough Functionality via Excel Add-in

  Hi, I'm using the Analysis Services Excel Add-In to query a Cube built with partitions. When using the drilldown functionality for my current\default partition the function seems to work fine. However, when I try to drilldown on data in the other partitions, the following error message appears: "Unable to Drillthrough on this Cell" Would someone please be able to shed some light on this Many Thanks Jonathan Derbyshire     ...Show All

• Jennifer Huang Combine Data and Split into separate txt files for each header/detail row groupings

  I’ve created with the help of some great people an SSIS 2005 package which does the follow so far:   1)        Takes an incoming txt file.   Example txt file: http://www.webfound.net/split.txt       The txt file going from top to bottom is sort of grouped like this      Header Row (designated by ‘HD’)       & ...Show All

• Annihil8 Unable to read local eventlog (the parameter is incorrect)

  In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: RESYSHADOW Description: Unable to read local even ...Show All

• GreyWolf001au Remove the lines from the query output

  On TSQL Command of; set nocount on select @@version Getting the output as; -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ...Show All

• aslanky Customizing Report Manager options

  I would like to apply the folowing Customizations to the Report Manager and would like your insight nad/or assistance. (1.) I have copied the security role "Browser" of which I removed the "Manage Individual Subscription"; however, the link to the subscription function remains on the Report Manager display when activated by a user with that role attached. I would like to disable the view of the link. (2.) The same scenario as in the above ...Show All

• Kreeben sending user variables in

  How do I set user variables from C# when executing a package I am using the using Microsoft.SqlServer.Dts.Runtime; namespace. Thanks,. Marty How about something like this - Package package = new Package (); ..load the package etc... package.Variables["VarName"].Value = "fred" ; ...Show All

• mmcqueen Crosstab query(intersection table)?

  I can use crosstab query(intersection table) in sql server. for example : CREATE TABLE [Test] ( [id] [int] IDENTITY (1, 1) NOT NULL , [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Source] [numeric](18, 0) NULL ) ON [PRIMARY] GO INSERT INTO [test] ([name],[subject],[Source]) values (N'mike,N'math,60) INSERT INTO [test] ([name],[subject],[Source]) v ...Show All

• jmorgan SQL Mobile Get Started Tutorial

  hi. i was following the SQL Mobile Get Started Tutorial and when i got to the section of creating a device application i encountered this step of the process: 16.) Start Notepad and open the file C:\Program Files\Windows Mobile Developer Samples\HOLs\MED302 SQL Mobile\Source\Exercises\VS_SQLMobile\Form1.cs . when i opened it the tutorial said i was supposed to copy the functions for the insert, delete, sync,etc buttons but i didnt s ...Show All

• sirck sirck How to write a Function that can return a value from a dynamic database?

  I need to get a value from a dynamic data base, and I thought that the best way to do this was by using a scalar function. I'm not too experianced in writting Functions... so I thought I'd post here and see if it is possible, and if so, how Basically, I will be using 3 parameter: varchar @DataSource (the datasource string in the form of "server=SRV;uid=USER;pwd=PWD;database=DB;") int @RecordId (the primary key id column ...Show All

• cdemez Change Column Order

  How does one go about changing the column order of the data moving thru an SSIS package   It'd be nice to able to do this at any point in the package for readability, but where I really need it is in the Flat File Output.  I need to deliver the columns in a specific order, and I can't figure out how to do that. This seems to be such a basic question, but I can't find it in Search anywhere.  My apologies if it's already been answer ...Show All