Jeremy_B's Q&A profile

• SQL Server Executing .sql file using SMO

  Hi all, Is it possible to execute a .sql file using SMO. like in old days we used to use osql.exe to execute the sql files Thanks in advance Rujith   Artur laksberg MSFT wrote: Also check out ExecuteNonQuery function: server.ConnectionContext.ExecuteNonQuery(sqlStatements); This function "understands" GO batch separators. You would of course need to load the text from a file to a string. Artur Laksberg SQL Server Team Microsoft That's what we did.  It read the script line by line.  When GO was encountered, it submitted what was accumulated to SQL ...Show All

• .NET Development Help on Deploying application ???

  Dear all, I have build a windows application with VS 2003 and VB.NET Actually I need now to deploy it and for that I am using the integrated setup project template. Works great for simple things For further extension, I need to know at which place the initial installation has been installed. For exemple installtion path could be stored under a registry key. How can I read from the setup project the installation path of a product Thnaks for your help regards serg I think you can use some of the variables available by the installer like [ProgramFilesFolder] [Manufacturer] [ProductName] etc. I think, however, you will not get the flexibil ...Show All

• Visual Studio Team System Detecting unused code across multiple assemblies

  In an older version of FX Cop (a few years ago now), I think there was a public class called Graph. I wrote an app that used this class to detect unused code across multiple assemblies (we have 247 assemblies at present and around 4.5 million lines of code). Is there any current way of performing the same operation with the current version of FX Cop We have an investigative set of re-factoring rules in development here, one check does what you describe. The check requires that you analyze a complete set of binaries which should, taken together, make use of all available public API. This might be a tall orde ...Show All

