Team Development Issue When Debugging Applications
Feb 19, 2007
Hi,
At the moment I am working on an asp.net 2.0 application where we use sql server 2005 as database server. We are building this web application with 5 developers in paralel and we noticed that when one developer is debugging the application (hanging in a breakpoint), other developers get a sql time-out exception.
Yes we are using Transactions (System.Transactions namespace) but we have totally no idea why this side-effect is occuring.
In the past I wrote DTS transforms entirely by myself. With SSIS, our team of several developers now wants each member to develop a piece of the same package.
Do SSIS packages support this type of simultaneous multi-developer creation or is it a "one developer at a time" type product?
I am developing a native C++ application using SQLCE (.NET is not a current option). Am having a problem while using multiple accessors for multiple blobs in a table. After I read the data for the first blob & try to read the data for the second one, I get an error in one of the dlls (something about using heap data that was freed). Where can I get symbol data so that I can use something like Windbg to resolve my problem.
Team members appear twice or more if they belong to more than one team. I need to be able to show their name and main team. Team is not important at the moment but I just like to include all team members and display a team name against them.This is what I have at the moment:
SELECT SystemUser.systemuserid, FullName, TeamMembership.TeamID, TeamName FROM Team RIGHT OUTER JOIN TeamMembership ON Team.teamid = TeamMembership.teamid LEFT OUTER JOIN SystemUser ON TeamMembership.systemuserid = SystemUser.systemuserid order by FullName
I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above.
Am I missing something here? Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging?
Can I automate the process with MSBuild or NAnt? If so, is there an example of this anywhere?
Is it possible to group by "Team" in the following SQL Datasource? Each row has a numbers in their respective columns and need to be added up and only one row per team is shown showing the total? SELECT HomeTeam AS Team, 1 AS Pld, CASE WHEN HomeScore > AwayScore THEN 1 ELSE 0 END AS Won, CASE WHEN HomeScore = AwayScore THEN 1 ELSE 0 END AS Draw, CASE WHEN HomeScore < AwayScore THEN 1 ELSE 0 END AS Lost, HomeScore AS Scored, AwayScore AS Against, HomeScore - AwayScore AS Agg, CASE WHEN HomeScore > AwayScore THEN 3 WHEN HomeScore = AwayScore THEN 1 ELSE 0 END AS Pts FROM tblFixtures WHERE (CompID = 1) AND (HomeScore IS NOT NULL) UNION ALL SELECT AwayTeam AS Team, 1 AS Pld, CASE WHEN HomeScore < AwayScore THEN 1 ELSE 0 END AS Won, CASE WHEN HomeScore = AwayScore THEN 1 ELSE 0 END AS Draw, CASE WHEN HomeScore > AwayScore THEN 1 ELSE 0 END AS Lost, AwayScore AS Scored, HomeScore AS Against, AwayScore - HomeScore AS Agg, CASE WHEN HomeScore < AwayScore THEN 3 WHEN HomeScore = AwayScore THEN 1 ELSE 0 END AS Pts FROM tblFixtures AS tblFixtures_1 WHERE (CompID = 1) AND (HomeScore IS NOT NULL)
I am trying to setup a shape, shape attributes and calculate the cross sectional area using the formula specified in the tbShapes.Formula field. See the code below.
Now I need to calculate the expression above, but the expression is a varchar string.
Any help?
USE NORTHWIND GO
SET NOCOUNT ON CREATE TABLE [dbo].[tbProductCodes] ( [ProductCode] [int] NOT NULL , [fkAccountID] [int] NOT NULL , [Product] [varchar] (50) NOT NULL , [fkShapeID] [int] NOT NULL ) ON [PRIMARY] GO
INSERT INTO tbProductCodes (ProductCode, fkAccountID, Product, fkShapeID) SELECT 2001, 1, 'New Product', 1 GO
CREATE TABLE [dbo].[tbProductTemplateAttributeValues] ( [fkTemplateID] [int] NOT NULL , [fkAttributeID] [int] NOT NULL , [AttributeValue] [float] NOT NULL ) ON [PRIMARY] GO
INSERT INTO tbProductTemplateAttributeValues (fkTemplateID, fkAttributeID, AttributeValue) SELECT 1, 1, 108 UNION ALL SELECT 1, 2, 36 UNION ALL SELECT 1, 3, 4 UNION ALL SELECT 1, 4, 5 UNION ALL SELECT 1, 5, 2 GO
CREATE TABLE [dbo].[tbProductTemplates] ( [TemplateID] [int] NOT NULL , [fkProductCode] [int] NOT NULL , [Template] [varchar] (50) NOT NULL , [fkMixID] [int] NULL ) ON [PRIMARY] GO
INSERT INTO tbProductTemplates (TemplateID, fkProductCode, Template, fkMixID) SELECT 1, 2001, 'ProductTemplate', 1 GO
CREATE TABLE [dbo].[tbShapeAttributes] ( [AttributeID] [int] NOT NULL , [fkShapeID] [int] NOT NULL , [Attribute] [varchar] (50) NOT NULL ) ON [PRIMARY] GO
INSERT tbShapeAttributes (AttributeID, fkShapeID, Attribute) SELECT 1, 1, 'Width' UNION ALL SELECT 2, 1, 'Height' UNION ALL SELECT 3, 1, 'Flange' UNION ALL SELECT 4, 1, 'Leg' UNION ALL SELECT 5, 1, 'Count' GO
CREATE TABLE [dbo].[tbShapes] ( [ShapeID] [int] NOT NULL , [Shape] [varchar] (50) NOT NULL , [Formula] [varchar] (100) NULL ) ON [PRIMARY] GO
-- Get the formula for the templates shape SELECT @cResult = s.Formula FROM tbShapes AS s INNER JOIN tbProductCodes AS pc ON s.ShapeID = pc.fkShapeID INNER JOIN tbProductTemplates AS pt ON pc.ProductCode = pt.fkProductCode WHERE pt.TemplateID = @iTemplate
SELECT @cResult AS Formula
DECLARE AttributeCursor CURSOR FOR SELECT sa.Attribute, av.AttributeValue FROM tbProductTemplateAttributeValues AS av INNER JOIN tbShapeAttributes AS sa ON av.fkAttributeID = sa.AttributeID WHERE av.fkTemplateID = @iTemplate
OPEN AttributeCursor FETCH NEXT FROM AttributeCursor INTO @cAttribute, @fAttribute while(@@FETCH_STATUS = 0) BEGIN SELECT @cResult = REPLACE(@cResult, @cAttribute, CAST(@fAttribute AS VarChar)) FETCH NEXT FROM AttributeCursor INTO @cAttribute, @fAttribute END
SELECT @cResult AS NewFormula
CLOSE AttributeCursor DEALLOCATE AttributeCursor GO
-- Test stored proc
declare @iTemplate int, @fResult float
SET @iTemplate = 1 EXECUTE usp_shapes_GetCrossSection @iTemplate, @fResult OUTPUT SELECT @fResult AS Result GO
drop table [dbo].[tbProductCodes] GO
drop table [dbo].[tbProductTemplateAttributeValues] GO
Hi, Just a quick note for all that the SSIS team has started to post fresh content for download.
We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN http://msdn.microsoft.com/SQL/bi/integration/default.aspx
For now if you search for "ssis" on the microsoft downloads site you will find the current content. Sample Logging reports, jump start training, Meta Data info, and sample components. More coming over the next few weeks... http://www.microsoft.com/downloads/search.aspx?displaylang=en
Thank you and I hope everyone enjoys winding down 2005, or blowing it out, depending on your likes :)
This may not be a MSSQL-specific question, butI wanted to ask it here first, in case there'sa MSSQL and/or SourceSafe solution that will help.Our dev team is having some difficulty withkeeping the nightly builds in sync with thestored proc mods. I'm wondering if there aresome good case studies on how to avoid this"drift". Something like genning a new DB fromchecked-in SPs, etc. alongside each regular build,then always have a paired enterprise app/databaseduo that is tagged and added to a history.FWIW, we have a 3-tier .NET/C# app, andADO.NET is throwing exceptions every otherday.If the suggestion is to whip the DB guys, thatworks for me as well. ;-)Nah, there's much love there.Thanks in advance,~swooz
i am a beginner of database design, could anyone please help me tofigure out how to make these two tables work.1) a "players" table, with columns "name", "age"2) a "teams" table, which can have one OR two player(s)a team also has a column "level", which may have values "A", "B",or "C"how do you build the "teams" table (the critical question is "do ineed to create two fields" for the maximum two possible players?")how do you use one query to display the information with the followingcolumns:"name", "age", "levelA", "levelB", "levelC" (the later three columnsare integer type, showing how many teams with coresponding level thisplayer is in).now suppose i don't have any access to sql server, i save the datainto xml, and load it into a dataset. how could you do the selectionwithin the dataset? or ahead of that, how do you specify the relationsbetween "players" and "teams".the following is the schema file i am trying to make (I still don'tknow if i need to specified the primary key... and how to buildrelation between them):<code><?xml version="1.0" ?><xs:schema id="AllTables" xmlns=""xmlns:xs="http://www.w3.org/2001/XMLSchema"xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><xs:element name="AllTables" msdata:IsDataSet="true"><xs:complexType><xs:choice maxOccurs="unbounded"><xs:element name="Players"><xs:complexType><xs:sequence><xs:element name="PlayerID" msdata:AutoIncrement="true"type="xs:int" minOccurs="0" /><xs:element name="Name" type="xs:string" minOccurs="0" /><xs:element name="Age" type="xs:int" minOccurs="0" /></xs:sequence></xs:complexType></xs:element><xs:element name="Teams"><xs:complexType><xs:sequence><xs:element name="TeamID" msdata:AutoIncrement="true"type="xs:int" minOccurs="0" /><xs:element name="Level" type="xs:string" minOccurs="0" /><xs:element name="Player1" type="xs:int" minOccurs="0" /><xs:element name="Player2" type="xs:int" minOccurs="0" /></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema></code>
I have installed SP2 on my report server and configured for Sharepoint access.
This is all ok.
I am able to use the webpart to create a report view but it wants the report. Is there a way to manage the report server (they way I did with reportmanager) in sharepoint. If so I have not found out how.
any ideas or links to show how I can have teh reports listed in Sharepoint?
I would like to setup SSIS project so that multiple developers can work on same project. I am having issues with protectionlevel properties while another developer opens the package created by other developer.
Can anyone guide me on setting up project so that multiple developers could open the package and run (not simaltaneously though). Also tips on setting up source safe or team foundation will be appreciated!
First let me say, I play to try and write up something more formal with some details of my recent frustrations of moving my SSIS packages into Team Foundation Server, I'm curious though if I'm the only one doing this.
Its seems that TFS is severely lacking some functionality to make it truly useful for SSIS. First and foremost the lack of it's ability to have an offline working mode and its inability to merge DTSX files (coupled with the fact there is no "Check-out but keep local copy" ability)
Has any one else been using TFS and SSIS, are you finding it to be adequate? I'm hoping to find out where the major issues are so we can bring it to the attention of MS for some updates. I fear this combination might not be extensively used and as a result support will be overlooked by MS in upcoming service packs.
I'm working in a team, and need to share a database between the group - we don't have the luxury of sharing a server and connecting to it.
So What we'd like to do is make a copy of the database schema, and then share that through our repository.
I figured I just need to copy the .mdf file from the sql server database folder, and put it in the visual studio directory to work on it?
So I've tried this, but when I try to create a TableAdapter to the database through visual studio, It gives me an "access denied". I figure this is probably something to do with security settings?
Do you think I'll need to change my Database connection from windows authentication to sql authentication?
I don't really know exactly how to do what I'm trying to do, so any help will be appreciated.
Power Pivot .... Â I have a model established that has a date table, Order table, Sales rep table, and a financials table that all feed each other nicely. Â
The issue is that some of the individual sales reps are also on sales "Teams" of 2-4 people, and I am not sure how to account for that when I am building pivot tables without relying on slicers and CTRL clicking. Â
I also don't want to resort to programmatically duplicating rows via SQL.
We have a large number of SPs in our databases and decided it was time to get some source control. I have VSTS team explorer installed and working in visual studio, but I cannot get the plugin for SSMS to work - it just says none in the current source control plug-in dialogue box - nothing when I drop it down either.
I am working on an ASP.NET and c# project. I am creating a page that allow user to add new Workitem to TFS and successfully do so. Now I would like to implement the way to email to notify the user that the new WI is added €¦. Does anyone know how to do this or have an example of how to implement that. Any help would be greatly appreciated.
I am using excel 2010 and SQL server as a data source. When I create a report with the User name "demo_user" which has db_writer access, and mail it to the colleague , he could not refresh the data with the "demo_user" credentials and apparently its throwing user name or password invalid. The one who created only could be able to refresh the data.
What should I do If other people want to refresh the data? How could I fix this issue? We are using SQL server 2012 and excel 2010 powerpivot.Â
I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database. I built another application using windows service, and this application also connects to ASPNET.MDF database. problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed. I am going on circles about this, and just don't know what to do. Please please please. love me do.
I have a SQLexpress db that i would like to be able to access from both a windows app and web app (both running on the same machine) at the same time. Is this possible. I've been able to connect either one or the other, but not both at the same time. Thanks
If there are 2 different web application connecting to a sql server database through ODBC connection, both of them have full privilege to update , create , add column etc. Would there any issues of SQL server impacts when actually on live.
Hi to all.. Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc. Thanks to all..
I am running SQL Server 2005 Dev x86 with SSRS SP1 on Windows2003 Svr SP1.
My SQL Server is running and SSRS is working. When I come to run certain installs though, my Server name is not present in the dropdowns or in the browse for installed server lists.
I entered the name of my SQL server manually, but when I ran the application, it gave me an error: 00250 unable to run dtabase locator service.
