akaRickShaw's Q&A profile

• SQL Server Creating Backup Jobs in SQL Server 2005

  How to creating Backup Jobs in SQL Server 2005, thanks Management > Maintenance Plans > Right-click > New Maintenance Plan.  Then you drag a Backup Database task from your Toolbox and do anything else you want as part of your backup process (Check Database Integrity, History Cleanup, Maintenance Cleanup, etc.) This link provides more info as well as the graphics (I can't copy-paste the screenshots) ...Show All

• Visual Studio 2008 (Pre-release) ClipProperty on trigger

  I have a button. And I use the clip property to cut it . I want to render whole shape if mouse over it. So i attach it with a trigger But it doesnot effect why These are my code: button1.Clip = new RectangleGeometry(new Rect(0, 0, button1.Width/2, button1.Height)); Style mystyle = new Style(typeof(Button)); Trigger t = new Trigger(); t.Property = Button.IsMouseOverProperty; t.Value = true; t.Setters.Add(new Setter(Button.ClipProperty, new RectangleGeometry(new Rect(0, 0, 100, 30)))); mystyle.Triggers.Add(t); button1.Style = mystyle; If I understand you correctly, you want to resize the button to the new 0,0,100,30 size whenever the mouse is over. The following code in xaml works per ...Show All

• .NET Development Generating sql query using C# code

  How do i generate sql query using my frontend windows application C# 2005. ie developer has to select table and columns from the list box. it should look like our add query in the sql express 2005. Thanks Arun Hi, I guess you'll have to manually create your own sql query string. Unless you are willing to use 3rd party software that automatically generates sql statements. Although these query generator has its own UI. cheers, Paul June A. Domag ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. About 3D moudle

  now, help me !! why my demos can not show mesh!! Found your problem :) The main problem is this line: effect.World = MyWorldRotation * mesh.ParentBone.Transform * Matrix.CreateTranslation(Position); The Matrix "MyWorldRotation" is never initialized in your code, so it's all zeroes. So effect.World is a zero matrix meaning nothing will show up at all...ever :) So I removed it and the line now is: effect.World = mesh.ParentBone.Transform * Matrix.CreateTranslation(Position); You still won't see anything though ;) The model is there, just that your camera is not far out enough to see it. Your camera is actually INSIDE the model at this point, so you can't see it. So you need to e ...Show All

• Visual Studio Team System Setting default WorkItem field values during creation of New Team Project

  Hi, I've created a creation wizard that will gather information from the user when they create a new team project. I'd like to be able to set some fields of work items when they are created to the values that were entered in the wizard during project creationg. For example, during the wizard a user will enter the project category along with name. Each bug entered will also have the project category saved in a field that is also a dimension. I don't want the user to have to enter the project category when entering bugs. Is there any way to get the information from the wizard back into the Team Project XML Or some way to change the Process template tasks lists during project creation to have the custom field default to a certain va ...Show All

• Visual Studio Express Editions how to: bind a single control to multiple datasources

  hi, im really new to programming and i was wondering if there's someone out there who's kind enough to teach me how to bind a single control (ex. a textbox) to multiple datasource's (ex. two or more table's). thanks a lot.. sorry, i know this is out of this thread, but i posted another question as to how to dynamically update the changes of items stored on 2 combobox controls, both controls are filled by items thru a tableadapter at teh forms load event procedure. items on both controls are constantly changing and there is absolutely no way i can update these changes manually, the scenario is like this: whenever an item is selected in combobox1, items on combobox2 have to be filled accordingly to the se ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you implement Fog into a scene?

  Hi All, I have finally got some 3D up and running so things are whizzing about (which is always fun to watch... for a while, yeah I know, small things...) and I was wondering if anyone had any examples of putting fog into a scene. I tried last night and succeeded in turning all my meshes to white, not matter how far away they were from the camera. No matter what I did to the values, nothing changed. As always, any help is greatly appreciated. Cheers vidalsasoon wrote: Vectors that range from 0,0,0 to 1,1,1 are called "Normalized" vectors. They're a good thing. The guys at XNA are thinking beyond hard coding for 0-255 (or 0-65535). I.e. 0 is always the minimum and 1 is always the maximum. I get the V ...Show All

