seprice's Q&A profile

• SQL Server Configuring merge replication for side-by-side SQL Server 2000 and 2005

  I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing. So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running ...Show All

• SQL Server newbie - user permissions

  I have added a new user to a database without any explicit permissions, but when I view their effective permissions inside the Microsoft SQL Server Management Studio, they have a whole host of permissions. How can this be Is it a bug in SQL Server Or could it be that the public role has all these permissions If new users are inheriting these permissions from the public role, how do I view the public role permissions Thanks. You can check to see what groups/roles you have in the database by querying sys.database_principals. You can then query sys.database_permissions for each group/role to which your user belongs to, to see what permissions these are granted. Or you could work the other way around an ...Show All

• Visual C++ authentication question

  hi all i have a gui....but i want that person will be able to use the gui only if his user name and password matches with which is stored in the system.....i have 2 edit box for username and password in the gui......so once the person presses authenticate button..........it shud compare it with wat is stored in system.......n if it matches then only he will be able to use other functionality.....so my question is how do i retrieve wat is stored in the system n compare it with wat user enters...... thanks kunal As cgraus points out, this is probably not the best way to validate users, and not even what you really want or need. If you still feel the urge to do so, however, the LogonUser method s ...Show All

• Windows Forms Hooking Keyboard events from the DesignSurface

  Hi I need to get the keyboard events inside the forms designer (move controls with cursor keys etc.). I know that this can be done with Application.AddMessageFilter(myMessageFilter) - but I'm doing a WPF application and no Windows.Forms stuff (beside the designer which is hosted). Is there another way to do this (I could try to make a Windows Forms Application, hosting my WPF application which hosts the designer ... but). Regards Mike ...Show All

• Windows Forms Reload Form

  I need to reload a form.  Reset everything to it's default values as if the form was just opened.  It's the only form in the project. How can this be done Thanks, Zath Hello, The code you posted works great, except for one minor cosmetic issue: as you show & close the form, there is a "flicker" in the taskbar as there are briefly two forms open. Is there a way to prevent this Also, by disposing of the form, you are basically hitting the "reset" button on all of the form's variables, correct Each time the above code is run, it retriggers the form's Load event. I am frustrated by the fact that there is not another way to reload a form and set it back to t ...Show All

• Smart Device Development VS.Net 2003 Installer

  Hi, I am looking for a way to make a smart device installer for my application made with VS.net 2003. I have tried to use the article for VS.net 2005, but the user interface of the IDEs are different. For example, the first step is to make a "Smart Device CAB project" but this isn't one of the project options in the 2003 IDE. I can make a "Cab Project" but I think it could be different than a "Smart Device CAB project". Here is the link I already read for the 2005 IDE. http://msdn2.microsoft.com/en-us/library/aa446504.aspx Does the KB article for 2003 smart device projects still exist I remember reading it several months ago and I bookmarked the link. My bookmark no longer works. I'm looking for an ...Show All

• SQL Server Msdb.Sysjobhistory

  I have a SQL 2005 server that has a number of jobs that run throughout the night for some strange reason I not getting any entries into the sysjobhistory table. There is not limit on the size of the table. T he jobs have include step output in history selected. I need to the data that is suppose to be in sysjobhistory for other tasks. Please help. Andries ...Show All

• SQL Server where are store Proc & Functions and so on in 2005?

  In 2000 you could look at templates and find templates for global or system functions where are they in 05 If you want to see the definition of the system stored procedure and function, you can open Management Studio, connect to the sql2005 instance and click Databases -> System Databases -> master -> Programmability -> Stored Procedure -> System Stored Procedure. ...Show All

• Visual Basic Score

  Hi, I've recently started using Visual Basic 2005 express edition, so I'm pretty new to the language and so. Though I'm getting the hang of it! But I have one question: I'm trying to make some questions in my program, something like this: Translate the following sentences from English to French: Do you live in England ................................................................[textbox] Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "Tu es alle en Angleterre " Then MessageBox.Show( "Good!" ) Else : MessageBox.Show( "False!" ) End If End Sub Then if you type it in c ...Show All

• Windows Forms saving values and refreshing in datagridview

  I have a datagridview in which I am 1) changing values 2) I want these changed values to show in the datagridview 3) use these changed values from the grid to go back and perform 1) and 2) again on other values in the gridview but do not save the changes to db yet. when do i need to endedit on the underlying binding source how often would I need to refresh the gridview, and endedit on the datagridview   Thanks Nik   I found the answer kinda: Anytime I make changes to the datagridview, and want to use the changed cell values for another operation; I have to focus on another cell, and then come back to focus on the current cell. This refreshes the datagridview(I could ...Show All

• Visual Basic VB.NET 2003: Object must implement IConvertible Error...

  The Following post explains in detail the error I am receiveing and provides the modified code I have implemented based on help tools. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=828435&SiteID=1 The problem is the choice of Database Column Data Type and the related examples. The Data Type must be Image, but based on the examples which all worked with .JPG or .BMP and the Name Image (I inadvertently assumed that picture file types had their own database column data type). The Image Data Type is a byte level Image of the File regardless the type. Therefore when I changed the Column from NText to Image it worked like a champ. ...Show All

• Visual C++ Checking whether another instance of the application is running

  Hello, Does anybody know how I can check whether another instance of an application is running or not using VC++ and MFC Thanks. efarook wrote: Thanks for your response. What I was trying to say is that I developed an app using VC++ with MFC. I want to check whether another instance of my app is running or not. Actually I want to prevent running of multiple instance of my app. That's all. See the article linked by Nish, that will help you achieve just that. ...Show All

• Visual C++ Unresolved external using a namespace from a DLL

  Hi, Under Visual Studio 2003, I have a DLL that exports a class, and I am trying to use the class from the DLL in a simple test application. The class in the DLL is defined inside a namespace. The problem is that the test application builds fine in debug mode, but I get a link error in release mode: Maybe the DLLDIR_EX symbol is not defined in Release configuration of DLL project ...Show All

• .NET Development ASP.NET EXCEL TO XML CONVERSION

  I am using asp.net and i need to convert an excel file into an xml file and send it as an dataset/datatable parameter to the server. the point is i want this to be done at the client side only. Appologies... sometimes when I am at work, my attention to detail with respect to side tasks is limited. If the excel file is already located on the client's computer... then you might consider ODBC. You can actually use an Excel file like a datasource (a database) and retrieve records in much the same way. Writing the Xml file should be easy enough. I would do a search on MSDN for Excel + ODBC to see what sort of suggestions I could find with respect to such. I believe that the data tables will be named $sheet0 ... $sheetn and the field ...Show All

• SQL Server passing multivalue parameter in a URL action

  How can I pass a multivalue parameter via a URL action on a report item I've tried using Split and Join but it doesnt work. Any ideas Multivalue paramters are accessed in URL within the following schema: Report_Param_Name=A&Report_Param_Name=B&Report_Param_Name=C so AFAIK you would have to write some own sophisticated code to do this. HTH; Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All