Omid Bayani's Q&A profile

• SQL Server Progress

  I have some SP's I run once a month and each SP takes a few mins to run and when I batch em together in one shot, I hate sitting there waiting for them to finish whats the easiest way to report back the status of the exec Ex: Set NoCount ON EXEC StatesUpdateZipTableUpdate 'AE' EXEC StatesUpdateZipTableUpdate 'AK' EXEC StatesUpdateZipTableUpdate 'AL' EXEC StatesUpdateZipTableUpdate 'AP' EXEC StatesUpdateZipTableUpdate 'AR' EXEC StatesUpdateZipTa ...Show All

• .NET Development Timeouts

  A Treeview is used to select the record to be displayed. On clicking a node a record is displayed. It is possible to click 9 nodes & get the record displayed but the 10th bombs out with a TimeOut message. "Error. System.Data Timeout expired....." On restarting VB (2003) clicking the record causing the bomb is displayed correctly so it is not an issue with that record. I have VERY carefully checked that every "cnn.open ...Show All

• SQL Server FTP Task - Delete remote files always fails

  Hello, I have two FTP Tasks configured in my SSIS package. One is for "Receive files" and the other is set for "Delete remote files." Both use variables for the source/destination paths. My remote path variable contains a wild card in the name field such as /usr/this/is/my/path/*.ext and it is working to FTP all the .ext files to my working directory. I then rename the files and want to remove the original files from t ...Show All

• Microsoft ISV Community Center Forums Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. can you please provide some additional details what program are you trying to do this from (Word, Excel, ) do you have an example of the code that you've tried for the engineer to look at thanks! -brenda (ISV Buddy Team) ...Show All

• Visual Studio Team System Error Installing TFS in a Single-Server Installation

  I received an error: 32000 during the App-Data installation of TFS.  The event log showed the following: Adapter Microsoft.VisualStudio.Currituck.DataWarehouse.Adapter runtime error: Microsoft.VisualStudio.Currituck.Server.Common.ValidationException: Invalid object name 'dbo.WorkItemsLatestUsed'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.WorkItemsLatestUsed'. at System.Data.SqlClient.SqlConnection.OnError(SqlEx ...Show All

• Windows Forms Startup Menu SHortcut in setup project.

    I'm just finishing a setup project and I need to have the app shortcut in the users startup menu.. So far I've read that one makes an entry in the application manifest. Where is this file and what is it's name Is this an editable text file and what does the entry look like   Thanks. For setup projets, you need only to add a shortcut to your application inside of the User's Programs Menu folder. This folder is vis ...Show All

• SQL Server compare two text files

  Dear all, What software can compare two text files They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks. Alex Hi Alex, I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free ...Show All

• Visual Basic Visual Basic.net

  Hi, Is there a difference between the VB that comes with Visual Studio 2005 and Visual basic.net, or are they both the same Thanks.....Eric To comment a little further, VS2003 & 2003 had a VB based component called VB.Net. Many VB users didn't like it and delayed our migrations. I was one of them. I thought 2002 and 2003 were REALLY BORING and I stayed with VB6. Nomeclaturally, th ...Show All

• SQL Server Please Help : visual studio 2005 beta 2 + SQL Server 2005 + C#

  Hi, I have the Microsoft.SQL.Server.2005.Enterprise.July.CTP. I have installed it on Windows Server 2003 Enterprise Edition. After installation I found that Microsoft Visual Studio 2005 Beta 2 installed with it , but when I Opent it I can't create C# prject since you can't create anything other than 'Business Intelligence Projects'. I need to write a programs using C# so How can I do that with SQL.Server.2005.Enterprise.July.CTP T ...Show All

• Visual Basic Thread-safe call

  The following gives the error (...does not have the same signature as delegate...) and I am not sure how to solve (being new to thread calls): Private Sub DataReceived( ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived If e.EventType <> IO.Ports.SerialData.Chars Then Exit Sub SerialData = SerialPort1.ReadExisting DisplayThread = Ne ...Show All

• Visual Studio Team System [1.32 BUG] AssembliesShouldHaveValidStrongNames false positive with .NET 2.0 assemblies

  Guys, Not sure if this is a known bug or not, but I'm getting a false positive with the AssembliesShouldHaveValidStrongNames rule when analyzing signed .NET 2.0 assemblies.   I am experiencing this only on the standalone FxCop 1.32 (not Visual Studio 2005 RC) and when using either the AssemblyKeyFileAttribute or using the /keyfile command line option (ie the Projects Properties -> Signing tab). The assembly has n ...Show All

• SQL Server How can I attach database files from outside the local server?

  Hi,all here, I got a problem that I can only attach database files created on my local server, while database files from outside the local server cant be attached. So what is the problem then Thanks a lot in advance for any guidance and help. Which error do you get HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Unable to use Reporting Services

  Hi, After installing Sql server 2005 CTP09, we can neither connect to reporting services trought Management Studio nore to reportserver. Using Management Studion we are getting this message: TITLE: Connect to Server ------------------------------ Cannot connect to XXXXXX. ------------------------------ ADDITIONAL INFORMATION: The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Man ...Show All

• Visual FoxPro Need VFP 9.0 Report Help

  Hi I have a report that in the detail band I have the following info: QTY     Part Number      Description              Price           Extended Price   5       2222-009          5500 Watt 220V &nbs ...Show All

• SQL Server Designing Aggregations

  I have a fairly large partition (100M rows, 30 measures) and am attempting to create aggregations through the Aggregation Design Wizard.  Regardless of the option I select, either percent or file size, the wizard always completes after designing only about 50 aggregtions for 0% and only 200kb.  I cannot believe that to be right.  On a much smaller partition I created about 600 aggregations to 30% for 2GB. I've double check ...Show All