dan english's Q&A profile

• SQL Server Scripting an SQL 2000 Maintenance Plan

  I am running two "identical" SQL server installations on two separate boxes. One is the Live system, the second a standby backup. I would like to export the Database Maintenance Plans from the Live server so I can create identical backup copies on the standby. Unfortunately, there does not appear to be any way of scripting the Database Maintenance Plans from the Enterprise Manager. Does any know of any tools or have any scripts to script these plans. Thanks ...Show All

• Smart Device Development Problem in calling DllGetClassObject in main class of Smart phone

  IS there any difference in calling DllGetClassObject method in smartphone then pocket pc. I have a application in which pocket pc version call DllGetClassObject while smartphone doesn't I edited calling card sample in sdk.When I run this application DllGetClassObject get called in both version. What could be the problem ...Show All

• Visual C++ transition from C++ MSFlexGrid

  I have an existing C++ application that uses an MSFlexGrid in one dialog. I am moving the application to VS2005 so it may be compiled for 64 bit architectures. Everything besides that one dialog is finished. Is the DataGridView the best path to follow moving forward What other options are there How do you use the DataGridView in a C++ program Is there some way to get compiler generated C++ files as there was with MSFlexGrid I did not write the original application, nor am I particularly proficient with Windows or Visual Studio. Any help is appreciated, and please state the obvious. There is a walkthrough for creating a Windows Forms Control in Visual C++ in the Guided Tour area that did not work. It mentions the possibili ...Show All

• SQL Server limit rows for a user

  Is it possible to set a limit for the number of rows to the user that connects to sql server (something like: whatever is the query this user does, set @@rowcount to 10000) Thanks. Alberto Hi, thanks for your response, but the problem it's this: our users using report builder are making reports containing several Mb of data (sometimes also 1Gb!). Now it happens that when 3-4 users do a report like that on the server the process w3wp.exe reaches also 10 Gb of memory allocated and then the whole reporting services istance stops working. We want to limit the number of rows that can be extracted from the sql server db using report builder. We cannot "touch" the way reporting services builds the q ...Show All

• SQL Server Problems with neural net viewer, lift chart and predictions still ocurring in SP2

  Greetings, I have a mining structure that I am using to perform a text-mining classification task. The mining structure contains three models: a decision tree, a naive bayes and a neural network. Both the decision tree and the naive bayes models process without any problems, but I am having significant difficulties with the neural network model. Initially when I processed the model, processing would fail altogether with the following error message: "Memory error: Allocation failure : Not enough storage is available to process this command" This was remedied by taking the steps prescribed in http://support.microsoft.com/kb/917885 (I upgraded to SQL 2005 SP1 and applied all available hotfixes listed in http://s ...Show All

• Software Development for Windows Vista Can WWF can run with Framework 2.0 ?

  My company's developping project using Visual Studio 2005 Professional (DotNET framework 2.0). My work's using WWF. Can I use WWF with this version of Framework How to install and use And if the answer is "Can't" and I have to install DotNET framework 3.0 and Visual Studio 2005 Extensions for Windows Workflow Foundation. May my project can work well with the others using framework 2.0. My project just is a part of my company's project. Please help me ! Tom Lake - MSFT wrote: The video was created on 9/14/05 based on Beta 1. There have been many changes since then, to include those you have mentioned. Ok, I see. But How to take Parameters item and others on Properties. ...Show All

• Visual Studio Express Editions Link Resource Image to PictureBox

  I have several pictures in the Resources File of my application, and have made several forms. What I would like to do is autogenerate a thumbnail on a button for each image, and when someone clicks on the thumbnail I would like it to open Form2 and fill the PictureBox with the appropriate image from the Resources File. I cannot figure out how to do this though, and so would appreciate any help that anyone can give me. 1) I would like my application to create a thumbnail of the appropriate JPG Image. 2) When someone clicks on the button / thumbnail I would like to open Form2 and fill the PictureBox with the appropriate image. I am able to open the form, but I cannot seem to open the image. 3) I would also like to know how to arrange it so t ...Show All

