Answer Questions

• Ha Duo FireBird to SQL

  Hello every1. I am currently using a system thats written in Borland C++ and running off Firebird Server 1.5.1, which for some reason crashes constantly (internal gds software consistency check). I have MS SQL Server 2005 installed on another machine, and was wondering if it is possible for me 2 run my C++ apps on MS SQL Server 2005 If anyone can help me with either of those questions, it wud be highly appreciated. Summary: Question 1. : How do i solve the "internal gds software consistency check" in the FireBird server Question 2. : How do I run my C++ Apps (designed for Firebird) to run on MS SQL Server 2005 This might be helpful - it's a complete tutorial on C++ and SQL Server: http://ms ...Show All

• csname Join problem

  Hi CREATE TABLE [dbo].[Users]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Users] VALUES('Unal') INSERT INTO [dbo].[Users] VALUES('Volkan') INSERT INTO [dbo].[Users] VALUES('Duygu') INSERT INTO [dbo].[Users] VALUES('Elif') INSERT INTO [dbo].[Users] VALUES('Mehmet') INSERT INTO [dbo].[Users] VALUES('Demir') CREATE TABLE [dbo].[Agenda]( [Id] [int] IDENTITY(1,1) NOT NULL, [ActivityName] [nvarchar](50) NULL, [UserId] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Agenda] VALUES('school excursion','1,3,4') INSERT INTO [dbo].[Agenda] VALUES('party','6,2,3,1') Table Name : Users Id UserName 1 Unal 2 Volkan 3 Duygu 4 ...Show All

• Eric van Feggelen Making query in SQL server 2005 - What is the best way?

  Hi i am making a web application using SQL Server 2005. i am trying to make all my query using stored procedure in database and just passing the parameter to the database. I am having some complex task that I can't do in one query. So what is the best way to make the best performance Using complex stored procedure or using more code instead Thanks a lot for your help It sounds like perhaps a temporary table or table variable would be useful. Are you needing to store the results of your 1st query and then process them in a 2nd query (i.e., get a resultset and, for each row, do a calculation/etc) If so then the temp table solution is available. You can do it all in a single stored procedure. /**************************** ...Show All

• KTI measure using calculated member

  I have fact and 2 dimensions. i have to create a mesure using calculated member. fact is having fkey ckey monthid hits responses CDIM is having Ckey ADateID MonthDim is having Monthid MonthName now i want a measure(XYZ) to be calculated using calculated member as Count of Ckey for AdateID = '20000101' for current member of monthdim. finally when i browse thru a cube it should display some thing like below. Monthid XYZ 200601 1000 200602 2000 Thanks in adv Steve, they are correctly related. and i want to tell you that most of my dimensions are not directly related to fact table. they are reference thru a fact(this table is a dim for main fact) tab ...Show All

• wukun If body contains two tables, report preview breaks are getting upset

  When there are two tables in the body, if page break is added for first table, second table always go to a new page in report preview. But print layout preview is working fine. Keep your two tables side by side. ...Show All

• VishalR Can't install SQL Server Express

  Hi all, I've been trying all day to install SQL Server Express edition on my development machine, I 've uninstalled other Express Editions that I have previously installed, at least none show in add/remove programs. When i try to run the setup program i get the message that i have incompatible programs still installed. I don't know what they would be. None are listed in the program list as I have said. I tried to run the uninstallbeta program on the SQL Server Express page, but I keep getting an error that the "framedyn.dll" cannot be found, reinstalling the application may help! lol ! Any idea's Thanks in advance. Hi, Removing and reinstalling some programs appears to l ...Show All