• SQL Server Date format with SQL Server 2000

  Hi, I'm working with a table with more than 2 million rows. The problem is that the table has a field called "ShipDate" of type nvarchar. When I try to change the data type to DateTime sql server throws a data conversion error. I noticed that the date format is as follow: 2006-10-23, so, is there a way sql server takes this field and change it using the field values and applying the correct format meaning: 10/23/2006 thanks a lot The mentioned value should be easily converted into a datetime column (2006-10-23). You seem to have corrupt data stored in the datecolumn. Try to get rid of it and prior identify it by using the following query: SELECT Datecolumn FROM SomeTable WHERE ISDATE(Da ...Show All

• SQL Server Insert into table on Linked server

  Insert statement to remote server is running very slowly. I have run Profiler and find there is a 'sp_cursor' call for each row. The source system is SQL2005 and destination is SQL2000(sp4). The linked server is using 'SQL server' type connection. Source query is against a single table with a where clause. source and destination table are identical with Primary keys. Purpose is just to move the rows. Connection is a slow network connection - should be ok. I have already overcome same problem for related update and delete queries by use of 'EXECUTE (query) AT LinkedServer' that works great - but insert can not take advantage of this... INSERT [LinkedServSQL2000sp4].dbname.schema.tablename ({column list}) Select  {column list} from t ...Show All

• Windows Forms Single click acting as double click in form designer

  For some reason, when I'm editing a property of a control in Design View and then single-click back on the form designer, the IDE acts as if I double-clicked, and goes to the code for the Form.Load event-handler, for example. Has anyone else experienced this Is there a setting that I changed somewhere that fixes this, or is it a bug Thanks for your help. -Mike I found a bug submission regarding this problem @ Connect: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=234223 It was submitted in Nov 06, with no comments from MSFT... Also, another bug report: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=121703 This was is ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where does Directx 9L fit in?

  Uptil now I was under the belief that DX 9L was the DX9 version of Vista. That means vista had DX10 and this 9L (Legacy ) together. So games that could use DX10 used that and other stuff defaulted back to the old DX architecture.  Now today I read on the Inquirer (rumor central) that DX 9L is basically DX10 for XP...that is DX9c in XP will be replaced by that.  Can someone clear out what is the position of DX9L in the world of DX10 and DX9c and what OS is it meant for..Thanks they achknowledged they were worng http://www.theinquirer.net/default.aspx article=35140 ...Show All

• Software Development for Windows Vista WCF and Cardspace sample without IIS?

  Hi, I would like to try out CardSpace as an authentication for my self-hosted WCF service. However, all the samples that I find require IIS. Is there any samples/tutorial for me to get started with CardSpace that focuses on self-host WCF service Thanks Hello YewMing, this sample demonstrates the capabilities you want. HTH, Vittorio ...Show All

• SQL Server Cannot install SQL Server Express

  My system had a beta version of Visual Studio 2005 Express on it which I uninstalled. Apparently not correctly, as I can not install SQL Server 2005 Express. I have tried to removal procedures which either give me an error message or I cannot find the items in the Add/Remove program list that are requested. That is, it looks like the system should accept SQL Server 2005 Express, but it does not. I have successfully installed Visual C++ 2005 Express. I have no clue as to what to do next and there is no documentation on what to do. I have looked at the various postings here, tried several of them, to no avail. When I search the registry there are some 70 entries that have the string “SQLEXPRESS” in the entry. I am u ...Show All

• SQL Server Ratio determined from another dimension?

  Can it be done and is it a normal practice to calculate a ratio based on another dimension’s hierarchy I have a portfolio hierarchy/dimension which from a business perspective is used in many calculations. Other dimensions such as “Rating”, “Issuer”, and many risk characteristics are compared to it (i.e. % of “A” rated bonds in a given portfolio). In my calculated field I am planning to take the market value of the “A” rated bonds and divide it by the Market Value of the portfolio even though “Portfolio” and “Rating” are different dimensions. I am trying to make sure that I am going down the right path. Many examples just show ratios based on a different level in the same hierarchy. ...Show All

• .NET Development Accessing a Web Service over a LAN

  Hi all, I need to set up a web server for a game environment over LAN where the webserver will store a list of available games. A client will be able to choose a game from the list and connect to the game directly using sockets (bypassing the webserver). i.e all the webserver is doing is informing the client side app which computers it can connect to. I've written a test web service stored on my hard drive (also in IIS) which i can access locally from my machine (http ://localhost/Test/Service.asmx). I've added my serverInterface (wsdl.exe) to the webservice class and also my proxy class for my client and all works perfectly. My problem now is how can I publish this web service over the LAN so that i can acce ...Show All