Answer Questions

• Martimus BIDS - Error on design surface of Calculation tab in Cube

  Has anyone seen this Within 'Business Intelligence Development Studio' (BIDS) with a cube opened and the calculations tab selected, the design surface displays a message that reads: Unexpected error occurred: 'Error in the application.' This occurs in any project I open and it still occurs when I restart BIDS or the computer itself. Any ideas Can anyone suggest a remedy Hello, Not resolved - Crashes Now. 1.) I have mad the recommended changes, reviewed and confirmed the file changes I made; In all of these locations; C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblie ...Show All

• Right Pilot How disable IDENTITY on column

  Hello, I have big problem with IDENTITY column in table. I must disable this function in 500 tables in my system and i don`t know how do this :( is it such way in order to do this I am not clear on what you want to do. Do you want to disable it temporarily on multiple tables Or eliminate it permanently I can whip up the basis of a routine to change the identity column to no longer be an identity column, but from a further reply that doesn't seem to be what you want. You can only use SET IDENTITY_INSERT ON on only one table at a time, per connection, but this should be acceptable because you can only insert into one table at a time per connection. So if this is a temporary thing, then all you nee ...Show All

• James P. Webster find type of a column

  hi is it possible to find a column's type inside stored procedure I am going to get the name of the table and then work with the columns and I just need the type of the column if I have had the name of it regards Maybe something like this: use tempdb go create table ##typeExample (anotherType integer, targetType double precision) declare @objectName sysname set @objectName = '##typeExample' declare @columnName sysname set @columnName = 'targetType' select c.colid, c.[name] as columnName, t.[name] as type from sysobjects o inner join syscolumns c on o.id = c.id and o.[name] = @objectName and c.[name] = @columnName -- and o.type = 'U' -- Uncomment if you want only user ...Show All

• SweptSquash Instead of Update trigger not behaving like anticipated

  This update trigger will not change the status field in my table to an E. The value that it is adding to the datefield is 20. default value of that datefield is getdate. So I figured if the lastactivity time is < than the expiration time it would keep it as an A otherwise it would set it as an E. Here is the code: ALTER TRIGGER tu_LoggedIn ON dbo.LoggedIn INSTEAD OF UPDATE AS BEGIN UPDATE LoggedIn SET Status = ( SELECT CASE WHEN LastActivity < DATEADD ( minute , ( SELECT CAST (Value AS integer ) AS value FROM SecuritySettings WHERE (ID = 1)), LastActivity) THEN 'A' ELSE 'E' END AS lact FROM LoggedIn AS LoggedIn_1), LastActivity = ( SELECT CASE WHEN LastActivit ...Show All

• programmer01 Is this possible without using cursors?

  Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1  a1          p1  a1 p2  a4    OR    p2  a4 p3  a5          p3  a6 I ...Show All

• Binoy Sankar what is the best way to do this search?

  what is the best way to do this search I want a stored procedure which can serach in any of the filled form on my C# windows application. The textBoxes are: txtFileNo txtIDNumber txtContactNumber txtName txtBuilding txtBlock txtBox txtEmail I want SQL Server to search for any fiiled text, so if the user enterred txtName and txtEmail this it will onlt search for txtName and txtEmail. I know how to do this directly from the form but I want to perform this using stored procedure. If you haven't already you'll have to change your IF statements that build your dynamic for it to work. IF @file_no IS NOT NULL SELECT @sql_string = @sql_string + ' AND file_no = ' + @string_file_no IF @id_number IS ...Show All

• csLearner "Synchronize Connection Strings" Dialog box with XML Config file

  Hello, This has been happening to me since I started using Configuration files.  I use one XML config file that stores Machine Specific settings and one connection string to my Metadata database.  The problem is the database connection. When I set the conection in the Configuation file, save, close and reopen the package, a dialog box opens with the title "Synchronize Connection Strings". To reproduce the problem: 1. Ceate New SSIS Project 2. New Data Source Localhost.Adventureworks 3. In Package.dtsx  create an New Connection from Data Source... 4. Choose AdventureWorks 5. Save Package 6. Close Package 7. Open Package There is no problem at this point. 8. Enable Package Configurations 9. Create a new XML C ...Show All

• DeanoCalver Transfer table with schemas other than dbo

  My problem is very simple and that is that I'm trying to copy some tables between databases, but these tables are in different schemas. let's say I have dbo.tableA sch1.tableA sch2.tableA sch3.tableA And I just want to copy let's say sch1.tableA to a Different DB. If I use Transfer SQL Server Object task and select the table and save the package and try to open the task again, all the tables with name TableA will be selected!! it seems like although it does show the schema ( when I am selecting the table manually ) but it doe snot store the schema detail in the tablelist collection property of the task. Would please recommend any other way to achieve this. Many Thanks in advance Hi Kolf, I concur. I do ...Show All

• LKeene Reporting Services procees Analysis Services cube with 100% CPU for too long time

  Hi all, I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2. I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds. When I build Reporting Services project with same cubes as data sources (on same computer), CPU was increased to 100% for more than 30 minutes (process msmdsrv.exe) ... and I interpurt it. Transfer project to Windows 2003 SP1, but same result. Do you have any idea what happens and how can I fix it Best regards, Siol En Hi, I am trying to join a cube with reporting services 2005 so i created a report template but could not figure how to join the cube and the report template made. I am hopin ...Show All

• paso What's the differnece between these two t-sql statements?

  select distinct count ( Group_Name ) from dbo . MyFile select count ( distinct ( Group_Name )) from dbo . MyFile They return different answers on my sql 2005 machine! TIA, Barkingdog These should only return different values if there are duplicate Group_Name values in MyFile. For the first query, you are asking for the distinct value of the count. Count is merely the number of entries in Group_Name and only returns one value, so the distinct is not needed here. For the second query, you are asking for the count (number) of the distinct values. This is different. The query first returns the distinct values in the table, then takes the count of those. Ex: ...Show All

• Info_Peter TOP count in mdx

  I have this mdx query. I want to add a top count to . Lets say top 100. This is my code: SELECT NON EMPTY { [Measures].[Crash Count] } ON COLUMNS , NON EMPTY { ([Crash].[County].[County]. ALLMEMBERS * [Crash].[City].[City]. ALLMEMBERS * [Roads].[Key Rte Nbr].[Key Rte Nbr]. ALLMEMBERS * [Crash].[At Intersection With].[At Intersection With]. ALLMEMBERS * [Crash].[Street Name].[Street Name]. ALLMEMBERS * [Crash].[TS Crash Mile Station].[TS Crash Mile Station]. ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION , MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Reportability].[Is Reportable].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET (@CrashCity, CONSTRAINED ) ) ON COLUMNS FROM ( SE ...Show All

• alex china Select *

  I know Select * has a performance impact and its better to use Select Column1, column2... But is this also true for Select * from #TempTables. Beside the performance issue, I would always use the column listing, because it makes debugging life easier for you. The code would be more straight forward and muc more readable. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- DaPosh wrote: Thank you all for your comments. Just one more thing. If I dont use indexes in my #TempTables ie. its a simple #temptable, Will i still get a performance improvement if i use Select Column1, Column2 Column 3.. instead of Select *. If you select every column in the ta ...Show All

• DamsDev2007 How to connect to Sql Server

  Dear Sir and Madam: I am now using Visual Foxpro 8 connect to MS Sql server 2000 (Personal Edition). Now, I have a serious problem that I can not connect SQL Server from client machine and it raises the following message : SQL Server does not exist or access denied But it worked when I connect at Server. I don't know the reason why Here is My Server Configuation Computer Firewall is OFF Authentication : SQL Server and Windows Connectstring="DRIVER=SQL Server;SERVER=HUNG1975;DATABASE=sales;UID=sa;PWD=sa;Trusted_Connection=False;DispLogin=3;ConnectTimeout=3" Please help me Thank you very very much. Hi, make sure that you are using the right port and that the ...Show All

• Admann Measure values for Invalid hierarchy memebers

  Scenario ------------- A measure group is related to Time dimension at the Month level, has only the month_id column. The Time dimension also has levels defined below 'Month' like 'Week'. In the cube browser, when the measures of this measure group are viewed with the Time hierarchy below the Month level, values for week are copies of the Month values. How can this incorrect representation be avoided Can zero or n/a values be shown when we drill down to week values. It is like Sales Plan amounts are only defined at month level, the same amount being shown at the week level is incorrect. Regards mat It works. Thanks for the help Steve. Had tried this, but maybe there was a problem in deployment. Regards ...Show All

• Daikoku SQL Server Error 15404

  I am trying to learn replication and using Agent jobs while attached to my corporate domain. Trying to use my personal domain account to run jobs or replication, I keep getting: SQL Server Error 15404, Could not obtain information about Windows NT group\user 'MyName\MyDomain', error code 0x5 [SQLSTATE 42000] (ConnIsLoginSysAdmin) What might be preventing SQL Server from getting my account information from the domain Group ploicy Thanks in advance, Richard 1. Are you using pull merge subscription or push merge subscription 2. One thing you can try is - do runas "your local domain account" so to launch a cmd.exe console, then run replmerg.exe (and parameters) to do a sync, what erro ...Show All