TobyRickett's Q&A profile

• SQL Server Update Trigger... best solution

  Hi All I have two questions: 1. the below trigger, is it the best way to update a inserted or updated column Create trigger tr_update_acc_status on customer for insert, update as begin update customer set deleted = 1 where account_status = 4 and account_status = 6 end begin update customer set deleted = 0 where account_status = 5 end it works ok but takes a long time to update the deleted column as it scans all records, which takes me on to my next question: 2. is it possible to amend the quiry above to it only updates the record i have added or updated Thanks First of all your q ...Show All

• SQL Server How to check for table existence before dropping it?

  Apologies if this has been answered before, but the "Search" function doesn't seem to be working on these forums the last couple of days. I'd just like to check if a table already exists before dropping it so that I can avoid an error if it doesn't exist. Doing a web search, I've tried along the lines of "If (object_id(sensor_stream) is not null) drop table sensor_stream" and "If exists (select * from sensor_stream) drop table sensor_stream" In both of these cases I get the error: "There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = if ]" Sooooo... what ...Show All

• SQL Server Express Manager download for RTM version of SQLServer Express

  Has MS updated the Express Manager tool for the RTM version of SQLServer Express It's a great tool and not having it causes so much pain (I have to use the command line tools!). Thanks in advance! I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar to this). I'll use the command line tools I guess Thanks anyways! ...Show All

• .NET Development Securing a IIS-Remoting setup?

  Hello... Can anyone point me to some information about securing an remoting host thats running in IIS I would like to know whats the best way to encrypt & sign the information passed between the Host and the client. So far it looks like i need to create some additional message sinks to do so... But is there any place that explains this a little bit futher Hi Hatzi, for a sample of configuring Remoting in IIS, see this page: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconremotingexamplehostinginiis.asp . To get HTTPS going, you’ll have to configure the IIS virtual directory for ...Show All

• Windows Forms Remote Server Is Unreachable - New Install

  I downloaded the install for the source today.  I ran the install.  Verified that the database was created and that the tables had been poplulated.  Also verified the virtual web was created in IIS. Database and client are on the local system. After the solution was rebuilt and the project was executed I am prompted for a username and password. I  ...Show All

• Windows Forms How to : Paging in a C# DataGrid Windows Application ?

  Hi! I want to use a paging DataGrid, in a C# Windows Application, equal to the Asp Net DataGrid. Is that possible   Thanks No, the DataGrid nor the DataGridView support paging.   -mark DataGridView Program Manager Microsoft This post is provided "as-is"   ...Show All

• Visual C++ VS 2005 MSVCR71.dll problem

  Hi endasil! > The strange thing is that the only compiler that has existed on that > computer is visual studio 2005, and i don't have visual c++ 2003. I open > the project with visual studio 2005 and choose rebuild, but it still > complains on msvcr71.dll Maybe you are linking against a 3rd-party LIB which was build with VC7.1 and therefor required the "old" DLL -- Greetings Jochen My blog about Win32 and .NET http://blog.kalmbachnet.de/ The strange thing is that the only compiler that has existed on that computer is visual studio 2005, and i don't have visual c++ 2003. I open ...Show All

• Visual Studio 2008 (Pre-release) wsDualHttpBinding and TimeoutException

  Hello, I am trying to develop an WCF service with enabled duplex communication between client and service. WCF service is hosted under Windows Service. Everything works fine if I use client and service on the same machine. If service is located on the remote machine, no calls pass through for services configured for wsDualHttpBinding. All of them end up with TimeoutException. Client and service machines are in the same domain. For testing purposes I use domain account with administrator rights. Any ideas on how TimeoutException issue could be resolved Thanks in advance. Edmundas. P.S.: service configuration file, client ...Show All

• Visual C++ Directories of 64-bit targets created from 32-bit ones

  Hi, The VS 2005 feature for adding 64-bit targets by coping win32 ones is pretty neat: http://msdn2.microsoft.com/en-us/library/9yb4317s(en-us,vs.80).aspx I've noticed though, that when doing this with projects converted from VC++ 6, in some places the new target uses the same build directory as the target copied, so that, for example the amd64 and the win32 versions can't be built at the same time. I've put an example below. The x64 part does use some new directories, such as:     OutputDirectory="x64\$(ConfigurationName)"     IntermediateDirectory="x64\$(ConfigurationName)" but also there is:    ...Show All

• Visual C++ Where did the quick console go?

  Anyone know where the quick console window went in Visual C++ Express August CTP Jeff House Hi Yaniv,    Thanks a lot for your feedback. You can actually log your suggestion at http://lab.msdn.microsoft.com/productfeedback/  where other interested folks and users can vote and determine the importance of your suggestion. The VC team for sure considers every single suggestion entered there. Thanks in advance for taking the time to log your opinion. Thanks, Ayman Shoukry Program Manager VC++ Team ...Show All

• Windows Forms joining two data DataTables In DataGrid

  I have two data tables  user DataTable: col1= USER_ID  ; col2= USER_NAME order DataTable: col1= ORDER_ID ; col2 = USER_ID ; col3 = PRODUCT_NAME I would like to show the order Datatable in DataGrid with USER_NAME instead of the USER_ID,  how can I do it how can I make the DataGrid show the following fields UserName ; OrderID ; ProductName ...Show All

• Visual Studio 2008 (Pre-release) DataContract scrub with XSLT

  I need to scrub data before allowing it to leave the WCF Service. I will be restricting data based on the role of the person. I was thinking about doing xml transformation on the data before it left the service. Something like: [ ServiceContract ] public interface IMyService { [ OperationContract ] Report Retrieve( Guid reportID ); } public class SpotReport : IMyService { Report Retrieve( Guid reportID ) { Report report = GetReport( reportID ); XPathDocument xml = TransformToXML( report ); MemoryStream xsl = GetXSL( myRole ); ...Show All

• SQL Server Error deploying DataSource (rsAccessDeniedToSecureData)

  Hi! we've installed the June CTP of SQL Server 2005 Standard. If I try to deploy a report project with Visual Studio 2005 Beta 2 I get the follwoing error: The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) The same error occurs if I try to create the datasource directly over the web-frontend. If yet tried to enter the Administrator account in the WebServiceAccount property with no success. What is wrong Thanks in advance... Markus Thanks Ar ...Show All

• Visual Studio Tools for Office Fire event when mail is arrives in sentmail folder

  Hi All Hope you can help I want to be able to access an email that has just been sent. To do this I need to know when an email is added to the sentmail folder. I am using VS2005.NET and VSTO with Outlook 2003. The project is in Visual Basic. I have seen this sort of thing in c# public void OnStartupComplete(ref System.Array custom) { // add the handler to default folder's ItemAddEvent... mapi = outlook.GetNamespace("MAPI"); inbox = mapi.GetDefaultFolder(Outlook.OlDefaultFolders.olF olderInbox); inbox.Items.ItemAdd += new Outlook.ItemsEvents_ItemAddEventHandler(InboxItems _ItemAdd); } but can't seem to convert ...Show All

• Visual Studio Express Editions Splash Screen Delay

  I'm following along in the "Build a Program NOW" tutorial and on page 100 it states that a code snippet is available to set the dealy of a splash screen. I can't find the snippet. More importantly I can't find anything on the msdn site telling how to accomplish this. This seems like an issue that would be VERY common. Why no help Can the screen be made to stay untill a condition is met - for example untill a sub has completed execution and returned a variable Thanks in advance for the help! See if the following thread helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID= ...Show All