Answer Questions

• ACCOUNTINGONLINE.US Doing a lookup on a reference table from script?

  Hi, I have a common requirement (when I'm processing data rows from an input file) to perform some data manipulation in script then look up a value from a reference table and perform some further data manipulation depending on whether a matching value was found in the lookup table or not. For example, say I'm processing Customer data rows and the first "word" (/token) of the FullName column might be a title or the title could be missing and it might be a forename or initial instead. I want to check the first word of this FullName column to see if it matches any valid title values in a ReferenceTitles lookup table. If I find a match I want to set my Title column to the value from the ReferenceTitles lookup table, otherwise I want ...Show All

• Gess Man SMO fails to create database in SQL 2000 server

  Hello. I am working on the VB.NET windows program which creates database in MS SQL server using SMO. I use user 'sa' (sysadmin) and the program works fine with MS SQL2005. However, when I change the server to MS SQL2000 I get an exception: CREATE DATABASE permission denied in database 'master'. RESTORE DATABASE is terminating abnormally. Changed database context to 'master'.   Btw, I can log into MS SQL2000 with the credentials of 'sa' and execute the same script which is failing to run from within VB.NET. This sql string will restore the database when ran from within SQL window of the server 2000. Anybody has any idea why Much appreciate any relevant responses. Thanks! Eugene     & ...Show All

• MatteusX Open File - Security Warning

  The publisher could not be verified. Are you sure you want to run this software This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel. Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended. Questions: 1.- How to tell the Execute Process Task not to open the Security Warning dialog 2.- Have you any suggestions about my approach Thanks, IanO And what happens when the .Net cons ...Show All

• Mark Hotton Poor performance querying view from sproc

  We are using SQL SERVER 2005. We have been experiencing horrible performance running select queries from sprocs against views that do outer joins, despite having optimized all of the indexes. Our solution in these cases (and arguably not the best) has been to first select the views into a temp table and then query the temp table for the desired result set. This has greatly improved the speed of which our sprocs run, but we are looking for a better solution. Has anybody else experienced this problem Thanks in advance. Hi Eric. Would it be possible for you to post some sample code that includes some of the view definitions, table structures, and sample data scripts It's quite tough to try and ...Show All

• chiraj VS2005 Reportviewer - Documentmap - Collapse/Expand all items

  Is there a way to expand/collapse all items in the documentmap I know there is an option DocumentMapCollapsed but this is to collapse/expand the documentmap panel. I would like to control the collapse state of the items into the document map ... thanks in advane I see there is still no answer - do you found a solution yourself I also need this expanding - but all Internet-searching was until now without a result. HJB ...Show All

• Jon_H How to implement paging

  My report is taking long time to display hundered of records.So we want to display 15 records per page and Next page link at the end of report.Please help me how to do this. Hello, we have tested the code, it's useful. There is another question: If user need Paging & Sorting both, how could you do that Thanks Bob Not sure about the next page link but to control the number of rows per page put your table control inside a list add the following group expression to the list =Ceiling(RowNumber(Nothing)/15) check the page break at end option in the group window. Thanks a lot for your reply. If we don't use the dynamic paging, c ...Show All

• IceAngel89 unable to connect remotely after upgrading a SQL instance from Express to Enterprise

  Problem: I upgraded a SQL Server Express instance to SQL Server Enterprise, but I'm unable to connect to the SQL server from any remote machine. Only local connections work -- and I've verified that Remote Connections are allowed in the SQL Surface Confg. utility. Scenario: Server1 has an SQL Enterprise edition installed as a default installation. SharePoint Server 2007 was installed later, and during that install a SQL Express edition instance was installed which is part of the standard SharePoint install. That Express instance contains all the SharePoint content databases. So Server1 has SQL instances: Server1 <default install running Enterprise> Server1\OFFICESERVER <previously running SQL Express, now upgraded to Enterp ...Show All

• MortyLode Not Allowing Remote Connections

  TITLE: Connect to Database Engine ------------------------------ Cannot connect to FRI-0503\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476 ------------------------------ BUTTONS: OK ----------------------- ...Show All

• qzy using SUBSET on a CROSSJOIN containing calculated Measures doesn't return the correct cell values

  Hi, I am using the SUBSET function in MDX to implement pagination of the data from Analysis Services. However for one MDX statement, I get weird results and I don't know why. I have the following MDX statement: SELECT { SUBSET( [Date].[Fiscal].[All Periods].Children , 0, 10) , [Date].[Fiscal].[All Periods] } ON COLUMNS, { SUBSET(CROSSJOIN ( { [Measures].AllMembers }, { [Promotion].[Promotions].[All Promotions].Children , [Promotion].[Promotions].[All Promotions] } ), 0, 99) } ON ROWS FROM [Sales Summary] When this MDX statement gets executed through my Adomd.Net code, it returns empty cell values for the calculated Measures like Gross Profit. When I try to execute this statement directly in SQL Server Management Studio, I get the ...Show All

• Dan_Dan DAC doen't work with explicit port number

  Hello everybody, After install SQL 2005 I noticed than DAC (Dedicated Admin Connection) is started with dynamic port. 2006-08-08 12:19:47.870 Server Server is listening on [ 'any' <ipv4> 14330]. 2006-08-08 12:19:47.880 Server Server is listening on [ 'any' <ipv4> 1433]. 2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\A ]. 2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$A\sql\query ]. 2006-08-08 12:19:47.900 Server Server is listening on [ 'any' <ipv4> 1212]. 2006-08-08 12:19:47.900 Server Dedicated admin connection support was established for listening remotely on p ...Show All

