Luis Soto's Q&A profile

• SQL Server Programmatic access to the code SQLCMD uses to parse sql into batches

  Hi, I am thinking of writing a C# Windows app to iterate a set of sql scripts and submit them to SQL Server. Many scripts have "go" as a batch delimiter. I could probably figure out a regular expression to parse for that delimiter, but it seems tricky (need to exclude 'go', -- go, /* go */, etc). Obviously SQLCMD and Management Studio have a way to do this. I was wondering if that's exposed in an API anywhere. I looked into the SMO object model, but I couldn't find it. Thanks much, Mike As far as I can tell "set parseonly on" just checks the syntax. I want to get back a coll ...Show All

• Visual Studio How can I set the build action property of an item from a item template ?

  Hi, I developed project template and item template. My item, which is based on an item template, has a specific build action. How can I  set it from the item template I don't find any property or any element in the Visual Studio Template Schema Reference to do this. I tried the subtype attribute of the ProjectItem element but nothings happens. In the thread below, the question was similar but the response is ambigous. > http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=98524&SiteID=1 Regards. Pascal Craig, Thanks for your help. The result of my work is avaible at this url . Regards. Pascal RECCHI ...Show All

• SQL Server Searching for a technical documentation on SQL Server Express

  Hello, I seek a documentation on SQL Server Express to find some technical information such as Limits of the Database (Limits per Database, Maximum Number of Joined Tables, Maximum Logical Operators in WHERE clause, ...), Programming Features (Transactions, Transaction Isolation Levels, ...), Distributed Transactions , Performance of the Database. Thank you a lot for your help. Osman. If you have not already done so, I recommend downloading the December 2005 version of SQL Server Books Online from here: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx . The SQL Server Express B ...Show All

• SQL Server Is SSIS slower than DTS????!!!!!!

  I am new to SSIS and probably doing some mistake while transferring data from oracle source to oracle destination.   Please guide me..   In our project we need to transfer nearly 80 GB data from old system (Oracle 9i) to new system (Oracle 10 G Release 2). To do this exercise we are testing and comparing performance and cost effectiveness between different tools like SSIS, DTS and SQL * Loader (oracle built in tool).   We have selected one table, which is having 40 fields with 3 million records. The destination table is also having same structure.     Surprisingly SSIS is giving slower performance ...Show All

• Visual C# how to read from embeded file in my project

  hi, i have a file that contain just a binary data, the file extension is .bin, this file will be embeded in my assymbly, i want to read data from this file so how can i do that in that thx in advance hi, ok let me rephrase my question i have  bin file which contain binary data i want to read it, that file will be embeded in my project but i don't know how to read from the embeded files i can read it from my drive private byte [] tables = new byte [ 5536 ]; FileStream fs = new FileStream ( @"C:\.crypt.bin" , FileMode .Open, FileAccess .Read); BinaryReader br = new BinaryReader (fs) ...Show All

• Visual C# Random give the same value

  hi, i'm building a small game like puzzle so i need to swap an array items in different order each time i run my program,  every time i use random it works and make the array order diferent but the problem is every time it give the same result as if i used fixed number here its example of my code in class Program { static int [] Numbers = { 0, 1, 2, 3, 4, 5, 6, 7, 8 }; static void Main( string [] args) { Random rnd = new Random (0); int i, j, tmp; for (i = 0; i < Numbers.Length; i++) { // the problem in this part j = rnd.Next(0,8); tmp = Numbers[ i ]; Numbers[ i ] = Numbers[ j ]; Numb ...Show All

• SQL Server Can't debug DataFlow Script task

  I have debugged a Control Flow script task and everything went as expected. I put a breakpoint somewhere in my script code, press F5 and execution will break there. However, when I try the same in a Data Flow script, execution does not break! Moreover, when I reopen the code right after I closed VSA, the breakpoint is not there anymore... Any help would be appreciated. Regards, Henk Henk, There's a simple answer to this. SSIS does not (yet) support breakpoints in a script component. Regards Jamie ...Show All

