The Code Monkey's Q&A profile

• Visual Studio Team System Restrict Access to databases other than through TFS

  Hi, I am faced with a critical problem. We want to ensure that all the changes made to databases by developers are source controlled. Source control can be achieved by using TFS with VS DBPro. But users can use the same authentication (as they would know the userid and passwords) to make modifications in an offline DBPro project or through enterprise manager as well. Is there any way (by means of events raised in TFS etc) by which we can ensure that all database changes are through TFS, so that they can be tracked and source controlled We cannot totally restrict access of developers. They need to have ddl_admin rights on database objects in Development servers. Kindly give some suggestions as to how to solve this problem. Th ...Show All

• SQL Server Can I install MS SQL 2005 Dev on win 2003 web

  Hello to everyone again to get info and support I relay on forums..... I buy Visual studio 2005 professional there is included MS SQL 2005 developer edition I buy Brand new DELL PC ($4750) with Windows server 2003 web edition I can not install MS SQL 2005 developer edition my curently cost to buy all these MS products was $1080CAD + $350CAD for win 2003 I didn't find normal to have no telephone suport and no version capability I am really mad!!!! please if there is step-by-step guide how to install MS SQL 2005 on win 2003 web please let me know mail@bluelabs.ca Thank you in advance Valentin Petkov " But I still wondering about Do Microsoft work over that to can some vers ...Show All

• Visual Basic Send Keystrokes on the Server

  I’m new to Visual Studio, I developed an application using Visual Studio 2005 (Visual Basic.NET) I embedded some flash files in my application and these flash files are refreshed and updated from an independent software(there is no .NET or COM references of this software to add to my project) so I built an update procedure using some keystrokes in my code to update and refresh the flash files. The application is sitting on the web server. To execute my procedure I need to login remotely to the server and execute it. I wrote another code for a timer so the timer will fire the procedure at a specific time to update the flash files The problem is that when I am not logged in to the server I can’t send keystrokes in ...Show All

• Software Development for Windows Vista Screen capture win32 api can be blocked

  Can we block the win32 API screen capture in any programming language i.e "gdi32.dll" provide the facility to capture the screen. i want ot disable the screen capture by any tool. saqib This forum is for questions about Window Workflow Foundation, not win32 apis or gdi32.dll. Try going here to find a better forum to ask your question. ...Show All

• .NET Development IoC containers

  Where can I find more information about IoC with .NET   Recon wrote: Where can I find more information about IoC with .NET http://www.google.com/search hl=en&lr=&rls=GGLJ%2CGGLJ%3A2006-15%2CGGLJ%3Aen&q=%22inversion+of+control%22+.NET ...Show All

• Visual C# Attenuating SoundPlayer Volume

  I use SoundPlayer to punctuate long file downloads and other processes and give me sound cues of the app state in broad sense. One problem I have now is that the volume is so loud that after a long pause it might frighten me a bit with some sounds. Manually adjusting volume in SoundPlayer 10 does not seem to help. I cannot get a hang of it although I tried numerous inroads. SendKeys.Send ( "VolumeDown" ); did not work. I tried to exploit Volume.exe: Set Volume Control Levels Using Visual Basic at http://support.microsoft.com/default.aspx scid=KB%3bEN-US%3bQ178456&%5d and another related sites to no avail so far. It may all boil down to controlling volume in MS kernel sound mixer or something, I do not know. Please, h ...Show All

