Answer Questions

• sea2006 Tools to generating database creation scripts.

  Hello, there are a tools, or a "ways" to generating "database creation scripts" from a MDF files Thank you for help. Bye Toni YOu will have to attach the Database to an instance first. Then you are able to use the SMO classes or any GUI (like SSMS) that can create scripts of objects. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Jens K. Suessmeyer Thank you for help, I don't know SMO classes, I will study it. Mike Wachal - MSFT : Thank you for help, but I don't have " Management Studio Express ", so I suppose I must install "SQL Server Management" first ( http://msdn.microsoft.com/vstudio/express/sql/download/ ). I can will do it tomo ...Show All

• Tom C. Hide Database Design

  Hi I wanted to see if Microsoft was going to address this problem We as developers want to hide our database design (SQL Express DB) We dont want to rely on the user rights settings to secure the design Most of our clients have admin access which means that they can see the db design We are happy for the design to be available on the server as change control should be given only on the server I am perplexed how this hasnt been addressed Your reply is appreciated T Hi Mike Thanks for that great answer As long as we can setup replication as in SQL Express and manipulate the database with a similar Management tool then it is a good solution and answer How long do you ...Show All

• James_Moore Unable to view the updated Data URGENT

  I am executing this code from asmx.vb page in ASP.NET It is not giving any error It is taking some time to process this request. But I am not able to see these changes in the cube's data Please help! I am using Following code to update the cube. Dim str As String Dim cnn_oledb As New OleDb.OleDbConnection(strOLAPConn) Dim s As New OleDb.OleDbCommand(str, cnn_oledb) str = "UPDATE CUBE [DEMO] SET ([MEASURES].[BY],[center].[Ames Research Center],[Budget Year].[2007]).VALUE=5" cnn_oledb.Open() s.ExecuteNonQuery() Thanks in Advance cnn_oledb.Close() I have a couple of suggestions. 1) try setting the "str" variable before creating the "s" oledb c ...Show All

• JeanF J Computed columns and constant

  Hi, I have a small problem with my database. I've got following situation: I have a computed column, which value is base on currency rate: rent * rate. Users have to have possibility to change currency rate easily (maybe another table or constant). Is there any way to create formula, which would compute value properly, via constant or something like this Or the easiest workaround would be load data into dataset (I'm building asp.net application - database will be very small - couple of hundreds of records) and make calculations programmatically Przemek hi, computed columns can only be based on constants, variables, functions and columns of the same table, and the last one exclude your Users ha ...Show All

• simon burgess Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• Frank Cazabon Non value-type parameters in Assemblies/ CLR UDFs:

  I am building a simple utitility to be hosted as a database assembly in SASS 2005. This is a .Net Assembly] My method is date dependent and I want to pass in a DateTime rather than a string (globalisation issues.. you know the story).  Can I do this and how would I pass this parameter in an MDX query I also want to pass in such thigs as the StorageMode enum etc. Presumably I can pass in the integer value... (kinda defeats the reason for using enums though) Update to this, I find that you can pass the DateTime as a string and SSAS does some sort of implicit cast. this is still very sensitive to date string formatting, so is not ideal! Well, it seems ...Show All

• laja MDX Calculated Member Problem

  Hi, I am trying to create a calculated measure, but since I am new to MDX, I have no idea how to go about it. I have two measure groups. One contains the number of customers recruited and is associated with one dimension (Start Week number). The other measure group contains the amount of of sales (￡) and has two dimensions (Start Week number + Actual week number). What I want to do is create a calculated measure of sales amount per customer recruited. The number of recruited customers will obviously be constant for any given start week, and the sales amount will be different for each actual week. Could anybody advise on a way to do this. Many thanks, Dave Here is a simple example of a c ...Show All

