Brian Laws's Q&A profile

• SQL Server Help backing up and restoring database

  Hi, I have been using the backup feature of SQL Express for some time and I thought it would be good to test a restore in case the worst happend. I moved my bak files to a usb memory stick and copied them to a machine and installed SQL Express so its empty no database's etc. So I right click the databae folder and choose restore from device and point to the db's but I get errors restoring them. What am I doing wrong Is their any guides that give steps to backup and restore database's Any help would be great - I can of course provide more information need be. Thanks, Adam. Hi, Here is a good reference article for backup http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c11ppcsq. ...Show All

• SQL Server Slicer and axes interaction in MDX Part 1 - coordinate overwrites

  A question regarding this Blog post by Mosha. I have tried the MDX examples with SP2 CTP 1 (November) and still get the wrong results. Is this fixed in a later release of SP2 Regards Thomas Ivarsson Thank you Mosha. I should be able to see this in CTP1 What version of the Adventure Works cube are you using(Standard or Enterprise) Have there been any changes in this cube since the RTM of SSAS2005 one year ago I will check again with a never version of Adventure Works. Regards Thomas Ivarsson ...Show All

• Visual Studio Tools for Office Strange behavior: RichTextBox

  Hi, I am creating a .doc with VSTO2005. My document contains several Controls such as Buttons, RichTextBoxes, ComboBoxes, etc. which are generated at runtime. In some cases, I encounter the problem that a RichTextBox doesn't display the content (text) it should, but only displays a big red cross like this: \   /   \ /   \ When I click into the RichTextBox field (with the red cross in it), the following, weird message appears: “Windows Forms controls have been disabled because the document has been scaled. When zoom is returned to 100%, controls will reactivate.” But actually the zoom of the document hasn’t changed at all! Has anyone already encountered this problem Thanks fo ...Show All

• SQL Server SQL Table valued function as Partition Data source. How?

  Hi, How can I use table valued function as data source for a partition Is it possible Here's an Adventure Works example from Erik Veerman's blog - is this the approach that you were looking for http://solidqualitylearning.com/blogs/erik/archive/2005/12/16/1503.aspx >> Managing Analysis Services Partitions with Table-Valued Functions (table UDFs) I've been spending much of my time recently working with Analysis Services 2005 (SSAS).   You'll see a few blogs in the near future with some practical learnings/ideas on SSAS in tandem with my SSIS blogging.   Here's one of them... Something I've always wanted to do in Analysis Services 2000 (MSAS) was use a ...Show All

• SQL Server how to get the duplicate file in ssis

  is it possible that i can retrieve the list of all records that are duplicate and put them in a excel files Hi thanks for the reply, It work nice, somehow it disappoint me a bit (not on your answer), cause i thought i won't use the query anymore to disect the data and I thought ssis has tool for this. Anyway thanks!!! Jagapathi Raju wrote: Hi There, Use this query to get the duplicate records from a table, if you are using flat file as a source, load it to the database table and use this query: select coulmn a from <tablename> where column a in (select column a from <tablename> group by column a having count(*) > 1). This query will give you the list of records which is ...Show All

• Visual Basic DataGridView -> DataGrid

  Hi, Anyone know how to convert datagridview into datagrid Or put datagridview data into datagrid thanks in advance Dick Donny wrote: Is this what you are looking for dim dg as datagrid, dgv as datagridview ........ dg.datasource = dgv Richard dg.datasource = dgv.datasource ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rendering to a Texture?

  I tried to do a search but kept getting an error message. I was wondering if anyone had an example on how to render to a texture under XNA. Thx In order to write anything even remotely ambitious, you must have the ability to Debug what's going on with Direct3D underneath. You need: Visual Studio 2005 Professional. Turn on "Unmanaged Debugging" Use the Debug version of DirectX. If you have all this enabled, you should see very detailed information in the Output window whenever something goes wrong. If you don't have all this... get it. You will wonder how you ever survived without it. ...Show All

• SharePoint Products and Technologies Custom Site Definition with custom master page and Form Pages

  I have created a custom site defintion based on the existing STS definition. I have created custom master page and included in the site defintion. All works fine with default.aspx when site is provisioned. However, the the master is not being applied to form pages (AllItems.aspx, etc..). How do apply my custom master page to these forma pages using site definition . Thanks ...Show All