• hailstorm Synonym

  I have to deal with a naming convention for database objects, e.g. table and column names, which can be very hard to read. I am thinking of using Synonym for the name of each object e.g. table and columns. This can be seen as the logical layer of my physical database. However, there is no such feature as synonyms for columns ( correct me if I am wrong). If you want to create a logical layer, or to resolve the hard-to-read naming issue, how would you go about it Thanks. Yeah...but....Okay and thanks! You can create views to expose the tables and columns as needed instead of synonyms. ...Show All

• Philip Jaques No cubes can be found error

  In the data panel of the report designer component, every time I try to create or modify an MDX statement, I'm now getting a "No cubes can be found. (Microsoft.AnalysisServices.Controls)" error. Works fine on the Layout and Preview tabs. Just all of a sudden appeared. Working fine against relational sources. As a warning to all, Reporting Services and Analysis Services is definitely not a marriage made in heaven. Proceed with caution. I'm going to have to learn to delete my profile everytime something strange happens with SQL 2005. Somehow, my profile on my primary development machine was corrupted again. ...Show All

• Autographics Multiple Publication on the same database

  Hello, I want to create one more publication on a database (SQL Server 2005) that is already a publisher and has subscribers. The subscribers of the second publication will not be inserting new records so I will mark the articles (tables) as download-only. Is there anything extra that I should take into consideration Are there any side effects of this process Thanks in advance. SilentOceaner. You can refer to a similar thread to see if it helps: Merge and Transactional from the same server http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=768828&SiteID=17 Note you are also allowed to have 2 merge or 2 tran publications on the same db/table. Thanks, Zhiqia ...Show All

• James Stetson inner join one varchar(50)

  Hello, I am doing inner join one varchar(50) fields, although I am sure the same data is available on both T1 and T2 but I am not getting anything with this inner join. SELECT * FROM T1 INNER JOIN T2 ON T1.FirstLastName = T2.FirstLastName What might the problem be In SQL 2000, leading space will make the comparison be False. For example, ' name' <> 'name'. Anyway, JIM.H., should post more details on your case. You can try to ltrim(right(FirstLastName)). There may have some empty spaces. It was a leading space. I removed them This is only one time export. Thanks guys. Yikes, that can't be good for perf ...Show All

• Aing_d Could not Create Acceptable cursor

  I have sql server 2005 to which a sql 2000 server is added as a linked server. when I try to update some tables in SQL2000 server from sql2005 server It generates the following error. "Could not generate acceptable cursor." Thanks in advance for the help I ran into the same thing just today. I was running an update query on a linked server. I added a primary key on the destination table and that handled the problem. See KnowledgeBase article: http://support.microsoft.com/kb/302477 ...Show All