• Visual C++ Hi friends, nobody is there to guide me for localization of MFC dialog...

  Hi! Can anyone help me out how one should achieve localizaton of MFC dialog application. Regards, I wrote an article in german, but there is a sample code within: http://www.mpdvc.de/artikel/MultilingualeProgramme.htm The idea is to create a new DLL with just a copy of the foreign language resources. With AfxSetResourceHandle you tell the MFC to get all resources from this DLL. Usually I create the EXE with the main language in english. Than I just copy the resource file and translate it. With some tricks you can prevent the RC Editor to add new symbols and share all other resource data. Maybe you need to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. System.NullReferenceException was unhandled

  Hi! In my windowed control, whose rendering is done completely in Direct-x, I provide the means for the user to change the font. For this reason, my object includes the function SetupFont(), which is called at least once on startup to set the default font, and then it may be called whenever the user decides to change the font. The mobjFontDirectX and mobjFontGDI objects are defined at class level: private void SetupFont(System.Drawing.Font objFontGDI) { if (!objFontGDI.Equals(mobjFontGDI)) { if (mobjFontGDI != null) mobjFontGDI.Dispose(); mobjFontGDI = objFontGDI; if (mobjFontDirectX != null) mobjFontDirectX.Dispose() ...Show All

• Visual Basic Upgrade Wizard Error - SSTab

  Hi, I am attempting to upgrade a working VB6 project to VB.Net 2003. I am using multiple forms in the project and a couple of them use the SSTab control. When the Upgrade Wizard attempt to perform the conversion I get the following message... Upgrade failed: Exception occurred: The referenced component SSTab is missing a design time license. I have tried registering the ocx on the system that I have 2003 installed on, copying the ocx to the folder where the source code is and neither has cleared the error message. Any help resolving this will be greatly appreciated. Bruce Hi, Did you ever find a resolution for this I ...Show All

• Visual C# Scrolling Textbox vs 2005

  hi ppl. how can i scroll manually a textbox its a multiline with vertical scroll.. i want to can scroll it to the end of the text when ever i want... i didnt found a method or propertie to do that :s... thx mig16 Hi mig16 NB: If its multiline you do not need to scroll to the end, if you are entering/diplaying a string the textbox will diplay the whole string. if the cursor is at the end of the textbox it will move to the next line automatically. I will prefer to use a Listbox ...Show All

• SQL Server Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Hi there, This looks like a setup issue. Did you have a prior build of SQL/VS 2005 on the machine If so, likely the machine wasn't cleaned up prior to setting up. regards, ash ...Show All

• Visual C++ stringstream causes memory link VC++ 2005?

  This simple program seems to leak LOTS of memory when compiled in VC++ 2005: int _tmain( int argc, _TCHAR* argv[]) { for ( int i = 0; i < 100000; ++i) { ::Sleep(1); std::basic_stringstream<TCHAR> str; str << _T( "Current iteration: " ) << i; } return 0; } CRT: Multi-threaded debug or Multi-threaded I compiled and ran the same piece of code in VC++ 2003 and I don't see ANY leaks! Any ideas   Please help! Thanks in advance It looks like you're right.. From what I traced, the basic_iostream inherits from both basic_ostream and basic_istream - both o ...Show All

• SQL Server String parameters with values of over 1200 characters causes problems

  I have a report which takes a string parameter and everything is fine as long as the users keep their input values under 1200 characters, however somewhere between 1200 and 1600 characters of input makes RS choke and nothing happens. IE just sits there with the globe spinning. I tried running the query which accepts the string parameter as a varchar(8000) and everything is fine which leads me to conclude that something is going on inside RS. I'm running the report from Report Manager. If you're in SQL 2000, you're running into a IE limitation on the length of the URL Access string (it's somewhere around 1600). In 2005, th ...Show All

• .NET Development WSE 3.0 Tracing not working

    Hi! First, I've read the other posts about WSE tracing and none fixed my problem. Tracing just doesn't work. The service is running under an administrator account, just for the kick of getting it to work and still nothing is written to the files. If I create a test file manually from inside the web service, it is created successfully, so the service has the appropriate rights to write to the disk. I have the following nodes in the web.config file (configured with the WSE 3.0 configuration tool) and using VS 2005 Pro. < configSections > < section name = " microsoft.web.services3 " type = " Microsoft.Web.Serv ...Show All

• Windows Forms Sorting CategoryAttributes for PropertyGrids

  This is my first post, and I just want to say that I am so excited that I found this dev forum.  It will come in very handy for development.  Thanks everyone for being a part of it. I wanted to talk about Sorting Categories in property grids.  I have failed to find anything that tells me how to do it.  I have made a properties sorting class, but not category.  I have come across a way to do it.  Pardon my stupidity if everyone already knows this, but for the new devs, it will help.   Lets take my example: This is property grid data to be shown in a windows form property grid. I'm not going to go into the wi ...Show All

• Visual C# Accessing an Array using Propery

  Hi, I am using properties for Setting and Getting data values, such as, public string ModuleExists{ get{ return moduleExists; } set{ moduleExists = value; } }//end public string ModuleExists How would one use the above concept if the moduleExists is an array of values Thanks Jeff public string[] ModuleExists { get { return moduleExists; } set { moduleExists = value; } // remember this lets them set a whole new array. If this is not desired then remove it } ModuleExists[5] = "some new value"; Your question wasn't very clear so I just posted some pote ...Show All

• Visual C# Unloading an Assembly

  Hello, I read in one of the Blogs that an Assembly cannot be unloaded. It has to be loaded into a AppDomain and then unloaded. I have tried that. Take a look at the following code. AppDomain newDomain = AppDomain.CreateDomain("NewDomain"); Assembly myAssembly = newDomain.Load(AssemblyName.GetAssemblyName(assemblyPath); After doing Reflection on myAssembly, I used AppDomain.Unload(newDomain); There are a some other statements in the CurrentDomain. While executing, Iam getting the following exception: 'System.Runtime.Seri ...Show All

• Visual FoxPro Select Statement

  Basically i want to create a view that calculate the stock end balance using moving average. On entry invoice the prg would create txn on a table item_txns that store all txns that affects the balance. The problem is the sale txns only store the qty but does not store the cost of good sold. This would be calculated on the fly when users query and want to see the cost of good sold . I want to do this using SELECT statement, The fields are common for stock txns date       itemid         txn_type          qty   ...Show All