• TRACEYMS Dimensions from Fact tables

  Most of the Fact tables I'm building seem to have a bunch of categorization type columns in addition to the numeric columns that naturally fit into the Fact tables. However it feels "wrong" to create dimensions from a Fact table, so instead I'm getting the ETL to split the tables: for every FactX table I get a DimXInfo table that has the non-numeric/non-key data. E.g. FactDeal includes dealID, price, quantity, product key, customer key (and other keys that relate to shared dimensions. DimDealInfo table includes dealID, ContractNumber, DealType Then in the SSAS cube DimDealInfo naturally forms a Dimension and FactDeal naturally forms a measure group. And you don't have to create a SSAS Dimension from the Fact table. Quest ...Show All

• doank Import dedicated Records from a Flatfile to a DB

  Hello all I got a Problem when I try to store Data from a Flatfile to a DB. The following Error appears in the Progress Control: An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_Products_1'. Cannot insert duplicate key in object 'dbo.Products'.". I have a Flat File Source, and would like to store the needed records in a DB. In Column 0 in the Flatfile I have multiple Entries with equal Values. In the DB this Column is set as Primary Key and can only have one Record with the same Value in this Column. How can I read out (or store) only one Record with the same Value from the Flatfile to store it in t ...Show All

• Nicolas D Limitations in Report Builder?

  I'm using Report Builder. I have a NameAddress entity that I want to have printed on the report. There is only one "Drag and drop column fields" box on the "design report" screen. Every field I drop in there goes from left to right. Is there a way to reposition the headers/fields, so that I can have something in the following format: First Name: xxxxxx Last Name: Address 1 xxxxx Address 2 xxxx City: xxxxx State: xx Zip: xxxxx Everything I drop in there goes from left to right. I want to position things "anywhere" on the screen, and be able to split the column headers apart from the data. Basically, how do I get this tool to work like access report designer. Just a simple acc ...Show All

• Benelf Calling a DTS (SSIS 2005) from a Vbscript

  Hello, I would like to run a DTS using a Vbscript, i managed to get the DTS running, but i would like to pass the value of a global variable, but im having lots of dificulties. Since it is a VBS i only have access to the things registered on the registry of the machine, so i don't have access to the microsoft.sqlserver.dts.runtime, at is maximum. So i do the following Set objApplication = CreateObject( "MSDTS.Application" ) Set objDTSPackage = objApplication.LoadPackage( "T.dtsx" , True , Nothing ) 'This should pass the variable but insted i have an error set pkgVars = objDTSPackage.Variables set myVar = objDTSPackage.Variables.Add( "User::Name" , false , " ...Show All

• David Ghikas Removing Mobile Edition BOL

  I'm hoping that someone has any ideas on this. I want to completely strip the entire Books Online module for SQL Server Mobile Edition. Why It gets really irritating when I try to look up topics and it always yanks up stuff from the Mobile edition and I could care less about those. There are entire sets of topics that BOL will do nothing but pull up the Mobile edition topic which is completely irrelevant for other editions. Hi Michael, The scripting error you're getting occurs in some scenarios when SQL Server 2005 BOL and the MSDN Library are installed side-by-side. I was told that this error was fixed in the April refresh of SQL Server 2005 Books Online. Updating your version of Books Online to the April or July refresh from h ...Show All

• lympanda can't modify stored proc which is in a publication

  Hi SQL 2005 sp1 - merge replication - HTTPS. We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic and another with SyncType = SubscriptionSyncType.None. The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data. When we try to modify a proc which is in the publication with SyncType = Automatic, the query never returns. This is most urgent - thanks for your help. Bruce We will try this tomorrow - but it's worth pointing out the following a) the publication with SyncType = none -- has a few hundred stored procs - I can change any of these no worries b) the pub ...Show All

• Bigmo Scripting the Pacakges in SQL

  hi ! I was wondering if there is a method that we can use to script the packages and move them for installing in the client place. Something which we can do like SQL generate script for the DataBase. Thanks, Jaz i'm not sure if this will help, but have you considered using the dtutil utility You cannot script packages - they are simply XML files and can be moved using the deployment utility, manually, or using dtutil. The deployment utility - see BOL for information on deploying packages - is the nearest to what you are asking for, I believe. Donald ...Show All

• Mykhaylo Blishch Subscription Files(*.msf)

  I look for a subscription files in format *.msf to synchronize my net.Where can I find this Colud be a example file.Urgent!!! Moved to the replication forum ...Show All

• _Buzz DataFlow suggestion

  I am transfering data from a textfile to sql server.I use a data flow task for trasfering my text files. Here is what i do. 1.Add text file source What i want to achieve here is if the text file countains the column name in the first row i should delete them and if it does not contain column name in the first row just transfer it. how can this be achieved 2.add one more column to my text file which should contain the status(insert or update). how can this be done 3.before transfering data ot destination i want to know if the record exists if exists i just want to update it instead of insert.and if new record i want to insert it .and the status in the above new column need to change. please help... ...Show All