Alex Belik's Q&A profile

• Visual Studio Express Editions Installing Microsoft SQL Server 2005 Express Edition

  Hi I wonder if some one could help me with this problem that I have when I install Visual Basic 2005 Express Edition from cd , when the installation has completed there is a message that says visual basic 2005 express successfully installed but Microsoft SQL Server failed to install . My operating system is Windows XP Home Edition SP2, I was wondering if it was my operating system mybe you can not install it on windows xp. Could some one please help me with this. Thanks Dear Keith I have exactly the same problem, everything installs fine, but not SQL Server. I have tried uninstall then reinstal ...Show All

• Visual Studio Team System Videos / Presentations on Team Services and Team Foundataion System

  Hi, Could anybody please list for me some URLs for demos, videos and presentations on using MSTS and TFS. Thanks. Check this out! http://teamsystemrocks.com/tutorials/ Hope this helps! Sincerely Vince ...Show All

• Visual C++ When NOT to use /clr

  I notice the new 2005 compiler happily compiles my native projects, even ones that contain inline asm and variable param functions. It just warns me about the native code generated.  The managed c++ compiler in 2003 could not handle this. So, why would I ever want to not compile with the /clr option   I have found in the past that a mixed code application can spend 50-90% CPU time in mscorwks.dll even without a single managed class, just by adding or taking #pragma unmanaged/manged in some files.  I am obviously trying to avoid this problem. If you ever want to put any .NET into you nativ ...Show All

