Answer Questions

• Ken Popkin List of data mining techniques not populated - BI Studio hangs

  From within the Business Intelligence Studio, I've created a data source and a data source view. Next, when I try to build a mining structure from a relational database, the studio hangs when it goes to the screen which lists the data mining techniques. Has anybody come across this issue What needs to be done to get further I'm using the June CTP of SQL Server 2005. Thanks, -GB. Thank you for your reply, Ram ...Show All

• Chris Hubbard Passing datetime variable to stored proc as parameter

  Hello, I'm attempting to pass a datetime variable to a stored proc (called via sql task). The variables are set in a previous task where they act as OUTPUT paramters from a stored proc. The variables are set correctly after that task executes. The data type for those parameters is set to DBTIMESTAMP. When I try to exectue a similar task passing those variables as parameters, I get an error: Error: 0xC002F210 at ax_settle, Execute SQL Ta ...Show All

• Brian Donahue backup does not backup

  Hi. SQL Server 2000 EE was able to do this but just found out that SQL Server 2005 EE does not do this. When I select a database to backup, even if i select a different path to backup to - it says it has successfully backed up and verified the backed up database however I am unable to locate it in that path specified.   I have also ran a Windows Search on the file - it does not pick up anything.   When I go back to SQL S ...Show All

• Jose Miguel Retana SQL Error

  I went through that Video Customer Login Portal for Visual Web Developer express. I tried to do what he did with the table, set it so the query in the URL determines what shows up in the page...Though it did not work for me. I tried the test Query at the end of the wizard in Visual Express and it worked just fine, but in the browser it didnt work :( This is what I have for code and it didnt work >< < form id ="form1" ...Show All

• dyt SQL Server 2005 SP 1 Failed during Reporting Services installation

  I have installed SQL Server 2005 SP 1 on my window 2003 machine. All component are sucessfully installed except Reporting Service (it failed) and giving following error : A recently applied update, KB913090, failed to install. find Redist9_Hotfix_KB913090.log file 05/09/2006 11:52:19.016 ================================================================================ 05/09/2006 11:52:19.057 Hotfix package launched 05/09/2006 11:56:27. ...Show All

• iffi raja Cannot connect to SQL Server

  I have an SQL Server 2005 installed on one partition (G:). Visual Studio 2005 with C# is on C: The OS on C:\ is Win2K Pro, OS on G: is WinServ2003. I've created a database on G: in SQL Management Studio. Its name is "endPoint_forMe" The Server (default) as I can see is ALEX-*** data source is "strongUpdate" which is one of the tables in the database "endPoint..." I cannot establish connection. What am I doing wrong I checked in the Contr ...Show All

• Mayur Khare Reporting service with sql server 2005

  I am developing an application using Visual C# 2005 and SQL Server 2005. I would like to make report services from feature of SQL Server 2005. Can I make report from reporting service with SQL Server 2005 How to make the report service Best regards, Simba   Hello, I use Visual Studio 2005 and SQL Reporting Service 2005. My computer is windows 2003 Server. I have created one reporting service project. In my project, ...Show All

• pijcke Example illustrating SMO enumeration needed.

  I planned to write a VB.NET SMO app enumerating all tables in a given database, all fields in each table, the properties (length, NULL, PK, etc) of each field, and finally store the result in a table. I think that should be quite doable. But I noticed that the ForEach Loop editor has a SMO enumerator. (I don't know if it can be used to do exactly what I want.) By clicking on the options in the ForEach Loop editor I can get the Enumerator as f ...Show All

• zkarolyi Index on bit fields in SQL Server Management Studio

  I noticed that I can put a bit field in an index in a SQL Server 2000 database, while using the SQL Server Management Studio (shipped with SQL Server 2005). In SQL Enterprise Manager this wasn't possible. Does SQL Server 2000 support indexes on bit fields and doesn't Enterprise Manager support it, or doesn't SQL Server 2000 support indexes on bit fields and is it a 'bug' of the SQL Server Management Studio Thanks. ...Show All

• Jpoche Unable to get all records

  Hi  Everyone, Hope everyone is doing good. I have problem while running the report, it returns only one record  but it has many records . I am using stored procedure and parameter for running the report. If you have any suggestion I will apperciate you. Thanks in advance. Are you sure there is more than one page   You may have messed up on the grouping if you used the wizard. ya I got ...Show All

• Hughsieman How to delete a group of stored procedures

  For reasons I won't go into I have a need to delete over a 100 stored procedures from a database.  The stored procedures have a common prefix such as dbo.aspnet_createUser. I'm trying to come up with something that will allow me to delete all procedures that contain aspnet in their name. The only thing close I've found is CONTAINS but I get an error I can use it against sysobjects because it isn't indexed. Any ideas of how I can go about do ...Show All

• Recrehal RS2005 Multiple Parameters

  Hi I'm new to RS, I've got SQL2005 installed and I'm trying to use the multiple select report parameter. I'm using a report filter to = database.field IN =Parameter.value(0) etc and even though I'm select more than one in the drop down it's only returning values for one of the options! Helps what else do I need to do Thanks! Fixed, I removed the (0) from the .value filter expressions and it worked. ...Show All

• malangpc Database Diagrams

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS: OK ----------- ...Show All

• Mr. Rare Analysis Services 2005 Drillthrough

  Is there a way to replicate the same behaviour of Analysis Services 2000 drill-through into Analysis Services 2005 This new version allows drill through only to cube data and not to the source data (SQL Server for example). I don’t want to load cubes with detailed data that I don’t need for making calculations, but I want to let this details to be visible to users only with drill-through analysis. Thanks.   &nbs ...Show All

• rjm1963 Transactions, package.transactionOption=support

  I want to use transactions to protect my tasks. I have ten tasks that need to be completed in a single package. If any of the tasks fail - I need the entire process to rollback. I have 5 execute sql tasks to truncate groups of tables in my destination database. After each of the single truncate tasks - I use data flow tasks to copy the data from the source to the destination db. Both dbs are on the same server. I am basically copying ...Show All