• Visual Basic Languages that are supported by Speech API ?

  Hello, I can easily get the computer to read text in english in a textfield /// can it read text in other languages as well i tried but it did't do anything Just from the download http://www.microsoft.com/downloads/details.aspx FamilyId=5E86EC97-40A7-453F-B0EE-6583171B4530&displaylang=en#RelatedLinks http://www.microsoft.com/speech/download/old/sapi5.asp It would look like languages other than english are supported. Since this is a SAPI question, I think you can get a better answer from this news group: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx dg=microsoft.public.speech_tech&cat=en_US_adb1a4c1-4dfb-4d53-9962-8dbad91aee8d&lang=en&cr=US . ...Show All

• Smart Device Development BYTE and WCHAR types

  Hi! My code reads data from file on pocket pc emlator into the &buffer variable. If buffer type is set as BYTE buffer[1000] everything works ok, but if as TCHAR buffer then I get nothing filled in to the buffer from file, exept some strange symbol. I need &buffer to be TCHAR type, is there any way to convert it from BYTE or why is it nor working for me I did save file as unicode, and as ansi, it is all the same. However there are functions wctob and btowc, that you can use for conversion. Refer to http://msdn2.microsoft.com/en-us/library/634ca0c2(vs.80).aspx I hope it helps. ...Show All

• SQL Server MSFTESQL blocking itself

  I am populating a catalog (which is taking longer than on 2000) and when I look at the processes what is see is strange... MSFTESQL has many spids and each spid appears to have 4 connections. Of each set of 4 3 are blocked by 1... This seems odd to me. Also the CPU is at 90%-100% but it is not the MSFTESQL service. It is the SQL server hogging it all. I have looked but can't find anything. I found information on it MSFTESQL is talking all the CPU but that won't help me. SQL 2005 is the only thing on this server (win 2003)... It only had 3.5 gb of ram but it is just testing ground for our app... Any guidence in what to look at or alter would be great... Added a request as a bug. https://conn ...Show All

• Windows Forms Gradient BackColor

  Gradient BackColor. I would like to make a gradient backcolor for controls, like a treeView control, for example... it's posible I tried to override the Paint function. I used a LinearGradientBrush and then draw a fill rectangle, and looks good... but i overlaped the original paint. Suggestions/comments/tips all are wellcome. Thanks Controls like ListBox and TreeView do their own painting and don't generate the OnPaintBackground event. They also don't implement the BackgroundImage property, for the very same reason. Sorry, I think you're stuck with a boring old plain background... ...Show All

• SQL Server error with scale-out web server: Invalid object name

  We are adding a second web server to our farm. Reporting Services is installed on one web server as Rpt01 instance and works just fine. We have installed the second web server also with an instance named Rpt01 and are now trying to configure to re-use the same database as the first server. When we restart services we get the error listed below. I was wondering if there was an issue with the same named instances on two different web servers accessing the same ReportServer01 database This is the error that we are getting. Any help would be appreciated. The curious thing is that our databases are named ReportServer01 and ReportServer01TempDB and not the name listed below. ReportingServicesService!schedule!4!1/23/2007-15:40:20:: Unhandle ...Show All

• SQL Server Text file Destination

  Hi, I am new to SQL Server. My company uses SQL Server 2000. I am trying to migrate a PC SAS program to a DTS package but cannot get the results I need. I need a fixed format comma delimited file from a DB2 database. The DTS package wants to make the financial fields 19 bytes long; however the fields were 12 bytes from SAS and I have to match the output I got from SAS exactly or the client will not accept. I tried to cast as decimal(7,2) but the DTS package still wants the financial fields to be 19 bytes. I tried casting as character, but then the decimal is floating in the 12 bytes. Is it possible to place the decimal in the third byte from the right in the destination field If yes, please tell me how. Thank you. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Z-Order in XNA

  Hello, I was wondering if there is any information on Z-Order in drawing sprites to the screen. I basically need a good way to draw a game with layared sprites. Thanks Here's a relevant article I think and the Help page for the DrawableGameComponent's DrawOrder property. ...Show All

• Visual C# Problem with adding encrypt code

  Hi, I need to add an encrypt code and just having problem doing it right. Can I someone help me using System; using System.Collections.Generic; using System.Text; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { bool quit = false; while (!quit) { ShowMenu(); ConsoleKeyInfo key = Console.ReadKey(); switch (key.Key) { case ConsoleKey.E: Console.ReadLine(); Console.Write("Enter a String to encrypt: "); string plaintext = Console.ReadLine(); break; case ConsoleKey.D: Console.ReadLine(); Console.Write("Enter a String to decrypt: "); string plaintext = Console.ReadLine(); break; case ConsoleKey.Q: qu ...Show All