Cyber Sinh's Q&A profile

• SQL Server Synchronize table with different name

  I am new the Replication service. If I have 2 server A and B. A has a table named "Table1" and B has a table named "Table2". The schema of table is same. Could I do the replication (E.g. snapshot) from A Table1 to Table2 in B If yes, how Thanks. Yes, it's possible, replication supports publishing table/object and subscription table with different names. When you call sp_addarticle for snapshot and transactional publication (or sp_addmergearticle for merge publication), explicitly specify @source_table (or @source_object ) and @destination_table with different names, for example: EXEC sp_addarticle @publication='TestPubName', @article='TableArt', @source_object='Tab ...Show All

• SQL Server Problems splitting name field

  I am reading in data from a legacy system where name data is in one field. The single field includes last name, first name, middle initial(sometimes), and suffix(sometimes). Due to the optional components it is a bear. I am using a fuzzy lookup on the suffix and derived columns for the first, last, and middle initial. The first name and suffix work, but I'm having trouble with the last and middle initial. The following is the formula I'm using for both. The first name formula is causing an error, and the middle initial is only populating if the suffix exists. If anyone has insight, it is appreciated. FirstName: TRIM(SUBSTRING([ARPNAME-T],FINDSTRING([ARPNAME-T]," ",1) + 1,FINDSTRING([ARPNAME-T]," ",2) - FINDSTRING( ...Show All

• SQL Server AS 2000 with 64 bit OS

  I moved one of my AS 2000 olap db new server -Windows 2003 "64-bit" OS with lot more processor then old server "32-bit" Windows OS. Good news is my cube processing I save 50% time but my query performance is slow, I was thinking my query should fly. I have AS 2000 "32-bit" in "64-bit" Windows server. I have same settings in AS 2000 as old server. Thank you - Ashok Well, first of all, if you running IA 64, you should install 64bit version of Analysis Services and run natively. Second, running on higher end machine doesnt neccessarily means single query performance is going to improve drastically. With higher-end hardware, you should get higher throughput, ...Show All

• Visual Studio Express Editions Working with embedded resources

  Hi, here's the recipe I found for using embedded resources: 1. Open your project resX (ex Form1.resX) and select from the tab the type of resource (ex Ausio, Images, etc) 2. Add by choosing your file (ex here "mysound.wav") 3. in the code, to use the res: String^ ressrc = "Project1.Form1" ; System::Reflection::Assembly^ execAssem = System::Reflection::Assembly::GetExecutingAssembly(); myres = gcnew Resources::ResourceManager(ressrc, execAssem); String^ sound = "mysound" ; Stream^ s = myres->GetStream(sound); SoundPlayer^ pl = gcnew SoundPlayer(s); pl->Play(); hello thanks for your sharing. but i don't see any questions he ...Show All

• SQL Server Unhandled Exception

  After I installed Sql Sever 2005 and open SQL Server Management Studio, I get this error just after connecting to any server (DB / AS / IS).. Also, during the installationm, I had ignored an error that was raised while SSIS was being configured. The error said, that thr is already a 32 bit registry on the target Com + Application. You must remove the registry from that app. I have done the installation of SS2005 X64 edition. Attaching the exception :- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.TypeLoadException: Method 'GetMenuItems' in type 'Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Default ...Show All

• .NET Development ASP.NET web site publishing via command line

  Hello! Does anybody know how to publish ASP.NET web site via command line. I want to automate this process, but I did not find tool (in Visual Studio 2005 or .NET Framework 2.0) to perform this action. Does anybody know another way to publish web site (for example via COM or SDK assemblies), if such tool does not exist L.G. Thank for interesting link! But nevertheless I want to use ready utility... I know that Visual Studio 2005 has "Copy Web Site" tool. May the utility which does this action exists or you know other high-level utility for work with FTP and delivering with Visual Studio 2005 ...Show All

• Windows Forms PropertyGrid Adding EventsTab

  I am having problems adding the EventsTab to the propertygrid. I have not been able to find much information on how this is done and documentation is very rare. My code adds the EventsTab to the propertygrid but it never gets displayed. I am setting the Site of the propertygrid to that of my designer as I have seen that you should do this but still It doesn't display the EventsTab. Any help would be much appreciated. Thanks intrus0 wrote: Thank you very much for your help, Giftednewt and Quirk. The truth is that I don't understand this process very well (I don't known where I have to add the OnSelectionChanged event to filter the events, for example), I couldn't quite ...Show All

• Visual C++ Unhandled exception

  Hi All, hr=CoCreateInstance(CLSID_Component2 ,NULL,CLSCTX_INPROC_SERVER,IID_IUnknown ,( void **)&pIX); //REsult of HR is s_ok but when i am calling following function i am getting error as: Unhandled exception at 0x00000000 in App.exe: 0xC0000005: Access violation reading location 0x00000000. hr= pIX->SetAuthor(( char *) 'd' ); Additional info: The code lies in lib .which is then added to dll. Plz help . Maybe instead of hr= pIX->SetAuthor((char*)'d'); you should try this: hr = pIX->SetAuthor("d"); I hope it helps. ...Show All

• Visual FoxPro I need to create multiple froms or selects into one cursor with recno()

  I need to take this statement: select recno () from ProvIDs as PRecno and I need to add it to this Statement: select i.DrID,; ALLTRIM (p.PrvLName)+' '+ ALLTRIM (p.PrvSuf)+','+ ALLTRIM (p.PrvFName)+' '+ ALLTRIM (p.PrvMName) as ProviName,; i.SiteID,; ALLTRIM (s.SiteAdr1)+','+ ALLTRIM (s.SiteCity)+' '+ ALLTRIM (s.SiteSt) as SiteInfo,; i.PayorID,; i.IDType,; i.ProvID,; i.DtEnroll,; FROM ProvIDs i, Providers p, ClientSite s ; where i.FedTaxID=Organization.TaxID ; and i.FedTaxID = p.FedTaxID; and i.DrID = p.DrID; and i.FedTaxID = s.FedTaxID; and i.SiteID = s.SiteID; into cursor GridIDs readwrite I need to get one cursor that will have all the data PLUS ...Show All

• .NET Development Increasing Memory Usage in .NET 1.1 (Very Urgent)

  Hi, I've developed a dummy WinForm application (named GCTest) with the following functionality in .NET 1.1 (VS2003): 1. In Button1 click, a text is assigned to a Label. 2. In Button2 click, i've called GC.Collect(). While running this app, without doing anything, the memory usage is increasing from 10KB to 100KB. If i'm moving mouse, resizing, minimizing or maximizing the window, the memory usage is increasing consistently 60KB. If i click Button2, then memory usage increased upto 100KB. My machine config: PIV 3.2GHz, 1GB RAM .NET Version: 1.1.4322.2032 (i.e with service pack 1) OS: XP SP2 How can i stop the increase memory usage problem Regards, Udooz Hi Udooz, How a ...Show All

• Smart Device Development how to minimize the form?

  how to minimize the form. and develop platform is c# .net cf hi JR my code is below: Form1.visible = false; Form1.refresh(); but it can not pass build. The notify is the form1 does not own the visible and refresh(); Why Thank you ...Show All

• SQL Server Need Help with Foreach ....Anyone...........

  Hello, I am new to SSIS. I need to create a SSIS package that can loop through the databases and create a flat file of each table in the database specified. Is it possible with Foreach to loop through databases and tables How should I proceed with this I would probably need step by step procedure because I am new. I would really appreciate your help. Thank you. Grant Swan wrote: hi, I'm not sure if this exactly what you are looking for as i've not used it myself but... There is an ADO enumerator for the foreach loop which allows you to enumerate tables in a database. Here is a link to a similar subject, hope it helps. http://www.codeproject.com/useritems/foreachadossis.asp Cheers, Grant Grant ...Show All

• Visual C++ Doubt about build

  Hello, i have been using visual c++ from 2 weeks, and this have been my first time using. I have alwas write c++ code with other aplication, and i have this doubt: what it’s the meeanig of buil a proyect this debug or release configuration, i want to know what it’s the difference between these two. Can someone tell me debug build has compiler optimizations turned off, and you can step through the code in the debugger. release build is what you will ship to your customers once you finish your product. ...Show All

• Visual Basic Form show unrequested

  To get some experience using VBE, I converted a simple program I once made for myself(VB5). It's a birthday calendar, using a VB5 commandbutton for each day of the year, i found that VBE has great problems handling this many controls, it is slow, very slow and realy unworkable. Some where else in this forum I found that others with a lot of controls experience the same problems and there is no neat solution for it. In the mid 80's the basicinterpreter was quicker than this VBE with a machine that is 2000 times faster. Another problem I have is that the main(start) form of the program shows up unrequested. In the load section of the (start)form I show another form from which I normally select whether I show the (start)form or not. The se ...Show All

• .NET Development Sproc insert problem

  I thought I knew what I was doing, but thatis no longer the case. I want to insert data into SQL 2005 from a text file that I parse. I build a DataTable: [CODE] public DataTable tbl = new DataTable(); public DataTable buildType4DataTable() { DataColumn loadTransactionCode = new DataColumn(); loadTransactionCode.ColumnName = "loadTransactionCode"; tbl.Columns.Add(loadTransactionCode); DataColumn companyID = new DataColumn(); companyID.ColumnName = "companyID"; tbl.Columns.Add(companyID); DataColumn cardholderIdentification = new DataColumn(); cardholderIdentification.ColumnName = "cardholderIdentification"; tbl.Columns.Add(cardholderIdentification); D ...Show All