• shadyi Sql server 2000 Reporting service error

  Hi at all, I am working on a w2k3 server using sql server sp4 and reporting services sp2. The problem that I have from 2 days is : An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'BrandDestination'. (rsErrorExecutingCommand) Get Online Help Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. well, the sql server and reporting services are installed on the same machine, the report has 6000 seconds to execute the query. I have indexed the db and defragmeted it. I have also tryied to use another database with only few rows to check if the problem is a problem of number rows ...Show All

• ChrisSmith deploy sql server express to ISP

  To deploy sql server express to an ISP that supports Sql Server, I backed up the .mdf and .ldf files. I can connect to the ISP database with Sql Server Mangement Studio Express. That connection requires a password. When I try to execute 'restore', I get an error for no permission. Any ideas why I have no permission after a password has already been entered I sure appreciate any help. Glad that it worked out for you CK. I'm also glad the discountasp.net has a tool to upload your database easily. I'll make one minor nit just so it's mentioned in the thread. I think it's important for folks to understand that SQL Express is SQL Server 2005. There is not difference between the database files, all the same data types are ...Show All

• Mike P B Excel task has no output columns

  I created an Excel Source and used a query to get the data,i.e SELECT F1,F2,F3,F4,F5,F6,F7 FROM [Fut Days$A20:G1480] The query works fine, the preview returns the rows, but SSIS will not generate output Columns nor will it let me manually add them Am I missing something Hi, The problem is there's no output columns listed, and you cannot manually add them. The problem is when I specify a query instead of an entire worksheet, the External Column meta-data is not added like it is when you select a worksheet by name. Dave Hi, Have you tried naming the columns in your excel source as some meaningful names and then try to connect your excel source. It ...Show All

• magcianaux Not able to initialize scripting engine

    I have a DTS package that is running under SQL 2005 (64-bit Itanium).  It has a data driven query in it and I receive the following error: ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engine I don't want to have to re-register any DLLs if I don't have to.  Shouldn't this work out of the box Any ideas I think the SSIS forum can better field this question. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ I did post there and have had no response. That's why I'm trying here. It's strange, I have one Itanium server were it works fine and the other I get the me ...Show All

• Rainadaman Very Urgent, Done a mistake. please help

  I am using Sql Server 2005, i have two tables master and details. accidently i excuted an update query to change column name called transaction refererence(t_ref). in master and details table t_ref is the reference column. instead of update one record in detail. my updated query change change all the reference into one. i feel like escape from my company. i scared pls help. any way to roll back. following is the query i have excuted, which going to cause damage in my life, pls help --update t_details set t_ref='TR2007/02/27-4:16:52 PM' --where serialnumber='771110012657' and t_ref='TR2007/03/02-4:16:52 PM' since u have not backedup TL, you will not find transaction log backup anywhere . Z:\Program Files\Microsoft SQL Serve ...Show All

• Aloepages Accessing varibles inside the ScriptTask

  Hi All, In one of my ScriptTasks, I instantiate FileSystemWatcher class and set events for it. This has been done inside the Main() method. I can access all the varibles declared in the SSIS package inside the Main() method ( by using Dts.Variables("").Value ) but none can be accessed inside the event methods. One possible reason for this can be, events might be running in different threads. Now my question is, How the varibles can be accessed inside the event methods. Hope someone can give me a solution. Appricate all your solutions. Thanks Hmmm... Dim watcher As New FileSystemWatcher() Shouldn't it be: Dim WithEvents watcher as New FileSystemWatcher() Have you tried changing th ...Show All

• Sijumon MSDE - Start Databases

  Hello I'm using SQL Server 2000 - 8.00.760 Desktop Engine. When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time. What I can do to start my own database when the SQL Server starts Thank you. The Service is autostart, but my own databases just start when I connect to them to the first time. Is there anything to do to auto start databases Thanks. I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too. After start SQLServer, the SELECT results the same values for my three dat ...Show All

• WillTurner Line chart

  Hi, My chart look like this: http://img242.imageshack.us/img242/7056/fig1kd9.png    I have a dataset like this Count     Species   CallType         Date 2               1                0                  1/1/2000 2               2                0        ...Show All