Nathan Jones's Q&A profile
SQL Server Scripting Options in Management Studio
How do you change the scripting options in Management studio For example, I want to script the create statement and permissions for a sproc; however, it won't add the permissions - I have to manually add it. The lack of scripting options is a HUGE discrepancy with this tool. The old Enterprise Manager tool did a much better job at this. Am I going to have to use 2 tools Hi, I've only found one way to do thi ...Show All
Visual Basic How to Consume a web service methods
Hi every one, It feels good to be back; thanks for all your proffessional help am very grateful. I pass my first project with all your help. I have this very big problem, it with deploying and consuming a web service. I write a web service and use it method on my windows app and it's work. But when I deploy thesame app to another computer as a client on a netwotk it keep given me an unhandle error that it can't find any refference to the web ser ...Show All
SQL Server bug installing SQL Server 2005 Express Edition with Advanced Services
ENVIRONMENT Windows 2000 Professional (Build 2195: Service Pack 4) Previous version of SQL Server 2005 Express Edition with Advanced Services CTP was removed using Add/Remove Programs Visual Studio 2005 Professional is installed WARNING MESSAGE (should it be an error message since what was requested did not take place ) --------------------------- Microsoft SQL Server 2005 Setup --------------------------- Warning 28123.Warnin ...Show All
.NET Development XSL,XMl, DHTML Tree (TOC) as per MSDN CodeCorner article April 99
Hi Kinda new to all this. But want / need to create a TOC menu (3 levels).I have been using this article (George Young Apr 1999, .. ) DXML: Taking a TOC from XML to DHTML ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/dncodecorn/html/corner042699.htm as an example and start point. but my XML File is slightly different to that in the example, and I am getting nowhere fast (or slowly or at all..!!) I use Topics, Topic and Sub ...Show All
Windows Forms Remoting App over ClickOnce
Hi, I am deploying a small client application, which connects to another remoting machine, using ClickOnce. On my machine I tested it and it worked fine. Then I tested it on a second machine and there also it worked without hitch. But in the third machine the remoting call is throwing up an excpetion as below. Can someone point out the mistake Exception : Found a wrong header field MinorV read = 69, expected = 0. Server stack trace: &nbs ...Show All
Visual C++ Backgroundworker Component
I am using VC++ Beta 2, with Windows Forms. I want to run a process in the background, leaving the UI responsive, and also to update a text box on the UI with interim progress data from my process. I have found a way to initiate a worker thread on the NET - as below. using namespace System; using namespace System::Threading; public ref class ThreadExample { public : static void ThreadProc() { //Do stuf ...Show All
Visual Studio Team System Code coverage - unit testing web service - VSEnterpriseHelper.axd
When running our unit tests for a web service with code coverage enabled the following error is displayed... (with no code coverage generated). Exception was thrown: The web site could not be configured correctly; getting ASP.NET process information failed. Requesting 'http://localhost:22888/AppTier/VSEnterpriseHelper.axd' returned an error: The remote server returned an error: (500) Internal Server Error.. Cannot initialize post instrumentation ...Show All
Visual Studio Lost the Watch window
A few days ago I stupidly closed the Watch window completely, and now I don't know how to open it. I've looked in the View menu and there doesn't appear to be any way to open the Watch window from the View menu, or from any other menu. This makes debugging a pain as you might guess.... Any idea how I can open the Watch window I'm using VS 2005 by the way... Thank you! ntb I should also note th ...Show All
SQL Server Intercept Result
Hi, I am trying to write a system (Stored Proc, View, CLR Proc, ), where if you query a specific table and it returns data from only 1 column for the submitted SELECT statement then substitute data obtained from an external web service. Does anyone have any suggestions about how best to implement this I have searched through the BOL but nothing directly deals with what I want to do. Thanks, Blair P.S. I am using SQL SERVER 2005 E ...Show All
Windows Forms MDI Parent Border Style
Hello, When my Main top-level window is not MDI, all of the different borderstyles can be used. But when it is MDI the border becomes 3D and cannot be changed. I would like to have a main MDI window without 3D borders, like the  ...Show All
SQL Server MSDE Installation
I'd like to know if there is a way to install the MSDE using the Windows installer. I'd like to create a setup realy user-friendly, so besides the msde I need some others programs to install and they also need to reboot the machine. I tryed to use the merge modules, and the msde Toolkit, with not success. Thanks Peter ...Show All
Visual C++ Error: LNK2019
Hi I am using MS VC++ .Net (2003) and MS DirectX 9.0 SDK (December 2004). I am getting the following error :- GDPass error LNK2019: unresolved external symbol "public: void __thiscall bullet::gunshot(void)" ( gunshot@bullet@@QAEXXZ ) referenced in function "long __stdcall WndProc(struct HWND__ *,unsigned int,unsigned int,long)" ( WndProc@@YGJPAUHWND__@@IIJ@Z ) "gunshot()" is a function which is declared in a header file, as a public funct ...Show All
SQL Server Issue with Export to CSV
Dear Anyone, Whenever we export reports to CSV, it seems that the column headers in the CSV fileb are the actual column names in the select statement we used in the data set and not the column names that are in the report. Is there a way to reflect the column names in the report to the CSV file rather than the actual physical column name in the report Thanks, Joseph As there is no explicit binding in RDL between the data columns and the he ...Show All
SQL Server Restoring to a network paths?
I'm getting the error "The file \\xxx ... is on a network path that is not supported for database files. File xx cannot be restored to \\xx ..... Use WITH MOVE to identify a valid location for the file. Below is my code for the restore. I've even shared the folder on the network but still no success. Try Dim restoreToServer As New Server("xxxx") Dim rest As New Restore rest.Devices.AddDevice(" \\xx\x$\Pro ...Show All
Smart Device Development Control Focus Problem - a Bug? or..
Hi, i would like to create a simple control that changes its background color depending upon whether it is focused or not. i have the following code. class mylabel : Control { protected override void OnGotFocus( EventArgs e) { base .OnGotFocus(e); this .BackColor = Color .Red; } protected override void OnLostFocus( EventArgs e) { base .OnLostFocus(e); this .BackColor = Color .White; } } The pro ...Show All
