Answer Questions

• babucherayath can'd find SSIS for installation in Server2003SBS-PR

  I bought a new HP server with Windows 2003 SBS Premium. I also was told buy the company how installed the server, that they installed all the components of SQL. When another company came to install a new business software for us, they told me that the Integration services is not installed. We tried together to install the SSIS with no luck. When we run the Setup(or used Add/Remove software) we couldn't find the Integration services check box in the list of the setup. I also asked assistans from the company that i bought the server fromk, and they also couldn't understand where is it. We have an HP Proliant server, Windows server 2003 small business preminum SP1, SQL server 2005. I was told that without the ...Show All

• Jakein2006 the attributes of Fact Table could not be displayed when drill through?

  I have a question about cube drill through. In BIDS (Business Intelligence Development Studio), I set drill through in the tab "Actions" And I add a new drill through action. "Drillthrough columns" is setting the displayed columns when I use drill through. I found that only attributes in the dimension could be displayed. How do the columns in the Fact table could be displayed thank Edward, I know the Measrues could be as part of drillthrough action. I think I would correct my example as following: thank Michael, Yes. Finally, I create a dimension (fact table). Then, the column "Description" could be displayed when drill through. But another problem is der ...Show All

• robinjam Extremely Poor Performance - Identical DB's but very different performance

  Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second. I took a look at the query execution plan and I found that they we're the exact same in both cases. Then I too ...Show All