• Visual C# message box in webapp

  I need help. I need a message box OK/Cancel button in a web application (JavaScript ) to confirm a deleting row the problem is that i have not button "Delete" but i have a datagrid with a button column. Thx PS-could you post code and explanation In the ItemCreate event from the DataGrid put this: Control myControl = (Control)e.Item.FindControl( "MyControlID" ); myControl.Attributes.Add( "OnClick" , return confirm('Are you sure ');" ); ...Show All

• SQL Server Push Merge snapshot fails with Data is Null message.

  Hi, I'm converting a replication script from SQL 2000 to SQL 2005. I am getting an error with push merge with no way to figure out what is wrong. I've configured replication on a single XP server in SQL 2005 RTM version. I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility. The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok. The snapshot for B to C fails with this message: Message 2006-03-09 17:30:35.94 --------------------------------------------- 2006-03-09 17:30:35.94 -BcpBatchSize 100000 2006-03-09 17:30:35.94 -HistoryVerboseLevel ...Show All

• SQL Server Rebuilding dimensions with huge fact tables

  Hi, I have a dimension which is used in two Measure Groups. It has many levels (let's say 10). One fact table handles level 1-8, the other 8-10. The facts are huge, about 2 billion records for the first table (for level 1-8) and 100 million records for 8-10. We discussed a fitting partitioning schema and this will not be the big issue. Our problem is, that in the last levels (9-10) members can move from one parent to another. That means that the dimension structure changes, it has to be updated which also means a reprocession of all partitions related to this dimension. This is really a problem because of the first fact ta ...Show All

• Visual Studio Express Editions Cannot Access Free Registration Materials via Thank-You Emails

  Hi everyone. I'm trying to access the free downloads that come with registration, but I only see the Web Developer downloads listed. I don't see the icons, components, or book that come with C#. I assume they would all be listed on one page, but they aren't there. How can I find them Thanks, John Salerno P.S. I don't understand how to download what *is* there either. The link to the Web Developer book says it's a pdf, but when you download it, the file is an aspx file that won't do anything when opened in WD. When opened in an internet browser, it just tries to download itself again. Maybe the site will be updated and fixed tomorrow. ...Show All

• SQL Server Hierarchial Queries - Order of the data

  Hi I am using SQL Server 2005 Developer edition(Sep 05). I had an oracle hierarchial query the equivalent of which I had written in SQL Server. The problem is the order of the data is different in SQL Server. To put in proper context : I need 1. The root node 2. The root’s children and the children  of roolt's children and so on and so forth I get 1. The root node 2. The root’s immediate children 3. The children of the root’s immediate children 4. And so forth. Find below the DDL , Insert script , the Hierarchial Query , the data expected to return and the actual data returned. ---------------------------------- ...Show All

• SQL Server SQL 2005 RTM We hit an error Msg 8630, Level 17, State 99, Line 18

  We just hit the following error with SQL 2005 RTM version Msg 8630, Level 17, State 99, Line 18 Internal Query Processor Error: The query processor encountered an unexpected error during execution. Any idea of what that message could mean The only explanation I found in some forums was that this means we had come upon a SQL Server bug The query is actually the EXEC of the below stored proc. After running just the select statement with a hardcoded value for the variable @dtAdjustedMinCreateTime (which actually works fine), t he execution of the SP starts working (and returns the ~4'000'000 rows of ...Show All

• SQL Server Can someone clarify why only a single-statement can be executed in a command?

  I'm evaluating SQL 2005 Everywhere Edition for use by our desktop application. I'm a traditional SQL Server developer and I rely heavily on stored-procedures to encapsulate basic data manipulations across multiple tables and inside multi-statement transactions. I was excited to see an in-process version of SQL released and my thought was "this is great... now I can ditch the tediousness of individual OLEDB/.NET commands, and write batches of T-SQL and just focus on the data manipulations". But, alas, it seems I cannot. Why is SQL Everywhere Edition limited to executing a single SQL statement at a time For example, my applicat ...Show All

• SQL Server user-defined function remove and replace accents

  anyone know where to find a function that will remove and replace accents i found a library that does it for access, but now i need one for sql server Not specific to a UDF, but should be easy to translate... http://blogs.msdn.com/michkap/archive/2005/02/19/376617.aspx Function removeAccents(str As String) Dim string1 As String Dim string2 As String Dim car1 As String Dim car2 As String Dim newString As String Dim i As Integer string1 = "aaeeeiouunAEIOUN" string2 = "aaeeeiouunAEIOUN" newString = str For i = 1 To Len(string1) car1 = Mid(string1, i, 1) car2 = Mid(string2, i, 1) newString = Replace(newStrin ...Show All

• Visual Studio Tools for Office Errors using Inspectors in Outlook AddIn

  I am using the Application.Inspectors Object to get the Event NewInspector“ With this Event I can add a Button to the Appointment-Form and setting a Reference Object to the opened Appointment Form so I can get the Information from this Form as Date/Time ... It is working great, except one thing. Opening a Note (passing thru the same NewInspector Event as well) causing an Error when closing Outlook “Outlook cannot be closed, at least one parameter is invalid” after this comes a new message that says “The Note will be closed without saving” But there is no any open Note, why are the messages coming What can I do abou ...Show All

• Visual C++ Optimizer fails to remove unneeded loop?

  Here's a minimal code sample that illustrates the problem: #include <cstring> #include <iostream> using namespace std; # define TEST_COUNT 5000000 void AssignStr( char * str ) {     strcpy( str, "changed" ); } int main() {     char temp2[16] = "no change" ;     for ( int i = 0; i < TEST_COUNT; i++ )     {         AssignStr( temp2 );     }     cout << temp2;     return 0; }   And the assembly listing generated for the loop: PUBLIC _m ...Show All

• SQL Server Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

  Keep getting this error when positioning to the last page of a report. Using Server 2003...SqlRpt Svcs 2000 sp2 Detail error msg: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Anyone have any suggestions   Any way to find out what collection is blowing ...or where parameter name: index comes from Can you ...Show All

• Visual Studio SS 2005 Get and Get latest error

  im using vpn to connect to SS database , via drive mapping and then set up https access to source safe 2005 successfully and its working perfectly. Now I can work while disconnected from VPN The only problem is that when I select the project and click get or get latest, the error appears saying , --------------------------- Microsoft Visual Studio --------------------------- The current source control operation cannot be completed. The source control plug-in returned the following error: Item does not exist. --------------------------- OK --------------------------- I have tried connecting to VPN and then doing get latest and ...Show All