Answer Questions

• sscc Cannot alter or drop fields

  I must change replication schema from: Publisher - SQL2000(8.0.2039), Disrtibuter/Subscriber - SQL2000 to: Publisher - SQL2000(8.0.2039)(The same server), Disrtibuter/Subscriber - SQL2005(9.0.2047)(new server) I have removed all subscription, publications, distributer and publisher. So there should not be now any information about replication. Now I want to make some changes with tables and i try to alter and drop columns on publisher da ...Show All

• chossy Visual Studio 2000 and the Report View Control

  This may have been asked in the past but I have been asked to find a way to integrate Reporting Services 2005 to our current VS2000 web app. Someone thought one way to do this might be through the report viewer control but I cannot find a Report Viewer control reference for 2000 only 2005. Is there a way to use the report viewer control in VS 2000 If not, does anyone have a suggestion as how to integrate a web app in VS 2000 with RS 2005 thro ...Show All

• Thams parameter help

  Is there anyway I can pass column name and column value both as parameters to serach the rows Here is the example what I want: declare @colname varchar(15) declare @colval varchar(15) set @colname = 'LastName' set @colval = 'Smith' select * from client where @colname = @colval The idea is I want to develop one qurey for all possible criteria. How can I acomplish this Thanks. This is u ...Show All

• JSMARTIN "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• dic_brookes sql server 2005 RS multi-value params june ctp

  I have a very simple report with two non-queried values in my param list and the multi-select params box checked.  The dataset only has two records, represeneted by the two params.  The report always returns both records in VS and report manager whether I select one param, both, or the "select all" option.  Anyone esle have this experience Microsoft SQL Server Report Designer   Microsoft SQL Server Report Designer Versi ...Show All

• Dan.Dittenhafer Converting T-SQL *= OUTER JOINS to ANSI-92 syntax

  Hello all.  I have an application that has worked smoothly using the following query syntax: FROM tbl_participation, tbl_adult, tbl_month, tbl_school_year WHERE tbl_participation.adult_ID =* tbl_adult.ID AND tbl_participation.month_ID =* tbl_month.ID AND tbl_participation.year_id =* tbl_school_year.ID AND tbl_adult.ID = 8 AND tbl_school_year.ID = 5 It works just fine, as I want the results to include a ta ...Show All

• Aijaz Ms SQL 2005 express edition connectivity problem

  Hi, i just currently install the MS SQL 2005 express edition in my Window XP home edition and the problem is, when i netstat in the command prompt, i couldnt find any port listening to port:1433 i have an application wanting to connect to the MS SQL but it came out: Error connecting to database using: "jdbc:jtds:sqlserver://localhost:1433" i dunnu what the problem is but im suspecting it is not listening to port:1433 anyone can help m ...Show All

• pauldo And here is part of the installation log...

  I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server ...Show All

• pychobj Object variable assigned to parent package

  Hi, I have a child package which executes a sql query and retrieves back a result set assigned to a object variable. Then i need to assign this object variable to a variable in the parent package, where it will be used as an ADODB Enumerator in a ForEach Loop Now, if this variable was, for example, a string, it'd be quite easy to put in a script task dts.variables("x").value = dts.variables("y").value where x is the variable in the parent packag ...Show All

• HLD-Sean SQL 2005 SP1 installation hangs

  I am trying to install SQL 2005 SP1 on a Windows 2000 Server SP4 platform. I have repeatedly tried this, and have trashed and re-built the platform all to no avail. I keep getting the same problem. The installation hangs, using 0 CPU apparently after successfully extracting the files to disk. It leaves the HOTFIX.EXE running, and cancelling it ends the process. The HOTFIX.LOG looks like this: 5/31/2006 10:05:03.185 ======================== ...Show All

• SteveTri UNION with the second set ordered

  Hi, I was trying to use the UNION construct to combine two tables. The second table was to be sorted before effecting the UNION. The first attempt was the following: SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT open_emp_id , open_branch_id FROM account ORDER BY open_emp_id The above was generating an error. I then tried SELECT emp_id , assigned_branch_id FROM e ...Show All

• JoeVB Limit Report Server Access

  All, I'm looking at the possibility of allowing only certian tasks and reports to be available to users.  I want the user to only have so much control...but would like them to be able to run reports, subscribe to reports and be able to use the query builder.  We don't want the user to see all of the reports in the organization, just the reports for there specific department.  So I don't know that I want them to see the report ...Show All

• Urubu715 sys.objects vs. sysobjects in master..sp_ stored procs

  use master go create procedure sp_GetObjects as select * from sysobjects ; calling this procedure from different databases will return different results (behavior similar to 2000). use master go create procedure sp_GetObjects as select * from sys.objects ; calling this procedure from different databases will return results for master db only...  (ditto for all other sys. catalog views) how can I create database agnostic stored procedures u ...Show All

• DotNETKans ADO.NET Source Custom Properties - Documentation Wrong?

  Ok, so I've looked near and far and have found nothing but info that says data flow properties can not be changed at runtime....then I see in this in the SSIS documentation under ADO.NET Source Custom Properties: SQLCommand String The SQL statement that the ADO.NET source uses to extract data. The value of this property can be specified by using a property expression. Pray tell me how this property can be specified using a property ...Show All

• rupaj DCOM error

  I just installed sql server 2005 on a windows 2003 server.  I chose the option to install but do not configure.  After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok.  When I browse to //localhost/reports I get a rs page with the message of: The request failed with HTTP status 400: Bad Request. One slightly unusual thing is SQL Server 2005 was installed as a named instance ("( ...Show All