• Visual Studio Express Editions embedding .swf to vb.net forms

  can someone give me the codes needed to embed an swf file ( a flash animation for the banner) in a window form.. thanks.. im using the version 8, macromedia pro... thanks. Put your swf file in My Documents. Rename it sample.swf. Open notepad. Type <html> <body> <OBJECT CLASSID="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" CODEBASE="http://active.macromedia.com/flash5/cabs/swflash.cab#version=5,0,0,0"> <PARAM NAME="MOVIE" VALUE=" sample.swf "> <PARAM NAME="PLAY" VALUE=" true "> <PARAM NAME="QUALITY" VALUE=" best "> <PARAM NAME="LOOP" VALUE=" true "> <EMBED SRC=" sample.swf " WIDTH=& ...Show All

• Visual Studio Express Editions How do you propagate a SQL Sever schema change to an existing VB 2005 project

  I am working with VB 2005 Express and SQL Server Express. I have an app up and working well based on the current SQL database schema. How can I change the database schema (add a table, change the data type on a column, etc.) and propagate this change into an existing VB 2005 application. I tried this once by trying to reconfigure the database via the Wizard and lost all of the previous customization of the database (queries, fills, etc.) in the VB application. (I resorted to a backup copy.) It will be hard to give a specific solution without knowing the specific schema change, but here goes... In general, do the things needed to change the database from the Server Explorer first, then alter the .xsd file with your TableAdapters t ...Show All

• Smart Device Development 850428 - strh instruction

  how can i tell embedded visual c++ not to produce strh, str, ldrh and ldr instruction, never ever in any part of my code this will solve the alignment exception very easily. i don't mind about the performance of my program. i prefer it to be reliable. i don't need MS to decide for me! i need an option not to use benefits of technology! i need an option to tell the compiler not to produce these instructions. how can i do that a very good sample code u gave, thx and about what u said, alex, let's don't make things more complicated than what they really are! when the writer may use some words exactly in place of others, like "horrible" in place of "awful", it must be an option for ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is the Keyboard class in the 360 xna framework useable?

  I was using the object browser in C# express and noticed that the Keyboard class was present for the xbox360 (C:\Program Files\Microsoft XNA\XNA Game Studio Express\v1.0\References\Xbox360\Microsoft.Xna.Framework.dll ) assembly. Under the Microsoft.xna.framework.input namespace. So I was wondering is this by mistake If I plug in a usb keyboard into the 360 can my app/game make use of it (I don't have creators club yet to test it) Yes. It works fine... except that on my compact Cherry keyboard, Left-Ctrl, which I was using for shooting, is not recognised (and maybe some other keys - haven't tried all of 'em). Stuff like arrow keys, spacebar etc work great. Handy for quick testing when you don't want to r ...Show All

• Visual Basic Invalid Error Message while utilising umanaged DLL

  Hi All, I have a peculiar kind of issue after converting VC and VB code from Visual studio 6.0 to Visual Studio 2005. We have the business logic in the VC code which uses the ATL framework and implements a COM server. VB code gives the GUI part of the project, For reporting custom errors like invalid login, we use AtlReportError method to report error from the VC code side. While utilising the built VC dlls(unmanaged code), using VB 6.0 applications, we get the Error message text( like in the case of failed login), exactly as we require. But while utilising the VC dlls in a VB 2005 application, instead of getting a error message we see "Exception from HRESULT : 0x8004B411". I do not know the reason cause for displaying such ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The XNA Framework and DirectX

  Hi! Do I need to at any time learn DirectX when working with the XNA Framework In other words does the XNA Framework provide everything that DirectX provides, but without writing a single line of DirectX code Thanks, O. Thanks for the fast reply. I think I'm happy about the answers. I'm very interested in the XNA and want to try it out, but I haven't written a single line of C# code. So I got my first C# book today. Something to read during Christmas. ;) After that I'll see if the hype around XNA is real, at least for me. At the minimum I've learned something of a new language for me. O. ...Show All

• Visual Studio Report Parameters Probloms

  Hello I'm trying to pass parameters to a .rdlc report with no success using this code: Dim Report_Param(0) As ReportParameter Dim a As String = "A" Report_Param(0) = New ReportParameter( "A" , a) ReportViewer1.LocalReport.SetParameters(Report_Param) ReportViewer1.LocalReport.Refresh() The exception is generated in the SetParameters command. Does anybody know what is the problem ...Show All