Summoner's Q&A profile
SQL Server Dates problem in SQL Server Everywhere edition.
I have created a sample Database for the school project, After executing the query below, the Date column is supposed to have the dates I have entered before, However the dates shown are 1900. Any idea why is this happening I appreciate your help. Thank you. Query: Drop table AccountReceivable GO --BEGIN TRANSACTION Create table AccountReceivable ( AccountRecID int identity ( 1 , 1 ) not null, PatientID int not null, PresentCharges int default 0 not null, PaymentMade money default 0 not null, PreviousBalance money default 0 not null, BalanceDue money default 0 not null, LastPaymentDate datetime not null, PresentDate datetime default ...Show All
SQL Server Estimation of Full Backup size
Has anyone come across a more accurate method than sp_spaceused to estimate the size of a full database backup for SQL Server 2000 I have found this to have too great a variance (even after running updateusage) to rely on any accuracy for it. I have also looked at perhaps using the ALLOCATED Pages indicated in the GAM pages but this also seems to be pretty inaccurate. I have a number of servers where space can be limited and backups using Maintenance Plans have occasionally failed because they delete the old backups AFTER they do the latest one. I am writing a script which can check the space remaining and adjust the backup accordingly but the variance I have observed so far with sp_spaceused is too great. Any ideas welcomed. ...Show All
Visual C++ socket data
I need your help converting a win32 c socket app into c++/cli. I must create the client. The server must receive constant length strings in order t process this data. I dont have the server source. the c client source (that is created by another person and works fine ) is : #define MAX_PATH 260 #define PR_NAME_LEN 256 #define VERSION_LEN 16 #define DEV_NAME_LEN 16 char msg[MAX_PATH]; char * prName= "name" ; memset(msg, 0, MAX_PATH); strcpy(msg, prName ); send(printSock, msg, PR_NAME_LEN, 0) ; . . . memset(msg, 0, MAX_PATH); strcpy(msg, verName ); send(printSock, msg, VERSION_LEN, 0) ; My c++/cli program is: #define MAX_PATH 260 #define PR ...Show All
SQL Server Disaster Recovery Plan example
Hi, Can any one please share the sample disaster recovery plan. I dont know what I have to include in it and how to prepare it. Your help will be highly appreciated. Thanks in advance... http://www.sql-server-performance.com/disaster_recover_examples.asp http://www.e-janco.com/drp.htm gclid=CP3Hmtzk74cCFRNlYQod5wY-hA http://databases.about.com/od/sqlserver/a/disaster.htm ...Show All
Windows Search Technologies Syntax for searching filenames only
I would like to use Windows Desktop Search 3 (Vista SDK) to search only for filenames (ie. give me all files with names containing "bob" in folder "c:\temp"). Although I know how to restrict the search to a specific folder I don't know how to create a query that does _not_ take the file contents into account. - Oliver Hi - Check out the wds help files: Rules for advanced searches Properties for file type: All Try using file: or filename: HTH ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Making Properties editable in the Properties Window
Hello everyone, I created a new GameComponent which has a XNA.Framework.Rectangle as a property. I added one of these objects to my Game instance, but can't edit the Rectangle property (it is grayed out). How can I write a property (or class) in a way that would make it editable in the Property Window One solution I found was to make a number of Int properties that redirect to be member variables of the Rectangle. This is a bit clunky, though. I would like to be able to expand and edit the Rectangle property instead. It is not specifically Rectangle that I am interested in, as I would also like to make classes that I have created be able to be edited as properties as well. Does anyone know how I can do this Are there any tutorials out the ...Show All
.NET Development SortedList
First I made it like this: SortedList^ probcode; probcode= gcnew SortedList; probcode->Add((Object^) 1 ,L "There is a problem" ); probcode->Add((Object^) 2 ,L "Its too hot" ); probcode->Add((Object^) 3 ,L "Its too cold" ); It didn't work (Failed on comparing two items in mscorlib.dll), so I made it like this: SortedList^ probcode; probcode= gcnew SortedList; probcode->Add( "1" ,L "There is a problem" ); probcode->Add( "2" ,L "Its too hot" ); probcode->Add( "3" ,L "Its too cold" ); And it worked. Why I had to correct a typo "ContainsKey((Object^)2))" but it runs fine, as it should. Is this code failing on your system ...Show All
Visual C++ /clr Error
// compile with: /clr #ifdef _MANAGED public ref class A { public: static void foobar(); // error C3280 }; #endif I compile the above in Visual Studio C++ 2005 with /clr and get error C3280. The documentation says if the /clr switch is set, it should compile as managed. error C3280: 'OSAPI::Net::Event::foobar' : a member-function of a managed type cannot be compiled as an unmanaged function So, why is a declaration in a compile unit that is built using managed code see this as compiling an unmanaged function Also, when the documentation says function, does the definition of function include method declarations I would say term "function" includes "member method declarations". ...Show All
Windows Forms Scaling images
Hi to all! I am facing this problem: I need to read an image from disk, display it scaling its dimensions to fit a certain area in my form while keeping its original aspect ratio and finally saving it in a new file with the new dimensions. The first two steps are easy: I can use a graphic object or a picture box control adjusting heigth and width to correctly fit my image; for example, if I get a 1000x500 pixel image and I need to display it in a 500x500 area I can do something like this: Dim img As Image = Image.FromFile("c:\test.jpg") Dim gr As Graphics = Me.CreateGraphics gr.DrawImage(img, 0, 0, 500, 250) Everything works well, but I can't find a way to save in another file the scaled-down image I have obtained: I cannot set h ...Show All
Visual Studio Express Editions Fatal error
I have visual c++ express edition and SDK for windows server 2003 sp1 i have changed the files that the HELP menu 'how do i' told me to change and i tryed to build a program that the HELP menu also gave and i keep getting fatal error C1083: Cannot open include file: 'windows.h': No such file or directory I am lost please help thanks. It seems like your compiler paths have not been setup correctly during installation of the platform SDK. Check on the start menu in the platform SDK folder for the "visual studio registration" entry, and select "Register PSDK directories with visual studio" this should setup the include and lib paths so that visual studio can find the header files. If this does not work, you will have ...Show All
Game Technologies: DirectX, XNA, XACT, etc. mipmapping
Hi, i've loaded some fbx models via the content pipeline with integrated textures. can i tell the loader routine to auto-generate mipmaps when loading textures integrated in fbx models or how can i postgenerate the mipmaps out of the models. sorry for my english ;) thx #pragma It will create all the way down to a 1x1 size. There's very little reason ever to do anything other than that, because the last few mipmap levels occupy almost no memory compared to the full texture and first mip, so once you've paid the cost for the first couple, you might as well do all of them. If you really do need to change this for some reason, you can do that by writing a custom texture processor, and subclassing the ModelProc ...Show All
SharePoint Products and Technologies ListItem Update Failure
Hi I'm trying to create a dynamic list and filling it with items of already created fields... ////Code is something like this guid = web2.Lists.Add( "ViewHistory" , "Desc" , SPListTemplateType .GenericList); SPList combine_List_web2 = web2.Lists.GetList(guid, true ); foreach ( SPListItem item_history in invoiceItems_history) { SPListItem newItem = combine_List_web2.Items.Add(); newItem.Fields.Add( "InvoiceID" , SPFieldType .Text, false ); newItem.Fields.Add( "Status" , SPFieldType .Text, false ); newItem.Fields.Add( "Author" , SPFieldType .Text, false ); newItem.Fields.Add( "Time" , SPFieldType .Text, false ); newItem.Fields.Add( "Text" , SPFieldType .Text, false ); newItem[ "Inv ...Show All
Visual Studio Tools for Office VSTO 2005 not installed, getting Office 2007 - OK?
I have Visual Studio 2005 Standard Edition, Office 2000, and Outlook, FrontPage & InfoPath 2003. When I purchased VSTO 2005 I chose the upgrade edition since I already have a version of VS. Unfortunately, VSTO will not install because "Microsoft Office 2003 with Service Pack 1 (SP1) is not installed on this computer." I'll be upgrading to Office 2007 (Small Business). My question is what steps will I need to take in order to be able to install VSTO 2005 before I can install the SE upgrade. I don't know if the VSTO 2005 installer will be "smart enough" to realize that Office 2007 is an upgrade from 2003. Any help would be appreciated. Thanks a bunch. Success! For those who might be interested, this is ...Show All
Audio and Video Development Validator Stopped Working
The HD DVD Validator recently stopped working could it be because of an upgrade of internet explorer (7.0.5700.6) or do I need to install something again The simulator works fine. Greets! Thanks for the reply, Doesn't work with the / switch either, just removed and reinstalled it but still won't run. Windows gives a warning "HDDVDValidator.exe has encountered a problem and needs to close....". At least the simulator still works, are there other files/programs the validator needs ...Show All
Windows Forms Change "Just Me" to "Everyone"
In VS 2003 Deployment Project, how do I change the Installation Folder to default to everyone instead of just me, or better yet remove this option all together Thanks I have not worked with VS2003, but in VS2005, you just change the property InstallAllUsers of your Setup project to true. And it does the trick you want. It may be the same for VS2005. Regards, Wasif Ehsan. ...Show All
