TimLa's Q&A profile

• SQL Server RS/AS relational view design question

  I am about to embark on a POC using RS and AS. The current tool we are using is Cognos, in which I have come to hate. In cognos, we define a folder which is really a view that developers create against several database tables from our data warehouse foundation layer. In turn, our users can create ad-hoc reports against the "folder" without having to know how to join tables (which we don't want ). What is the best way of duplicating this functionality in MS RS and/or AS so that users can only see a compartmentalized view of data broken down into business views, and then then create their adhoc reports. I am not asking which tools t ...Show All

• SQL Server SQL Express hangs on "Setting Registry Security"

  The last few lines of the log show: <Func Name='LaunchFunction'> Function=Write_sqlRegSDDL <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Write_sqlRegSDDL PerfTime Start: Write_sqlRegSDDL : Tue Nov 08 23:13:03 2005 WinXP Pro SP2, just FDISK'd and re-installed my OS today - no leftover RC/CTP bits on the machine.  I'm logged in with my Domain account.  I belong to the local Administrators group and am able to install other software (also installed all of the client tools such as SQL Server Management Studio, etc. Network gl ...Show All

• .NET Development WMI - Monitoring Drive Insertion/Removal

  I have a WMI query that works perfectly for monitoring drive insertion/removals -- but causes constant (and noisy) polling of any Floppy Drives. select * from __InstanceModificationEvent within 3 where TargetInstance.DriveType=3 AND PreviousInstance.DriveType=3 AND TargetInstance ISA 'Win32_LogicalDisk' AND PreviousInstance.FreeSpace <> TargetInstance.FreeSpace The DriveType check stops the event from firing when it's not a fixed drive (like a floppy) but the Polling still occurs.  Suggestions I've seen other monitoring to detect drive insertion/removal and it uses Win32_VolumeChangeEven ...Show All

• SQL Server Triggers

  I understand that triggers is not currently supported in this release, and that Microsoft may be considering supporting them in the future. Will the final release have support for triggers, or will this have to wait until the next major release Thanks Hello Thanks for the detailed information. This is very useful for us to understand the application scenarios and the requirements for stored procedures, triggers and functions. This will be an important input for the SQL Server Everywhere Product Planning. Regards Ambrish ...Show All

• SQL Server lookup to check values in 13 columns with same values

  hi, it is my first post on this forum, please be patient if i miss any important bit of information. i am transporting data from a legacy system into mssql 2k5 using SSIS. among those column of a dataset there are 13 columns, all necessary for operational reasons, that i need to ensure data consistance. i believe i could do this check using the lookup data flow item, but surely there must be a way to do it in a more streamlined fashion. since column names contain numbers to distinguish the version, eg; col01, col02, col03 .. col13. i thought i could include the lookup within a loop and use a couple of variables to do this trick, but since i ...Show All

• Visual Studio 2008 (Pre-release) Message queueing problem with January CTP

  I have problem with message queuing. I wrote simple service and client that communicate through endpoint that works with netMsmqBinding. Exception occurs when client sends message to server, and error is: There was an error sending to the queue: No internal Message Queuing certificate exists for the user. I edited security on msmq, and also tried to create queue in runtime from service, but had no success. This is config of the service. <services> <service type="ATMServer.Console.ATMServer"> <endpoint address="net.msmq://localhost/private/in" binding="netMsmqBinding" ...Show All

• Visual Studio Team System Web services via class library - how to diagram?

  We write a controller class library which our desktop and web UI shares (as they do fairly similar jobs). This controls communication to our web services, saving us having to write the same code for both apps. The problem is, the application diagram tool doesn't support class libraries. So now I've diagrammed my software architecture, what happens when I put this controller class library into my source Is the application diagram smart enough to handle this intermediary class between it and the web services Do all my applications get disconnected on the diagram, breaking the deployment checking functionality Any ideas appreci ...Show All

• Visual Studio Skipped Loading Symbols

  I've been working on an ASP.NET 2.0 project (in debug mode) and I just started getting the "The breakpoint will not currently be hit. No symbols have been loaded for this document" error when I set some breakpoints in my code (in all of my projects and not a particular one) When I run my project and view the "Modules" Window. the "symbols status" for all the items ( mscorlib, system.web.dll, syste.web.xml, etc..) is "Skipped Loading Symbols" when I right click on one of these items and choose "Load Symbols", and click ok on the "find symbols" box, I get this "The symbol fi ...Show All

• Smart Device Development Visual Studio 2005 Beta 2 support for CE Device 4.2 ??

  Is it possible with Visual Studio 2005 Beta 2 to develop for CE Terminals with CE.net 4.2 Greetings Heiko ;-) Is the decision to not support the CF2.0 based on technical reasons We have made planning decisions for the last 6 months based on documentation in Visual Studio 2005, an example of which can be found at the following Microsoft link. http://msdn2.microsoft.com/library/ms172550(en-us,vs.80).aspx ...Show All

• Windows Forms Window Size Changing..

  I have an Outlook Express like MDI application where depending on the bar clicked appropriate child window opens on the right. I have my child windows size fixed at 926 X 675 for a 1024 X 768 Windows Screen Resolution. We have Windows NT and Windows 2000 machines.  The problem that on I am running into is that when I installed the software&nb ...Show All

• Smart Device Development Cleaning up Resources when application crashes

  Hi all, I have an application that makes use of Barcode scanning on a MC50 device. Every now and then the application crashes when the Barcode scanning is enabled. This the device unable to make use of the barcode scanning when I rerun the application. A soft reset resolves my problem - but I don't want me clients to do this all the time. Is there away I can flush out any currently being used resouces/handles etc etc when my application crashes so that I don't have any references left in memory Thanks in advance. Tryst Depends exactly how you are crashing. If a managed exception is unhandled you can always add catch or finally blocks ...Show All

• SQL Server warning- not sure if I need to worry

  Hi, I got the following warning when I tried to run the package which has 1 data flow task with multiple ole db source and destination connections to load the tables. I am not sure what the warning meant and do I need to worry about it. [DTS.Pipeline] Warning: A call to the ProcessInput method for input 3758 on component  unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 1 before the call, and 2 after the call returned. Thanks, Nope. that was the same kind of error that I got for 4 different tables except the component input number was different. I will try to ru ...Show All

• SQL Server FTP No Files Error

  When running FTP Client, and there are no files found on the FTP site and error is thrown.  Is there any way to catch this condition and reset the error so does not bubble up to the parent package I want to catch the event that there are not files on the FTP server to get so that I can set a variable appropriately, but then I want to branch on the condition and return to the parent package and not have the parent package see the error that was thrown. Any suggestions Thanks, Mike You can not catch this specific error condition. You can control the execution result to be success, failure, or completio ...Show All

• Architecture finding design patterns from Model or P.E file

  Hi,        Are there any tools or APIs that take a model (as XMI probably) or a P.E file (so in effect, source code won't be available) and give the design patterns that were used in the model Which classes participate in which patterns and related info It could probably be one of the stages in reverse engineering, isn't       Thank you. I don't think such a tool would be feasable (atleast not in a reasonable way) as many of the patterns differ only in intent. As an example imagine you are writing such a tool and you come accross a structure suc ...Show All

• SQL Server [effeciency] specific result values

  Hi. I had no idea what to name the topic so I hope this is ok. I feel like I am losing it, even though I am still learning SQL Server - I dont use it much in terms of technical/complex queries and so on but I do use SQL on a regular (almost) basis. I am all about making sure it is secure and effecient and performance and so on - just to give a bit of background about myself. Say for instance I have an ASP.NET website, which I have developed a discussion board from scratch using SQL Server to store all the information. Say for instance, we have a topic, and that topic will be "locked". Would I be correct in saying ...Show All