srii's Q&A profile

• SQL Server sys.conversation_endpoints

  Is there anyway to figure out which tables/objects this view uses In SQL Server 2000 one could see the actual script of the view but in Yukon this is only possible for user-created views, right What I am aiming for is to combine the speed of sp_spaceused with the information in sys.conversation_endpoints (and maybe other service broker views, like sys.transmission_queue) to tell me, quickly, how many conversations are in a particular state ...Show All

• SQL Server Get Minimum day in a continuous series

  Hi, l've a series of day which record the date of an event. l would like to count the # of continuous days for the event. In this case, it would be 14/5, 15/5, 16/5, 17/5, 18/5, 19/5 and 20/5. Any idea to do this in SQL Date ----- 20/5 19/5 18/5 17/5 16/5 15/5 14/5 09/5 07/5 06/5 05/5 The only thing that comes to mind is to use a cursor to loop through your rows. You can then che ...Show All

• Visual Studio 2008 (Pre-release) May CTP for Linq

  Yeah!!!! There appears to now be a May 2006 CTP for linq. Yes, it can be downloaded here: http://www.microsoft.com/downloads/details.aspx familyid=1e902c21-340c-4d13-9f04-70eb5e3dceea&displaylang=en Bye. ...Show All

• Visual Studio Team System Stored procedures for reports

  Hi there,     Where are the stored procedures for reports located in database Thanks, Anu             The reports generally go against the OLAP cubes so they end up being mdx queries.  data is pulled into the warehouse on an interval.  The operational stores typically do not get accessed by reporting. ...Show All

• Visual Studio Debugging multi-threaded operations problem

  You'll love this one... I've ran into a rather odd problem, both in the application I'm in the process of developing and in a test project I threw together just to replicate the issue. When debugging code that is run on a thread other than the main execution thread the non-main thread will exit for no apparent reason. Here's the kicker... It only happens if you have the autos variable window selected i.e. the problem will not show if you're view ...Show All

• SQL Server Help Designing an App. to be Run from a Job

  Hello, I'm working on a project that uses SQL Server 2005 and C# 2.0. I need some ideas of the best way to design/implement an application that will be executed from a SQL Server job. The general idea is: a SQL Server job will call [ something ] and pass a couple of parameters to [ something ], then [ something ] will query a database and gather other information, then [ something ] will do some processing of data, and finally [ something ...Show All

• Visual Basic Vertical spaces in a string

  Well, I'd like to know how to put vertical spaces in a string. I was making a program to make it faster when you type If...Then statements. I know you can put these statements on a single line, however, it's just more estetic and easier to have that kind of statements on many lines. I thank you in advance for, I hope, what quick answers there will be. Charles Gauthier-Marcil, Programmer Apprentice ...Show All

• Visual Studio Team System How to point 1 VSTD client to multiple TFS servers

  I have a configuration whereby I want to be able to point my Visual Studio Team Edition for Software Developers (VSTD) client to two *different* TFS servers. I have managed this once before with the CTP releases but I can't remember what I did Currently I have the client pointing to TFS1. I used to Connect to Team Foundation Server dialog box to add the server and everything was as it should be. Now I can't seem to get back to the dialog b ...Show All

• Visual Studio Express Editions How to print receipt in a picture box?

  Hi, I made a simple program that would generate a receipt preview, but I wander on how to do it in Visual Basic Express. I am going to use Picture Box because, other said that picture box can hold up a text or an image. How can I do this with my example format below: MyCompanyLogo MyCompanyAddress DATE: 05/06/2006 RCPT: 34566 STAFF: 23455 SND: 3467785667 1 480MLNSTEA ICE 18.00 2 SFGUAR SOAP 5 ...Show All

• Visual Studio Express Editions How to enable line numbers in text editor?

  Could not find Tools->Options anywhere that will allow me to enable line numbering in my text editor. I must be looking in the wrong place, can anyone help When you do open the Tools -> Options make sure that you check the check box at the bottom that says show all settings. This will open some more values in the tree. From there you can add the line numbers to each of the editors windows, for example ...Show All

• Windows Forms How can I find out if a form (in my case a child form of MDI parent) is maximized?

  Hi, How can I find out if a form (in my case a child form of MDI parent) is maximized is there a way to know the MDIParent max size for its child forms   Thanks,   You can use the WindowState property to determine if the form is maximized: if (myForm.WindowState == FormWindowState.Maximized) { }   > is there a way to know the MDIParent max size for its child forms I'm not sure what you me ...Show All

• Windows Forms Best way to do HTML reporting?

  I'm developing a form that does a bunch of db operations and at the end of the day, I want to generated detailed reports.  I can't use Crystal because these reports would be distributed so I have licensing issues.  So I thought, it&nb ...Show All

• Windows Forms Accessing Design-Time Only Properties

  Does anyone know if it's possible to access Design-Time only Properties, such as the Locked Property from inside a Designer   The kicker of the question is...I need to access it from another control   I'd just like to know if this is possi ...Show All

• Windows Forms Close button problem...URGENT!

  Anyone know how I can conrol what happens when a user presses the close button on the for ( the x int the top right corner). My problem is that the form doesnt close when the button is pressed.  Please help!!!!!  Fou ...Show All

• Visual Basic initialise settings variable

  Hey guys,                  In my application I have a setting that is an arraylist variable. I keep getting a Nullreference exception because it hasn't been initialised yet. So easy I initialise it but then it does that every single time I start up and the variable is emptied every single time when I want to be able to save it on exit and reload eve ...Show All