EdmundMS's Q&A profile

• SQL Server Getting sample databases in Management Studio

  How to get sample database AdventureWorks and AdventureWorksDW deployed in Management Studio. I selected to install sample database entire feature on my local hard drive and I can see it did installed all the .mdf,.ldf,.dim,.cube and the rest in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ How can I get the database in Management studio. I tried to use Attach db and it didn't worked, gave me following error Msg 1813, Level 16, State 2, Line 1 Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. Msg 602, Level 21, State 50, Line 1 Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. ...Show All

• SQL Server Iteration within Stored Procedure

  A Stored Procedure inserts a record in a base table. I want to add n records (n=1 to 5) into a related table. Another SP (tdAuthorityInsert) is already set up to insert one record into the related table. So, two questions 1. What is the form of an iterative loop in a Stored Procedure 2. How do you call a Stored Procedure from inside another Thanks, td Is this what you trying to do declare @ NumReviewers int -- Initialize the @ NumReviewers select @ NumReviewers = 1 WHILE @NumReviewers <= 5 BEGIN -- execute your SP and pass in the @ NumReviewers exec your_sp_name @ N ...Show All

• Visual Studio Dynamically generate and "install" DSL

  Hallo, I'm currently working on a DSL for a Component-Based Software Architectures. I've created a DSL for the basic entities and their properties. Now I can design "childs" of the DSL (e.g. an EmailEntity) and add different properties in the created designer. What I want to do next is to dynamically create a new DSL from the model I've drawn in my designer within the debug instance (where I have drawn my model). When I now click "New Item" I want to have a template for my new dynamically created and installed/registered DSL, so that I now have EmailEntities etc. in my Toolbox and can draw instances of e.g. ...Show All

• SQL Server Bulk Insert Speed Problems

  Dear Experts, Our Server Information is: HP Proliant ML570 with 4 CPU (2.00GHz 512KB L2, 2 MB L3) It has 4GB RAM. We have 2 HP Smart Array 6400 Controllers with 192MB RAM. The Disks of the system are all HP ULTRA320 SCSI. We have 8 x 146.8 GB 15K, 2 x 72.8 GB 10K and 2 x 36.4 GB 15K We configured the Disks as follows: First Controller RAID 1 = 2 x 36.4 GB 15K - Operating System(Microsoft Windows Server 2003 Standard Edition Service Pack 1) and SQL Server(Microsoft SQL Server 2005 Enterprise Edition - 9.00.1399.06 ) RAID 1 = 2 x 146.8 GB 15K - Not Used RAID 1 = 2 x 72.8 GB 10K - Not Used Second Controller RAID 0 = 1 x 146. ...Show All

• Visual C# Setting Panel's 'Locked' property in code?

  Hey Howzit I was astonished to see that a person can't override or set a Panel's "locked" property, how can I get around this Regards, Hi The Locked property doesnot belong to any Component... will you beleav that it is a property of the desginer .... so in design time it is acceble through desinger ... while at runtime there is no designer. Its work just like we drop a component on the designer and some of the properties appeared in other controls property lists ... Hope that you understand this ...Show All

• SQL Server Can we secure specific snapshots?

  Dear Anyone, Is there a way to place some sort of security on a snapshot level Each snapshot of a report has specific security preferences such as specific users for each snapshot Thanks, Joseph Hi Joseph. No -- You can't do this. You'd have to secure the report instead.  This is an interesting scenario, however... Why would it be OK for 'user1' to see a snapshot of data for one time period, but not for another ...Show All

• Visual C++ native members of managed classes?

  Hi jedediah! What's the preferred way to effectively have a native class as a member of a managed class What do you mean class NativeClass { }; public ref class ManagedClass {   protected private:     NativeClass *_pNativeMember; };   jedediah wrote: It's the C#/VB monkies I'm worried about. C++/CLI seems to do the best job of making disposing transparent but it seems to be a house of cards with the other languages. I definitely Agree with that... When Visual C++ entered the .net framework in VS2003 I knew ...Show All