• SQL Server Performance issue in MDX query

  Hi All, I have the following MDX query which takes around 3 minutes to execute in spite of my fact table containing only around 800 rows. The dim classification no hierarchy dimension contains around 10,000 members. with Set [Time1] AS {[Dim Time].[FullDateAlternateKey].&[2003-07-01T00:00:00]:[Dim Time].[FullDateAlternateKey].&[2004-07-01T00:00:00]} member [Incident Count] as 'Sum ( { [Time1] },[Measures].[Estimated Incident Count]) ' member [DTS] as 'Sum ( { [Time1] },[Measures].[Days To Solution]) ' SELECT NON EMPTY CROSSJOIN ( AddCalculatedMembers ({[Dim Project].[Dim Project].[ALL]. CHILDREN }), {[Incident Count], [DTS]}) ON COLUMNS , NON EMPTY TOPCOUNT ( AddCalculatedMe ...Show All

• SQL Server SQL Task - passing parameters

  Hello, I have a SQL task wich executes the following statement on a OLEDB connection (SQL 2005 DB): TRUNCATE TABLE DimTime GO DECLARE @CurrentDate AS Datetime DECLARE @EndDate AS Datetime SET @CurrentDate = '10-20-2003'; SET @EndDate = '10-20-2005'; while(@CurrentDate < @EndDate) begin INSERT INTO DimTime SELECT DATEPART(month, @CurrentDate) AS MonthNumberOfYear ,DATEPART(quarter, @CurrentDate) AS CalendarQuarter ,DATEPART(year, @CurrentDate) AS CalendarYear ,dbo.GetSemester(DATEPART(month, @CurrentDate)) as CalendarSemester ,DATEPART(quarter, @CurrentDate) AS FiscalQuarter ,DATEPART(year, @CurrentDate) AS FiscalYear ,dbo.GetSemester(DATEPART(month, @CurrentDate)) AS FiscalSelester set @CurrentDate = dateadd(month, ...Show All

• Visual Studio 2008 (Pre-release) Loading behaviors

  Is there a way to set the behaviorConfiguration for a ServiceHost (or Client for that matter) in code All examples that I've seen show it being set in app.config. I need the ability to define the behavior in the app.config, but then create the ServiceHost and endpoint objects entirely in code, passing to them the name of the config entry to use. I do something similar now for the bindings. I define the binding configurations in the app.config, but when I create the binding in code (for example wsHttpBinding), I use the overloaded constructor that allows me to pass in the string name of the entry in the app.config. I'd like to do the same thing for services and clients. Any ideas. Thanks. Bruce Bukovics Author of .NET 2.0 Interoperability ...Show All

• Visual Studio 2008 (Pre-release) Extracting DataTable from query expression

  Hello, I would like to be able to "extract" the DataTable used in a query expression. Sepose I have the following code var query = from c in Customers select c; I would like to "walk" the query expression and to receive Customers as base table in that query. If I have the following query: var query = from c in Customers join o in Orders on c.ID equals o.CustID select new { c, o } I would like to receive Customers and Orders as base tables in that query. Is it possible Dear Matt, What do you mean by "at least not yet" :) Are there plans to change Linq over DataSet to return IQueryable Any way, isn't there an al ...Show All

• Visual Studio Team System Error when trying to generate Unit tests.

  I have previously been able to generate unit tests from the IDE but now I recieve an error: The source code cannot be sufficiently parsed for Code Generation. Please try to compile your project and fix any issues. I've recompiled, cleaned, etc the projects in the solution all the ways I can think of and I still recieve this error Anyone have any ideas Hi, What kind of project is it and what language are you using Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• SQL Server qyering data from two databases on different servers

  Hello- I am trying to write a report that combines data from two different databases on two different servers. Wherther I run the query in SQL Server 2005 management studio or reporting services, I get the same error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'. There is an error in the query. Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'. I have written queries that access two different databases on the same server and they work just fine, so I am guessing that I am not providing enough of a fully qualified path to the second server. We have not implemented linked server. Any ideas on how to properly identify the second server/database/object would be appr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Unable to load p1_wedge following first Starter Kit tutorial

  Hello all, My first post. I've done a search for this problem online with no joy, so thought I'd post here in the thick of it. I have this exception when trying to build and run the tutorial: {"Error loading \"\\Content\\Models\\p1_wedge\". File not found."} With this as an Inner Exception: {"Could not find a part of the path 'D:\\Content\\Models\\p1_wedge.xnb'."} The p1_wedge.fbx is in the correct directory, and all my code is copied correctly from the tutorial. Can anyone tell me what's up - I had a problem with mscoree.dll a few days ago, and didn't really know what I was doing trying to recover it... (I'm no Windows programmer - I'm an ActionScript guy by trade...) Thanks in advance! pseudo Heh, n ...Show All

• Visual Studio Tools for Office Protected sheet gives exception with Databound Listobject

  Hi there, hope someone can help. I have a Workbook that needs protected so the user cannot edit etc. However, I have a ListObject that is bound to an object array as so Customers customers = new Customer [3]; customers[0] = new Customer ( "Mr A" , "A Street" , "111" ); customers[1] = new Customer ( "Ms B" , "B Street" , "222" ); customers[2] = new Customer ( "Miss C" , "C Street" , "333" ); Globals .Sheet1.customerBindingSource.DataSource = customers; Globals .Sheet1.list1.RefreshDataRows(); However, if I save the workbook and reopen I get an exception. I presume this is because upon initialisation the array ...Show All

• SQL Server How to use TSQL to monitor replication status

  To monitor the status of replication in SQL 2000 we insert the resuts of sp_MShelp_replication_status into a temp table and review the status. In SQL 2005 this stored procedure has changed and now does it's own insert into execute command. Since insert execute commands can not be nested we must find another way to programically monitor replication using TSQL. We could call s ys.sp_replmonitorhelppublisherhelper but we can't seem to find it in the distribution database. It must be hidden somehow. Any ideas Thanks, Danny Look at topics: How to: Programmatically Monitor Replication (Replication Transact-SQL Programming): http://msdn2.microsoft.com/zh-cn/library/ms147874.aspx How to: Programmatically Monitor Replication ...Show All