DavidC#2005's Q&A profile
SQL Server How to do backup in Cluster
Hi, I have a cluster set up and working fine. I am in a stage where I need to do the backups. I have added 4 disks as dependecies to the sql service for the instance. The backups should not be on these disks. When I do a simple backup I can see only these 4 disks so my question is how do I do the backup to fileshare or other disks that are not partof the cluster. I have 3 virtual servers so what wil be the best thing to do for backup Thanks Is there a reason for not sending your backups to disks which are part of your cluster group Certainly you wouldn't send backups to the same disk as the database is stored on, but another disk in the same group should work just fine. ...Show All
SQL Server Setting up XA Transactions for JDBC / JOTM
Hi, I'm setting up a JDBC-based system that should do distributed transactions between SQL Server 2005 (Express/Standard) and Oracle. I'm using Tomcat and JOTM on the application server side. The SQL Server JDBC documentation (http://msdn2.microsoft.com/en-us/library/aa342335.aspx) mentions required steps for adding a DLL (sqljdbc_xa.dll), a set of stored procedures (xp_sqljdbc_xa_*) and a databaase role (SqlJDBCXAUser ) in order to use distributed transactions. However, my system seems to work without all this. Are these steps really needed How do I know whether my installation was successful or whether my system really does 2 phase commit I am suspecting that maybe JOTM uses simple transactions if it's connected to non-XA connections. ...Show All
.NET Development Delegates/events short question
Hey , I would like ask a few questions and I'd appreciate if someone could clarify the issues for me. Firstly: what is the difference between a) this .Load += new System. EventHandler ( this .Form1_Load); and b) this .Load += this .Form1_Load both seem to work , is there an implicit cast to ( EventHandler ) in the b) case Secondly, how does the compiler treat function names like Form1_Load or any other In C++ they were seen function pointers, how does it work in C# Does the compiler understand function names as delegates The last thing is what does actually line a) do As far as I understand it, this line concatenates the invocation list of the "Load" event delegate with the invocation list ...Show All
SQL Server How to set douplicate id in sql server 2005?
Hi There, Some one please help me to achieve this task. I have task to join 2 tables and insert values.The table which i am inserting values has typeid column which is primary key column.I supposed to insert values except this column(TypeId).When i m trying insert values its throw an error saying Error: Cannot insert the value NULL into column column does not allow nulls. INSERT fails. Please let me know ther is a way to set duplicate id for this rows Thanks in advance. Does your query return more than one row Notice that you aren't selecting the max(typeid) from the table, tblType. select MaxKey = case when TypeId is null then 0 else TypeId end from tblType ...Show All
Visual Basic Needing Some Knowledge About Visual Basic
What are the limatations of Visual Basic - I am familiar with html, and dhtml, I'm learning CSS & C+ currently. -- Anyway, my hobby is making all kinds of websites. My cousin wanted me to make her a virtual pet site. Like Neopets R something interactive, where you can have items, stores, pets, and stuff like that. I don't know how to make this, and I've been trying to learn for what seems like forever. However I don't know what to search for to learn this. I found Visual Basic yesterday, and it is soo much easier than notepad. I haven't found out everything about it yet, and I was hoping someone can point me in the right direction, what to search for to learn how to make a virtual pet site.. I know it sounds childish but it's imp ...Show All
Windows Forms Is there any license issue to use and pack "Microsoft.mshtml.dll"?
Hi, Our .Net application relies on "Microsoft.mshtml.dll", but this dll does not come with .Net framework, it is provided by .Net SDK, that means we have to pack this dll with our application and install it during the deployment, or else the client's machine with only .Net framework installed can not run our application. Now I have two questions on the licensing of "Microsoft.mshtml.dll" 1) If I want to develop a commercial product, is there any license issue to use Microsoft.mshtml.dll provided by SDK Is this dll freely useable 2) Is there any license issue to pack this dll into our commercial product into a single install file and distribute(sold) it to our customer That is, is this dll freely re-distributab ...Show All
Visual C# Error Trapping in C#.NET
My question my seem extremely trivial, but I was wondering if somebody can explain what exactly is meant by theError Trapping construct in C#.NET or rather what sort of Errors does it catch and what differences are there between the Error Trapping construct of C#.NET and a typical try{}catch{} statement. Any conceptual clarification will be hugely appreciated. try {} Catch {} blocks does exactly what it kind of states. it will try to execute some code in the try {} block and if there are any errors produced/raised from any code within that block, it will go to the catch {} block to check to see if the exception is implemented/catched and once it finds that there is an exception which is to be expected i ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Console.Write on 360
Simply silly question... anyway of getting the output of Console.Write to somewhere nice (like the Output pane of VS) on the 360 Yeah I'm just porting code that already exists and works on PC... I just wonder why Console.Write doesn't do Trace.Write at the end... I just hate API calls the go nowhere... Had a similar issue with printf on Windows apps why go nowhere either remove the API or make it do something... Not a biggy, just wondered if there was a way ...Show All
.NET Development sql server
Any body can help... how can we make the sql server listens on port 1433, in my system when i issue the command "net start " , it is not showing sql server.exe in the list. and also if i issue the command "netstat -an" it will show active connections and those are in listen state. so My question is if the default server port " 1433" is not in listen state, how can a sql client will connect to the sql server 2000. if it happens like , what are steps to follow to make the sql server port "1433" listen state. ...Show All
Visual Studio Team System How to import work item's custom fields to TFS
Hello! I created new work item type. There are a lot of custom fields in the new work item type. Now I would like to import several thousand work items from excel to TFS. I tried to make XLS file by invoking “Open selection in Microsoft Excel”, fill that file with my data and Publish Changes. But XLS file doesn’t contain my custom fields so I can’t import my data to TFS. Is it possible to import work items with custom fields to TFS May be it is possible to develop some plug-ins to TFS to solve my problem Thanks in advance, Pavel Hello Pavel, You can add additional available columns from "Choose Columns" toolbar item. Please have a look at link htt ...Show All
Visual Basic searching for & highlighting text
hi, i am trying to make my application search for text (in a combobox called "comboboxfind") in a listbox ("showbox") when i click on a button (called "findnow") can someone help me firstly, i want the msgbox to state how many lines were found in the search. secondly, there is another button i have that i want people to press to be taken to the next found line, under the currently highlighted one. and finally, the msgbox still keeps the same line highlighted and nothing else when i click "ok" ...Show All
Visual Basic DataBindingsource.AddNew
Hi I am new to dot net VB. I have few questions.I have auto generated form. When use DataBindingsource.AddNew event I want to fill some values in text boxes after.But which ever event I use text boxes get emptied. second question I have regarding date data field.Once data is entered and saved cannot empty date and save it . Zaabdullah Hi Thank you for answer. I think i did not explain my question.I generated aouto form which is retreving data from database.Now I want to add new record. At pressing Add button all the text boxes emptied ready to enter new record.At this moment I also want to fill some default values automatically. So when Addnew method finish its work to empt ...Show All
Visual C# Better class browser
Does anyone know a better class browser I would like one that stays open (e.g. no drop-down menu) all the time, automatically refreshes its contents for the currently opened file and displays the class members sorted. Any ideas Thanks! I found ModelMaker Code Explorer for VS. It is much better than "Source Outliner" and the built-in class browing tools - cannot imagine working without it anymore. I often work with files containing 10K - 30K SLOC - and CE makes it extremely easy to navigate and modify such files. If you are interested: http://www.modelmakertools.com/code-explorer-vs/index.html ...Show All
Visual Studio Express Editions reading data
i need to know this quickly (job interview) 1. how do i read from a text file to a table (say.... access) 2. how do i read (using recursive methodes) from a table to vb.net 3. how do i read from xml to vb.net its not a small task and requires some indepth experience and knowledge, especially if you are going for a job interview. Remember, you can't lie about the things you talk about or appear to know about, you need to demonstrate it when the time comes to use it. to read a textfile, you can use the FileStream or the StreamReader, both in the System.IO namespace but now you have to explain further about how you are trying to insert it into a database. What do you want to insert each line of data in ...Show All
SQL Server Remarks on CTP3 for V.S T.E for Database Professionals
Hi everyone, I've got the last CTP for V.S 2005 Team Edition for Database Professionals. I have a poor idea what exactly is it for. I suppose some stuff but I don’t know if you can build front-end solutions with that or only to encompass project databases. Anyway, w hen I run setup.exe in order to install on my workstation it's complaining that I’ve got Framework 2.0 Beta installed. I remove it. Fine. After that begins and at the first attempt fails with SMO and setup is aborted. In my wk I haven’t either sql 8.0 or 9.0 so that I imagine it is compulsory… Can you please provide me a fast feedback regarding its possibilities and main features Thanks in advance and regards, You should post these sorts ...Show All