NewGuy212's Q&A profile

• SQL Server how to restore database from full backup and several diff backup

  I have a full backup and several diff backup,now i want to restore firstly,I restore full backup RESTORE DATABASE *** FROM DISK = 'D:\databackup\200610140000.bak' WITH NORECOVERY GO it's working,then i don;'t know how to continue Thanks in advance If you have full and differential backups, start with the full backup using the WITH NORECOVERY option. Then restore the differential backup, this time using the WITH RECOVERY option. Note that the syntax for both RESTORE (full and differential) are similar. You just have to specify the backup device which contains your differential backup. If you need data after your most recent differential backup, make sure you have your database recovery model ...Show All

• .NET Development convert string to an io.stream

  Hi I've got a text string which I need to convert to a system.io.stream. How do I do this (in VB.net - 2005) Thanks Bruce Forgive me if I make any mistakes, my VB is very rusty: Using writer As StreamWriter = New StreamWriter(stream) writer.Write(myText) End Using ...Show All

• SQL Server Simple Join Not So Simple

  Hi, I have the following situation (with a site that already works and i cannot modify the database architecture and following CrossRef tables -- you will see what i mean by CrossRef tables below) I have: Master table Hotel table AddressCrossRef (with: RefID = Hotel.ID, RefType = 'Hotel', AddrID) joins table Address (key = AddrID) table MediaCrossRef (with RefID = Hotel.ID, RefType= 'Hotel', MediaID) joins table Media (with MediaID,mediaType = 'thumbnail') foreach hotel, there definitely is a crossRef entry in AddressCrossRef and Address tables respectively (since every hotel has an address) however not all hotels have thumbnail image hence i have hotel inner join AddressXReff inner join Address ..... however i must have left outer j ...Show All

• Visual Basic Vvarious user controls need to reference Module1.vb

  Module1.vb needs to be available to various user controls which utilize methods in this file. Where do I put this file and then how do I reference it from within the user control projects Can I wrap these interop Functions into a class and instantiate it I can create a class library within a solution but not a 'module library' Thank you for allowing stupid questions. -Greg Module1.vb Imports System.Runtime.InteropServices Module Module1 Public Declare Function SetSelectedAxis Lib "foo.dll" ( ByVal Index As Long ) As Long Glad to help! :) You might want to flag this as answered if you're good to go... James www.jamesfoxall.com ...Show All