• SQL Server SQL Server Express Question partly related to ClickOnce

  Please see the thread linked below from the ClickOnce forum...(specifcially, please see my last post in the thread). Any help would be greatly appreciated! http://forums.microsoft.com/MSDN/showpost.aspx postid=171243&siteid=1 There are two places to find the full list of support command line arguements: 1) From the command prompt, run sqlexpr.exe /x, provide a path to extract the package contents. Once extracted look for a file called template.ini. Open this in notepad. This file describes the full list of supported arguements. 2) Download Books Online ( http://www.microsoft.com/downloads ...Show All

• Visual Studio Express Editions VB6 to 2005 Control Arrays

  Can someone please tell me a little bit more about Control Arrays after upgrading VB6 to 2005 There are 7 images which use the same click sequence, and they are all named Card. The following is a sample of the code: VB6: Private Sub Card_Click(Index As Integer) If Card(Index).Picture = Image2.Picture Then Safenum = Safenum + 100 Card(Index).Picture = Pile(1).Picture Call Nextmove Call Enemymove Exit Sub End If End Sub VB 2005 after conversion: Private Sub Card_Click( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles Card.Click If Card(Index).Image.equals(Image2.Image) ...Show All

• Visual C# Why updating datarow cause myComboBox_Selected

  I have a ComboBox binded to a field of a DataTable which have one row only.  The ComboBox has it SelectedIndexChanged() event handler.  When I update another field of the row, it raise the SelectedIndexChanged event, why Thanks. Thanks for the reply.  Setting a flag is a good idea.  But I wonder why ComboBox.SelectedIndexChanged() will be called since the field I updated is "CustomerID" while the Combobox is binded to field "PaymentTerms".  The updated is done by: this.mydataSet.Tables[0].Rows[0]["CustomerID"]=1; But that raise the ComboBox.SelectedIndexChanged() and the ComboBox is reset. I find that datab ...Show All

• Visual Studio How to retrieve data from Connectors(Relationship control) to form XML report in report template.

  Hi, We are generating XML report from diagram which consists of Shapes and connectors. We are able to get data from Shapes for XML report but we are unable to get the data stored in connectors(Relationship control). For connectors we have put Relationship control and it is having three value properties. Data is stored in this value properties. Can anybody please tell us how to get data from value properties defined in Relationship control in report template. any example/Sample code will help us a lot. Thanx in advance Regards Kiran Kirdat Hi Kiran, Are you having tro ...Show All

• Visual Studio 2008 (Pre-release) There is event when server is closed ,it is send to client ?

  Hi I write server and client in wcf(indigo self host). Sometimes the server is failed. I want to know how client can to know if server was failed, without accept exception when i call the server. There is event when server is failed that the client can accept. Hi Oren, What do you mean by saying that the server failed Do you mean that the server threw an exception and the client never got it If you do mean that, you should read about FaultContracts. When exception occurs in the service, the channel is cut off and the exception never return ...Show All

• Architecture Safely access file from a Web server

  Hello, I work on a project where clients access to a database and a files storage system (NTFS). On a LAN, all works fine but we would like to allow user to access those data from Internet. My question is: how our Web server can safely access to the file storage Is it acceptable to access directly to the files Must we develop a kind of application server In this case, which kind of technology could be used Lastly, if my web server is running on Linux what are our options Thanks, Sebastien I don't see any reason you couldn't continue to use your files and leverage the NTFS permissi ...Show All

• .NET Development Why do all examples assume you're binding data to a control?

  I'm starting to get frustrated now. Every example I come across shows you how to open a connection to a database, fill a dataset, but not how top programatically get at the data... Every example assumes you are going to bind the data to a control and update using a GUI. How do you get at the data within a DataSet once you've Fill()ed it Not from a form, but from with the application. This frustration is also heading towards disappoinment. The examples never seem to do anything. They get you to a point and then leave you dangling. This is an ideal way to ensure the after market for books etc. thrives... The "Build a Program Now!" e-book ...Show All

• Visual Basic Visual Studio 2005 Professional

  As I already have Visual Studio 2002 Enterprise Architect, I am thinking of purchasing the upgrade to Visual Studio 2005 Professional as it comes with Crystal Reports. Does the Professional edition come with the full blown version of Crystal Reports and what version is it as I would like to create reports. I have Crystal Reports 8.5 currently therefore is it worth upgrading to Visual Studio 2005 Professional. I am going to develop an application with a number of reports from home and then deploy this application in the company therefore any advice on the Visual Studio upgrade would be great. Regards Dipendra ...Show All