Answer Questions

• Mike Driest Management Studio - how to delete multiple objects?

  How do I delete multiple stored procedures (or tables) within Management Studio   In SQL Server 2000 Enterprise Manager, I could just highlight the ones I wanted to delete and hit the delete key.  I can't figure out how to do this simple thing in Management Studio.  Hopefully I'm just missing it... TIA You can select multiple objects in the summary page and then click the delete key to delete ...Show All

• Mailtm Variable Data Type Help

  Hi all, I am trying to extract certain data from MySQL (example sql statement is SELECT COLUMN1, COUNT(COLUMN2) FROM TABLE GROUP BY COLUMN1) and stored COLUMN1 and COUNT(COLUMN2) values into variables and then copy the values from the variables and insert them into a new table in sql server 2005 and has two columns in it (COLUMN1 of type nvarchar and COLUMN2 of type int). I can map the first output (COLUMN1) correctly to variable type ...Show All

• sgudavalli Restricting number of records

  I want to restrict the number of records coming from an OLEDB source. I have 500 records in my source table and I want to process one record at a time I have I set the MaxBufferRows parameter to 1and it l sends 8 records from OLEDB source Any help is appreciated. I tried with restrictig rows in sql using 'select .... from where id='. and using a for loop container. However when I executed it I got buffer over flow error after inser ...Show All

• Eric Burcham Sept CTP: Distinct count agg differs when using WHERE clause and Aggregate(set)

  Our cube has 9 dimensions, and several measure groups.  The measure group involved in this issue, is a distinct count of customers.  One of the dimensions is a time dimension, and it is marked as such since we have a semi-additive measure in another measure group.  More on that later. We've been using 2005 June CTP for our test environment, and recently installed the newer 2005 Sept CTP.  That's when our problems st ...Show All

• Jesse990 VS2005 Syntax Highlighting for SQL code?

  We are currently using Visual Studio 2003 (7.1.3088) and have installed VS 2005  (8.0.50727.24).  In VS2003 when we open any SQL code (usually .sql extension) there is syntax highlighting on all the code.  In VS2005 there is no syntax highlighting that I can find, even if I open a file using "open with".  After searching for a solution I tried editing the registry but it appears that 2005 is different than 2003.  Does ...Show All

• kok_cz What is the best way for users to view cubes?

  Hi, Our company is about to purchase SQL Server 2005 as an upgrade to running the reporting out of MS Access (so I am new to SQL Server). I have been trying out Analysis Services cubes and would like to know how others using SQL Server are allowing users to view cubes. I am using the Cube Browser from within an Analysis Services cube project which is excellent. This made me think that there must be an equivalent program that end users are able t ...Show All

• Keith Kaimsinki Inserting multiple nodes as type xml in SQL

  Hello, I'm working with SQLXML for the first time and need help! I am working with a customer who passes a CSV from an old accounting system, from which I use XSL to transpose it to a more logical xml document, each row of the CSV matches an item node. <data>     <purchase>          ...          <order>      &nb ...Show All

• Sandyko Tools for Converting MySQL to SQL Server

  Hi, I'm in search of a nice tool to convert the database from MySQL to SQL Server 2005, where the schemas of both the DB are different. I just want to move the data from one database to another with column mapping.. Can any pls suggest me a nice tool for this issue Early reply is appreciated... thanking you VarShant SSIS would be a good tool to use for this. -Jamie ...Show All

• Konstantin Gonikman MS Access Table Load with SSIS - Date/Time Field Problem

  I am trying to load a table from MS Access into SQL Server. The Table has several columns defined as Date/Time. When I define the transform I get an error saying that the conversion between DT_DBDATE and DT_DBTIMESTAMP is not supported. How do I get around this You need to explicitly cast your column from one type to another. One way to perform the casting is to use the Derived Column transform. In between your Source and Desti ...Show All

• Fred Yang Error 0xc0202009 for importing access97 into sql

  We have an Access97 database with 122 tables. I try to use import and export wizard to import the data from access into SQL 2005 database. I find an interesting problem. When select all tables, the wizard give following errors: Pre-execute (Error) Messages Error 0xc0202009: {DBD1EAB5-7865-4B89-A7BB-DDC8507D8119}: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" ...Show All

• Ryan Bolger How to enable mirroring feature?

  Hi When I try to mirror a database, I get an error about disability of Mirroring . I m asked to set Trace Flag to 1400 at startup. I dont know what r startup options and cant get help on it too. Will someone let me know how can I enable mirroring in SQL server 2005 Regards If you search on startup options in the Books Online, it will bring up the topic " Trace Flags (Transact-SQL)" . ...Show All

• Scott Z remote connection problem with sql server express

  Hi have sql server express 2005 installed on a laptop running XP sp2 with IIS installed. installed sql express during the visual studio 2005 install having problems with remote connection errors messages when using aspnet_regsql.exe as well as when trying to view pages with sql db involved. in most tests to fix this i disable my firewall, still getting error messages tho sqlBrowser is running as is sqlexpress in services both on auto ...Show All

• Garth Wells LIMIT Clause

  It seems current version of SQL Server doesn't support LIMIT clause in SELECT statement. Will future version of SQL Server support it Thx. You have to use a CTE because you can't use a windowed fucntion in the where clause. I guess this is because the value is not defined until the whole rowset is defined. It would be nice to have it supported in the future to simplify code. Hi Steve, I've just also read it from BOL as ...Show All

• shadowMan20006 Newbie Question

  I want to load a dropdown list based on another dropdown selection.Iam not sure how to do this.  Both are report parameters.Based on one parameter i need to load another parameter. Can someone help me. Thanks in advance mahalaks.   Both dropdown boxes are report parameters. Based on the report parameters dropdown boxes are coming. No properties can be set for this. ...Show All

• Dirk De Baer Can't uninstall books Online CTP Preview

  It shows in Add/Remove Programs.  I had ASP.NET 2.0 installed  and Add/Remove Programs tells me I need 2.0 before I can Install Books Online.  But I'm trying to Uninstall Books Online.  I uninstalled 2.0 with no effect.  I reinstalled 2.0 with no effect.  I searched Program Files and the Register and can't find Book Online.  It won't go away.  How to get rid of it   Thank you. Hi Steve, I' ...Show All