Only Title

Answer Questions

• nedde SSIS Performance Throttling?

  I have a multi-threaded C# application that loads a bunch of tables into ado.net datasets in memory for surrogate key lookups. Depending on what else is going on, it can process 100,000 to 170,000 rows per minute and usually utilizes 20-30% of each cpu. I tried duplicating the process in SSIS using the Lookup Transformation and caching enabled (cache size calculated at 2 * rowcount * bytes/row) with clustered indexes on the lookup columns. With ...Show All

• tomsmi Insert multiple rows with a single INSERT statement

  With SQL Server 2005 Express coming out, I have switched from MySql. I'm having trouble with a very simple INSERT statement that has previously worked in both MySql and Oracle. The statement is as follows: INSERT INTO pantscolor_t (procode,color,pic) VALUES ('74251', 'Black', '511black.jpg'), ('74251', 'Charcoal', '511charcoal.jpg'), ('74251', 'Khaki', '511khaki.jpg'), ('74251', 'Navy', '511navy.jpg'), ('74251', 'OD Green', '511odgreen.jpg'); ...Show All

• wiro MSOLAP 2000 SP4 and Pertlib errors

  Hi all, I just installed MSOLAP 2000 SP4, and now every 4 seconds or so I'm seeing 2 new messages in the Application log. This first one is from MSSQLServerOLAPService: The description for Event ID ( 2003 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event ...Show All

• santaclause585 Mutli development on Analysis service

  Is it possible to integrate two cubes develop by difference developers into one analysis service project Example: Cube A developed by Developer A, Cube B developed by Developer B, once completed, I would like to merge into one project, can i do that in AS2005 Thanks This is pretty easy if your dimensionsions are the same. If your CubeA depends on the same dimensions as your CubeB, you can simp ...Show All

• jglendin How to know the code in Query Analyser

  My Program wants to know what is being edited in Query Analyser currently. How can I do that Thanks. Thank you 4 your suggestion, There is an interesting tool called promptsql, http://www.promptsql.com/ how does it work do you have any idea You will have to do it in your own query tool. You can have a look at Query Commander and its source code, it is a query tool with intellisense. It is written in C#. ...Show All

• Michael Dvoishes Cannot find either column "dbo" or the user-defined function or aggregate "dbo.FN_NIVELCOMPETENCIACARGO", or the name is ambiguo

  Hello i have this query and I havent been able to solve it Cannot find either column "dbo" or the user-defined function or aggregate "dbo.FN_NIVELCOMPETENCIACARGO", or the name is ambiguous. I have tried with dbo and withou dbo, specifyng columns inside it, Thanks select a . nmempresa , a . nmtipocompetencia , d . dsnombreciclo , c . dsnombrecargo , a . dstipocompetencia , a . dscatalogo , b . popeso ...Show All

• Mohsen Kokabi Upgrade to Advanced Services; full-text indexing not working

  I upgraded to Sql Server Express 2005 w/Advanced Services, chose to install full-text indexing, rebooted, but appear to be unable to set up full-text indexing for a column.  After attaching the old mdf file and opening any table in either Management Studio Express or Visual C# Express, I don't get anything but a disabled (Is Full-text Indexed) property for the fields I want to set up.  I have verified that FullText Search service ...Show All

• Jurgen Devlieghere Difference between max length and length in DataType Schema

  Using OleDb I can retrieve the Database Native DataTypes Schema with LoadSchema("DataTypes") In the CreateParameters column some variable fields such as varchar have CreateParametera of 'max length' while nchar has a CreateParameters of 'length'. Can someone differentiate between 'length' and 'max length' for me TVM       BOL: " nchar [ ( n ) ] Fixed-length Unicode cha ...Show All

• HexDump SSRS Subscription jobs in SQL Agent

  We have been using SSRS for many months now and have a substantial no. of reports developed and running in Production. We noticed that subscriptions on the reports were created as jobs with uniqueidentifier names on the SQL Agent. This happens even when the subscriptions are not active anymore i.e. run-once subscriptions which have already run. And when these jobs are deleted manually, they get recreated automatically even for the inactiv ...Show All

• Raven TGC SQL Server 2005 Express Edition April CTP failed to install

  I'm stuck I keep getting a Maintenance - Error occurred during setup.  I think I've tried everything.  Not that this will fix your problem, but could you try installing the latest version of SQL Server 2005 - September CTP edition.  You can download it from here: http://www.microsoft.com/downloads/details.aspx FamilyID=6E4AAC3A-9D85-4734-B1FD-318FB83B0D29&displaylang=en ...Show All

• TiKu Getting exception on executing ExecuteCellSet on AdomdCommand object

  I'm trying to execute an mdx query in C# and getting exception on calling ExecuteCellSet() on AdomdCommand object, This is the code snippet // initialize a new adomdcommand object for the specified connection objCommand = connection.CreateCommand(); // supply the command text for the adomdcommand object objCommand.CommandText = queryString; // attempt to run the command on the cell cellset try { objCellSet = objCommand.ExecuteC ...Show All

• Mike Dempsey Cannot shut down VS after using report designer

  Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP I d ...Show All

• David8756 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

• simon_ Single Parameter/Multiple ORs

  Trying to construct a SELECT statement in my dataset that looks something like this: SELECT column1, column2 FROM table WHERE (column1 = @parameter) AND (column3 > 0 OR column4 > 0 OR column5 >0) Report Designer re-constructs this as: SELECT column1, column2 FROM table WHERE (column1 = @parameter AND column3 > 0) OR (column1 = @parameter AND column4 > 0) OR (column1 = @parameter AND column5 > 0) and as a result, the ...Show All

• VerusMaya How to change a field's type?

  Hi, How could I change the field type through T-SQL I have tried Using the ALTER:          ALTER TABLE tblName ALTER COLUMN myID int It didn't work... And also, how could you rename a fieldname cheers, Paul June A. Domag Hi Paul, I think that Identity may be the issue.  I suppose for an easy answer you could use the same method to change the column type, i.e., create a new column, cop ...Show All