• .NET Development Strong Type Assembly

  I just installed VS2005, the final release addition, opened my solution I had been writting in Beta 2 and tried building my Application which i am writing. Four hours later I have pulled all my hair out, because I can not get past the error below. I am writing an IM program which uses a class i have in another project in the same solution, I have added signitures, and tried rebuilding but nothing seems to work this Error 294 Assembly 'J:\MyApp\Build\Utils\Settings\MyApp.Connections.dll' must be strong signed in order to be marked as a prerequisite. IMClient What can i do I have tried everything, Im desperate! ...Show All

• Visual Studio Convert Property to Item with transform

  If I have a property $(MyProperty) with semicolon separated items and need to have a item list @(MyItems) it's fairly easy to convert: <PropertyGroup> <MyProperty>a.xml;b.xml;c.txt;</MyProperty> </PropertyGroup> <CreateItem Include="$(MyProperty)"> <Output ItemName="MyItems" TaskParameter="Include" /> </CreateItem> <!-- now I can display just the filenames, like so --> <Message Text="@(MyItems -> %(Filename), ', ')" /> But, if I want to selectively create my item list with a condition, I can't use transforms to examine the items ...Show All

• Windows Forms Looking for a LOGIN form example

  In my project I want to add a LOGIN FORM  to authenticate users of my application. I am in the search of a model of Login Form and his management. Thank you for your reponses.  thanks Mustapa for you response. That resolve my pb ! ;-) ...Show All

• Windows Forms problem when generate strong-named assembly

  When I generate strong-named assembly, there is a problem only in cpp project.(in c# project is ok) For example:I added code: [assembly:AssemblyDelaySignAttribute(false)]; [assembly:AssemblyKeyFileAttribute("mykeypair.snk")]; [assembly:AssemblyKeyNameAttribute("")]; It build successfully. But when add the dll to GAC, there is error: "Strong name signature verification failed for assembly test.dll. The assembly may have been tampered with, or it was delay signed but not fully signed with the correct private key" I do not tamper the dll or make it delay signed. And the file contain private and publi ...Show All

• Software Development for Windows Vista ActivityValidators running on compile

  Quick question here on something I'm not clear one: I've got a custom activity library project (C#), on which I have created a custom ActivityValidator-derived class for a custom activity. The validator itself works just fine, the problem is actually compiling the custom activity library. What I'm seeing happening here is that the actual validator is getting run when the actual activity library is compiled. It seems the workflow targets invoked on the .csproj build file actually creates a default instance of my custom activity and tries to validate it, and, of course, the validation will fail because the default state of the activity is inva ...Show All

• Visual Basic Webbrowser printer settings

  Is there a way to modify the printer settings when using the webbrowser.print() method I want to set these option without the user seeing the print setup dialog. I've tried all of the various registry "hacks" but they have never fully work correctly. I've been searching for a complete solution to this problem since 2001 and it seems like printing an html document with programatic control over the settings is impossible ...Show All

• SQL Server SQL Express Silent install failure

  I am getting this error: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0 in this file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_CBXP_Core.log Maybe that's not a fatal error, but the SQLExpress service does not get installed. I am trying to launch a silent setup using this code in BLOCKED SCRIPT '====================== cmd = "C:\SQLExpress\en_sql_2005_express.exe" cmd = cmd + " /wait /qn /norestart ADDLOCAL=ALL SAPWD=mysapwd DISA ...Show All

• Visual Studio 2008 (Pre-release) What may actually be serialized?

  Hello! What may actually be serialized, general cyclic graphs including the generic collections in the .NET framework and more, or, what's the limit Best regards, Henrik Dahl Hi Henrik, have a look at the following article: http://www.theserverside.net/articles/showarticle.tss id=DesignServiceContracts Roman ...Show All