Boris's Q&A profile

• SQL Server Can't Route to another LOCAL Broker Instance

  I have two databases (A and B )on the same SQL Server instance. Both have SSB enabled and running fine within themselves. All athorizations are at present set to dbo. Recently I had a requirement to start a dialog and send a message from within data base A to a queue via a service that is in database B. I tried coding the SSB instance in the BEGIN DIALOG then I set up a route and tried that. On both occoasions I got the following on sys.tr ...Show All

• SQL Server Do Inserts into Temptable enforce order of select?

  I have a temp table which I am trying to do a select INTO.  The temptable has an identity field which increments by one.  In the select query, I am doing an order by.  It does not appear that the temp table retains the physical ordering of the records from the order by.  When I do a select * FROM temptable without an order by, the first record that is displayed as an id of 113.  Then about the 42nd record in th ...Show All

• Microsoft ISV Community Center Forums Empower program software keys

  I recently signed up to the empower program and received the software yesteday. I expect that my membership id has been activated but msdn does not recognise it and so I cannot access the keys to install the software. I have type in my name, email address and membership id and am getting the " The subscription information you have entered is not valid." error message. Has anyone got an idea as to what I might be doing wrong her ...Show All

• Visual Studio Express Editions Sifting through array for matches

  Hello all, Sorry for such a beginner question, but I can't seem to work through this. I've thought about it for a while, and I just can't seem to figure out a solution. Sorry in advance: I've got an array with a bunch of names in it, and I want to sift through it to make sure that none of the names are the same, and if they are, then I want to take out one of the matches from that pair. So for instance, if i've got an array tha ...Show All

• SQL Server cant see Report manager page

  Hi Friends we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !! all they can see is "sql server reporting services" text nothing else. no reports and no models ertc., i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create ...Show All

• Visual C++ Reference dll

  I'am learning VB.NET and VC++. I created a dll in VC++, but VB.NET didn't recognize it as a reference dll. So my question is how do I make my VC++ dll, a reference dll try looking at: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconconsumingunmanageddllfunctions.asp     ...Show All

• Windows Forms Install dialog shows the Cancel button cut in half

  Has anyone seen this behaviour I have a user having this problem, any ideas If you have a long Publisher path and see the Cancel button got cut, this is a known issue. We have a bug on it. Thanks, Patty ...Show All

• Visual C# How can I speed this up: excel spreadsheet data loading

  I am iterating over data, in an excel spreadsheet, and loading it into memory. My current method for doing this is extremely slow on large (~12,000 rows) tables: while ( lRowIndex < lSheet.Rows.Count ) { String lText = (( Excel. Range )(lSheet.Cells[lRowIndex, 1])).Text.ToString(); int lKey; if ( int .TryParse( lText, out lKey ) ) { String [] lDataRow = new String [lColHeaders.Count]; lDataRow[0] = lT ...Show All

• Windows Forms How undo delete in BindingNavigator ?

  Hi! I am using C# and VS 2005. When a user deletes a row using BindingNavigator, it's too late to ask "Are you sure " So, how do I undo the last "delete" Can you show me a code example of allowing "Are you sure " and either performing the delete on true or rolling back the last delete on false Thx, Jess Sorry for bothering everyone, If found this solution at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=148907&am ...Show All

• SQL Server SSMS Express: Using PIVOT operator to Create Pivot Table - Error Messages 156 & 207

  Hi all, In MyDatabase, I have a TABLE dbo.LabData created by the following SQLQuery.sql: USE MyDatabase GO CREATE TABLE dbo . LabResults ( SampleID int PRIMARY KEY NOT NULL, SampleName varchar ( 25 ) NOT NULL, AnalyteName varchar ( 25 ) NOT NULL, Concentration decimal ( 6.2 ) NULL) GO --Inserting data into a table INSERT dbo . LabResults ( SampleID , SampleName , AnalyteName , Concent ...Show All

• Windows Forms UndoEngine in standalone Designer

  I derived from UndoEngine and implemented a AddUndoUnit Method that pushes a UndoUnit onto a stack. My IServiceProvider is a DesignSurface with an CodeDomSerializationService (Serilazation seems to work and my stack gets bigger for any change I make on my UI). I expected the UndoUnit.Undo() Method to desirialize the latest SerializationStore that gets popped of the stack, but it doesnt seem to work. How is the UndoEngine meant to be implemented ...Show All

• SQL Server sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks I installed SQL Server 2005 Express and Management Studio Express (CTP November). When I try to launch the management studio nothing happens....I'm very confused about it, because I tried to search a solution for hours, but I didn't find anything about it. ...Show All

• Visual Studio Team System VSTS Architect vs. VSTS Developer

  With he proposed changes in MSDN subscriptions and Visual Studio licensing, I now have to make a decision between VSTS Architect and VSTS Developer. As I understand, MSDN Universal subscribers will have a choice - they can either go for VSTS Architect and VSTS Developer. I believe that I need both architecture and development tools. Which out of two should I go for The information was interesting but too high-level to be really useful ...Show All

• SQL Server Design Ragged Hierarchy in AS 2005

   Hi,   I want design a ragged hierarchy in AS 2005.   The content of table as following:   item,      catelogy, kind   A0101,  A01,        A   A0102,  A01,        A   A0201,  A02,        A   A0202,  A02,        A & ...Show All

• Smart Device Development Form.Show() Problem

  Hello, I am attempting my first VB.NET SmartPhone 2003 app and am running into a bit of a snag. I have a Sub Main that my app runs from. I am attempting to display a form using the Form.Show(). It doesn't give an error but the form does not display. Form.ShowDialog appears to work fine. I don't want it to be a ShowDialog because that suspends the processing in the Main - which I need to continue so I can pop-up, close windows, and ...Show All