• Smart Device Development Using API in VB code

  Dear colleagues. Could some body told me: how i can call API function from VB code For example i am using this structure: ----------------------listing------------------------- Private Declare Function tapiRequestMakeCall Lib "TAPI.DLL" (ByVal Dest As _ String, ByVal CalledParty As String, _ ByVal Comment As String) As Long Function PhoneCall(ByVal PhoneNumber As String, ByVal DestName As String, ByVal Comment As String) As Boolean If tapiRequestMakeCall(Trim$(PhoneNumber), Trim$(DestName), Comment) = 0 Then PhoneCall = True End If End Function Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click PhoneCall("+7xxxxxxx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cannot open include file: 'windowsx.h'

  I am getting the following error when trying to compile chapter 2 code for the book "programming a multiplayer fps in DirectX" by: vaughan young I am using visual c++ 2005 express edition and have installed Microsoft DirectX 9.0 SDK (October 2004) and Microsoft DirectX SDK (June 2006) I don’t know how to get the compiler to see the DirectX and I have never used DirectX before. I recently purchased a bunch of DirectX books in hopes to get into making games and multimedia programs but had to also up grade to this new compiler that I don’t know a lot about. before this I had been working with text based applications. There seam to be nothing on the web about how to get this problem fixed. I have checked everywhere. If some one ...Show All

• SharePoint Products and Technologies accessing trace information

  when i am developing a web part or custom field control and i deploy it in production. how do i do to troubleshoot a pb. I guess we use tracing by writing trace.write... right How do I access those trace messages that I write 2/and pls is there another way to troubleshoot a pb while in production environnement thank you very much enable trace and or pageoutput in web.config and access either the pages directly or trace.axd in the site like: http://mysite/trace.axd in code add: Trace.Write or Trace.Warn or System.Diagnostics.Trace.Warn(....... Thanks ...Show All

• SQL Server Why Publications Does not Show in Replications

  Dear All, Greetings!! I have installed SQL server 2005 Express and SQL server Mobile, and I was reading the Books online section to find out how to maintain the two databases consistancy. Found : replication Option. Problem : It only shows Local Subscriptions in SQL Server and In SQL Server Mobile only Subscription. I dont get a Publication Option. Please correct if Wrong : SQL Serv Mobile is the one should Publish and SQL Serv hould Subscribe ya Please help me to sort this out. Hi Mark, Neither SQL Express nor SQL Mobile support being publishers. SQL Workgroup Edition is the first Edition that offers that functionality. Regards, Mike ...Show All

• Windows Forms how to centered aligned MDI child window when maximized

  when child window is in normal mood, it could be centered screen, but when it is maximized then it is not centered, is there any trick i could centered it even  inmaximization moode. Thanks   When it is maximized, it fills the screen. Possibly leaving the toolbar visible, depending on its "mood". How do you want it centered and fill the screen too ...Show All

• Internet Explorer Development Why IE can not open a page, but Firefox can?

  Hi all, We have an authentication applicaiton and the application is based on Weblogic Server 8.1. There are three pages/servlets involved in the login process: login.jsp, LoginServlet, and menu.jsp. If user inputs correct username/password and clicks the login button, the LoginServlet will verify user's profile and set some cookie into HTTP Response. Fianlly, the servlet will redirect the user to menu.jsp. Right now we are facing a weird phenomenon: based on one specific user, we can not login using IE, but can login using Firefox or Opera. In IE, after inputed username/password and clicked the logon button, "The page cannot be displayed" is presented on screen. And, the URL in the address bar is the URL of LoginServlet. The lo ...Show All

• SQL Server Error: System.Runtime.InteropServices.COMException ...

  Error: System.Runtime.InteropServices.COMException (0x80040428): Exception from HRESULT: 0x80040428 at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread() Can anyone tell what caused this error when I tried to run the DTS package from my SSIS package Thanks. Steve If you trust the internal logic of your package, then an error condition - especially from an Agent job - usually points to the package's interaction with external resources; in particular, to permissions issues. That's probably why no longer trying to write to an exception file solved the problem for the other gentleman. Check the package's use of database connections and file system resources, ...Show All

• SQL Server HOW to browse KPI's Result Data through ADOMD.NET?

  Hi, My question is how to browse KPI's Result through ADOMD.NET I mean to get a KPI's Result Data, not get the metadata of KPI, not get the KPI's Value Property(String) either. I see the MSDN said about AdomdDataReader, but it doesnt tell how to get a KPI's Value. I guess, I need to get KPI's metadata first, and get a KPI's Value Property, that's a MDX, you know. Then I bring the MDX to the AS server, and get the result. Is it right But, if so, when i want to slice on a dimension when I check the KPI's result, how could I do I have got a KPI's Value Property MDX, then I need to modify the MDX to add the dimension slice to it manually Thanks. Via an MDX query, you can retrieve the various values associ ...Show All

• Software Development for Windows Vista July CTP breakpoint on state machine workflow can't open the workflow designer

  Dear all, I am trying to debug a state machine workflow in the July CTP of WF. I have set a breakpoint on the state machine workflow, but when I debug and the breakpoint is hit, I get: Are you using the Visual Studio 2005 Extensions for Windows Workflow Foundation Release Candidate 4 The RC4 extensions map up to the July CTP... -- Bryant ...Show All

• Visual Studio Express Editions How to interrogate a query?

  I wanna to interrogate a single field in side a specific query. Can I to proced I wanna to know before, how to load a single query in a specified object. Please, anybody could to help me Thanks Not sure what you are after...but you can write and call your own query.. MyCommand.CommandText="Select TheField From MyTable Where TheOtherField > 0" MyReader = MyCommand.ExecuteReader While MyReader.Read Console.WriteLine(CStr(MyReader(0))) Loop ...Show All

• SQL Server Any other way but Cursors or While loop

  Hi all, I have a bit of a challenging on my hands with this, i have a result set in a table which i am trying to iterate through the rows one by one i.e Values Values Dates 1.10 1.20 1.30 1.40 2006-03-31 00:00:00.000 2006-06-30 00:00:00.000 2006-09-30 00:00:00.000 2006-12-31 00:00:00.000 go to each row get the value and the date perform some calculation with the value and the date and insert it into another table(which sounds easy enough) my problem is how do i iterate through the result set one by one without using a cursor or a while loop do i have any other options at all Shadow: You can take advantage of t ...Show All