Answer Questions

• eguo Unable to Install SQL Server 2005 after BETA

  I have completed the uninstallation instructions for my beta versions of SQLExpress (repeatedly). I have used the manual unistall procedures also. I have physically removed the SqlServer directory from the the Program Files directory. The result is the same. This message appears every time I try to to install the MS SQL Advanced package: "SQL Server 2005 setup has detected incompatible components from beta versions of Visual Studio, Net ...Show All

• coreyw2000 Login failed for user '(null)'. Reason: Not associated with a trusted SQL server....

  Hi guys, I have a problem: I have a created a vb.net app. From this vb.net App (in server A) I connect to the SQL server SP4 (in serverA) and to a SQLServer 2000 SP4 in another server (server B). All connection are with trusted_connection = true. Server A and B are in a domain. After pressed a button, (when I run the button I am logged as a domain administrator) some store procedures and table are created in SQL server A and B. ...Show All

• Greg Smolyn cmdexec subsystem failure

  have a scheduled job that has been running fine for 2 years, but this week I keep getting the following error: 0x469A75B7998F8142A910FA7E9983CCDF has caused an exception in the CmdExec subsystem and has been terminated. the enterprise manager shows that the job failed, but the app still shows up in task manager. the .cmd file has a single step in it that calls the .exe file and does an "if errorlevel = 1" option that displays an erro ...Show All

• Mayank Goyal help!! Filter !! Somone has to know!

  Am I just not explaining myself or does nobody use SSRS 2005 or if so not create very complex filtering requirements out there yet   Can I get some responses hopefully   I can't find anything out on the net about how to do what I'm trying to do here:   HERE IS A PRINT SCREEN OF THE FILTER TAB WHERE i WANT THIS ALL TO HAPPEN...PROPERTIES OF MY TABLE: http://www.photopizzaz.biz/filtertab_ssrs2005table.jpg essentia ...Show All

• kiwilamb SQL SERVER 2000 delete problem

  Hi All! Im new here and Im not pretty sure if this thread really belongs here. I just want to ask why I kept on having errors in deleting a record in Enterprise Manager. Everytime I delete a record / row in a table it prompts me of Invalid Object Name. I guess its because of my table name "my.table" because it has a "." (dot). Does MS SQL not enclosed my table name by brackets "[]" to ensure success of action Anywa ...Show All

• Dr. Zoop How to take a SP like a table

  Hi Any one knows how to take a SP(stored procedure) like a table, obviously the SP throws a search or other way that can help me is if when I execute a varchar, but i want to manipulate like a table, the varchar has a simple search like select * from user Thanks for your help You can use OPENQUERY for that: http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thre ...Show All

• cfg83 Sendin Parameters from a 2005 Cube to Reporting services report

  Hi everyone, I need your help .. Can you help me with an example of the currect way I should fill in the Report Action in the Form Editor. (The syntax.....) 1. The Report Server 2. The Server name 3. The Server path. Thanks. Inbal Hi Inbal, Take a look at the "Sales Reason Comparisons" Report Action in the Adventure Works cube - which has these values: 1. Th ...Show All

• jason duncan Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered fro ...Show All

• teeka Programatic Fuzzy Lookup

  I want to use Fuzzy lookup to search a table for similar matches. I would like to do this from code in Visual C#. How do I do this or can I If I cannot, will this be something available in the future But can I pass in info such as a parameter into the package and have it run it based on that parameter For example, I want to look up any and all customers that match to 'Blue something' ('Blue Cross / Blue Shield', 'Blue Cros / Blue Shield ...Show All

• MrFaith Which method should I choose?!

  Greetings SSIS friends I want to implement the following query using SSIS Data flow Source component : SELECT * FROM someTable WHERE someColumn = 'H' How do I restrict the data coming from my data source By that I mean how do I apply the WHERE clause in SSIS ! Should I use a conditional Split component ! but that would mean retrieving all records first then adding the split component (not the most efficient method surely). Any su ...Show All

• Rory Wilson MS SQL Server Language Support HELP

  Hello, I was wondering if someone could help me with a question I have about MS SQL Server.  I have looked all over for an answer and have been unable to find anything.  I am trying to decide which database to use for a project.  I will be using the english language to put the information in the database, but when I give the finished product to my client, he will be putting things in greek.  So, my question is, Does MS SQL ...Show All

• shawjh Teradata, SSIS OLE DB Source error (0x80040E21)

  I am trying to use SSIS to pull data from teradata to SQL2005. 1. When setup ole db source, firstly i setup the connection manager. I tested the connection to teradata, it prompted Okay without problem. 2. then, there are 4 types of data access mode for selection.     If I select view directly, it works fine for copy specific view directly. But if I select SQL command(or from variable), it will prompt an error msg as below Error at ...Show All

• CosmicFred Sum with null values

  Hi everybody. I have a query that, in a certain filed, returns a numeric value for some rows and null for others. For that field, in Reporting Services I have to report the null values as 0, and add a total (a sum) of the values of the entire Query (again, for that field). On the report designer, when I drag and drop the field to a TextBox there's no problem. But when I write the formula =Sum(Fields!FieldName.Value, "DatsSet1") to another textbo ...Show All

• Kaloyan Georgiev Filter parameter based on prior parameter

  Hi guys, i have some report parameters that are dropdowns, and i would like to use whatever is selected in them to filter subsequent dropdowns. I know that the report designer automatically makes parameters dependant on each other, but that has been stripped out of the rdl, i need to replace it with more targeted filtering. So assuming that parameter A and parameter B get their values from a dataset, how can i filter parameter B's conte ...Show All

• Jo A. Kim Killer problem with Scheduled Reports

  I'm running on SQL 2000 with SRS. Standard install ( I think, it was all set up by IT) I have reports that run fine in the Report Manager but when they are run through a schedule (email) some of them (albeit most) "rsProcessingAborted" because of a report error. Looking at the logs it seems generally based around comparison failure because of datatypes, eg (from the logs): Microsoft.ReportingServices.ReportProcessing.Rep ...Show All