• DanielMcN New to IS -- please help me!!

  Hi i am new to IS and I have been trying to use conditional split but cannot get the syntax to work. Can someone please tell me where i can find a syntax guide or samples especially on how to make the datetime funnction and maths function work. And, am I correct that the syntax is not as simple as they look in the conditional split transformation editor thanks!!! Expression How-to Topics (SSIS) ( http://msdn2.microsoft.com/en-us/library/23149cdd-b8e0-45a8-8d60-907f0c3ea943.aspx ) Integration Services Expression Reference ( http://msdn2.microsoft.com/en-us/library/8b80403f-6d45-4001-8b12-25a933c663a2.aspx ) If you give an example I'm sure someone can give you the expression. ...Show All

• SoulSolutions Sql server Sp1 error messages questions

  Hello, I have installed Sp1 for Sql Server 2005 I also received "locked files" and "reboot required". These errors I can find on all forums and do not worry me anymore. However i still would like to know more about the messages in the log files. - What does this mean: "Failed to read associated hotfix build information for the following file"...... - What does this men: "Failed to read version information for the following file"......... - Why are some products NOT APPLIED, while in the other log file it says "SUCCES" for the same product These beneath the 2 log files. File C:\WINDOWS\Hotfix\ HotFix.log shows "success" ------------------------------------------- 06/23 ...Show All

• Axe22 SessionTrace during XMLA execution?

  Hi all! I wrote a command line tool that processes a SSAS cube/dimension. At the moment the tool starts processing similar to: using Microsoft.AnalysisServices; olapsrv = new Server(); olapsrv.Connect(@"SERVER/DATABASE"); Database mydb = olapsrv.Databases["NAME"]; Cube mycube = mydb.Cubes.FindByName("CUBENAME"); mycube.Process(ProcessType.ProcessFull); it is possible to trace the server output with: olapsrv.SessionTrace.OnEvent += new TraceEventHandler(DefaultTrace_OnEvent); olapsrv.SessionTrace.Stopped += new TraceStoppedEventHandler(DefaultTrace_Stopped); olapsrv.SessionTrace.Start(); the two functions can write the "feedback" to a ...Show All

• Proceed SSIS System Variable ErrorDescription (@[System::ErrorDescription])

  Hello, Does anybody could help me to fixe this query, inside SQL Task to handle OnError event. The function DT_TEXT does not work with this query and I need to convert the Error Message so that the french caracter ' can be accepted inside the Insert Query. Here is my query : "INSERT INTO LOG(EventType, PackageName, TaskName, EventCode, EventDescription, PackageDuration, ContainerDuration,InsertCount, Host) VALUES ('OnError', ' " + @[System::PackageName] + "', '"+ @[System::SourceName] + "', 0, '"+ (DT_TEXT) @[System::ErrorDescription] + "', 0, 0, 0, 'Toto' )" The error message is capted inside the Insert Query, for example, the value of the variable ErrorDescription is : 'Erreur dans l ' insertion ...Show All

• kevin D. white How to search for a given keyword in Triggers

  Hi I have a "columnname" and i have 120 triggers defined on tables in my database. I wanted to know as is there any way to find out how many triggers out of these are defined on the "columnname" like if i do any updates\edit to this "columnname" then how many triggers out of 120 defined are fired cascadingly. Also, this "columnname" is mentioned in 43 tables in my database. Let me know if you were not able to get my question. Thanks! Declare @txtvalue varchar(100) SET @txtvalue = Text to Search for...' USE Databse_Name SELECT name as ObjectName, ObjectType = CASE type     WHEN 'C' THEN 'CHECK constraint'   WHEN 'D' THEN 'Default or DEFAULT ...Show All

• jakorakosaya SQL Express Download links broken

  Hi, I was trying to download SQL Server Management Studio Express from http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx . The links on this page seem to be broken. I tried to download the Mgmt Studio Express by clicking on a link that points to http://go.microsoft.com/fwlink/ LinkId=65110 . Anyone else facing this issue Is there another place I can get SQL Server Management Studio Express from This seems to have been fixed now - I am able to download the Management Studio. I thank god for the fix! The link seems to be broken again... does anyone know of another way to download SQL Express and/or would someone be willing to email it to me ...Show All

• Jeremy Jarrell An attempt to attach an auto-named database for file......

  I've read through all the posts in this fourm that are related to the problem I'm getting with this error message on my main form, but none of the fixes seen to solve the problem. So I hope someone can get me pointed in the right direction. I'm running visual studio 2005 professional, and SQL Server 2005 Express Edition and this is a desktop application. I added the db file to the solution with the Add New Data Source wizard, I can create the datasets and preview the data correctly. An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I run ...Show All

• Dr.Pepper How do i measure bandwith usage for merge replication SQL 2005 to Sql server mobile 2005?

  Hi, Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device. Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use thnx, pdns. Not for mobile, but if you had a SQL Server subscriber (Dev, Ent, Std, Express) you can add (unsupported) merge agent parameter "-T 101" which will give command-line output statistics for that particular sync, there mig ...Show All

• Doffen Use Partial or No_Cache mode in Lookup task

  Hello, Can anyone explain to me (or show me where to get info) in what scenario should I use Full Cache, Partial, or No_Cache mode in the Lookup task I got below warning message during execute my package. I understand that my lookup data have duplicate reference keys. I want to change the mode to partial or no cache to see how it works, but don't know what to change for the parameter map. Warning : 0x802090E4 at Data Flow Task , Lookup [37] : The Lookup transformation encountered duplicate reference key values when caching reference data . The Lookup transformation found duplicate key values when caching metadata in PreExecute . This error occurs in Full Cache mode only . Either remove the duplicate key va ...Show All

• Whiplash8 How to dynamically create Tables

  I'm currently developing an RDF application which need to handle lots of datatypes. But I want to use SQL-Servers capabilities for efficient querying and sorting. Therefore, I've wanted to create a Main Table which stores a Reference to the Table where the Data is stored. The Data itself should get stored in a Datatype-specific Table. The Typed Table might get created by something like: public void CreateTypedLiterals(Type type) { String sql = String.Format( "CREATE TABLE [Literals_{1}] (" + "ID int DISTINCT NOT NULL, Value {1})", // BUG: does not work // WARNING: introduces a potential sql-injection problem type.ToString() ); ... As you can see on the statements this solution makes many troubles. So I've wanted ...Show All

• Will Merydith Can multiple apps connect to the same database?

  I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message; "Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use." I would like to be able to copy the file to my office computer where it would be ...Show All

• doener A thought this would be simple...

  I had originally thought a full outer join would solve this, but alas I'm a roadblock. Perhaps it's because it's a Friday! The goal is to create the most efficient query that will display results of the daily calls and sales as this: Date EmpID Calls Sales 7/1/2006 1 20 5 7/1/2006 2 25 7 7/1/2006 3 NULL 1 7/1/2006 4 10 NULL The problem is a simple full outer join ends up ignoring EmpID 3 who has no Calls in t1, but I still want that row displayed in the results. Any ideas TIA create table t1 (Date smalldatetime, EmpID int, Calls int) create table t2 (Date smalldatetime, EmpID int, Sales int) insert into t1 values ('7/1/2006', 1, 20) insert into t1 values ('7/1/2006', 2, 25) insert into t1 values ('7/1/ ...Show All