Hans1982's Q&A profile

• SQL Server The scripts in the store procedure run slowly, but quickly when executing in the Query Analyzer

  Hi, When i call the procedure sp_jysczld_new from the Query Analyzer, it runs slowly. But when i extract the sql scripts from the procedure sp_jysczld_new, it runs quickly. Why I don't understand. store procedure sp_jysczld_new: -------------------------------------------------- SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE  PROCEDURE sp_jysczld_new @gs_userid CHAR(16), @location char(10), @pri char (10) AS SELECT Z.ORDER_NUM,ZI.ORDER_ITEM,Z.CUSTOM_ID,ZI.PRODUCT_ID,ZI.PRODUCT_NAME, ZI.LENGTH,ZI.CDGC,ZI.HEIGHT,ZI.L_HEIGHT,ZI.U_HEIGHT,ZI.CATEGORY,ZI.COLOR_ID,ZI.SGQTYS,ZI.plannum, ZI.totalwgt,        ZI.banglong,ZI.bangzs,ZI.qgzs ,ZI.BANG_GRADE,ZI.PRI, ZI.LOCATION,Z.END_DATE, ZI.NOTE ...Show All

• Visual Studio Team System SP1 - confusion in my mind

  On http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx I find mentioned two service packs 1. Visual Studio 2005 SP1 (includes SP1 updates for Standard, Professional, and Team Editions of Visual Studio 2005) 2. Visual Studio 2005 Team Foundation Server SP1 I was talking to a developer and asked if he had installed TFS SP1 (#2) on his client box. He replied that is was not necessary because he had installed Visual Studio 2005 SP1 (#1). Is TFS service pack (#2) included in the Visual Studio SP (#1) TIA, barkingdog The TFS service pack (#2) is only for the server piece of TFS The service pack (#1) is for the client versions including Team Explorer. If y ...Show All

• Visual Basic Menustrip shows up as gray rectangle on some computers

  I have created a small application that uses a MenuStrip in VB.net 2005. This menu attaches itself to a specific application running on the users computer and gives printing options. On one computer, this menu shows up as just a gray rectangle, there is no text and the menu does not drop down. This is a Win 2000 machine. Other Win 2K machines are OK. Anyone have any ideas Thanks. We got it! - the user had their display properties set to 'Red White and Blue <VGA>'. We reset them to 'Windows Standard' and if fixed it. ...Show All

• SQL Server Restore Master database to SQLExpress

  Hello, I have a fresh install of sqlExpress and Management Studio Express on my test server. I want to restore my master database from backup. From the command prompt I set the Sqlservr -s SQLEXPRESS -m Then I opened another comand prompt and ran my SQLCMD script to restore the Master Database. here is the sql script: RESTORE DATABASE [Master] FROM DISK = N'E:\COPLEYNEWSDATABASEBACKUP\Master.bak' WITH FILE = 1, MOVE N'mastlog' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Master_1.ldf', NOUNLOAD, STATS = 10 GO I recieve the following error. Msg 3154, Level 16, State 4, Server COPLEYNEWS\SQLEXPRESS, Line 1 The backup set holds a backup of a database other than the existing 'Master' dat abase. Msg 3013, Level ...Show All

• Windows Forms DatePicker

  Hello I need datepicker in one column of DataGridView with NULL date ability. Do you know where can I get it Thanks Yosef Hi take a look at http://www.rustemsoft.com/DataGridViewColumns.htm http://www.sharewareconnection.com/titles/datagridview-combobox.htm Hope this helps you out, please close the thread if it does ...Show All

• SQL Server Should IsSorted metadata be stored in raw files

  Hello, I have an input into a raw file destination that has IsSorted=TRUE. Any output from a raw file source that uses that raw file will have IsSorted=FALSE.   So, a question for Microsoft. Is it a legitimate request to ask that the IsSorted and SortKey metadata be stored in a raw file If so I shall raise it at Connect. -Jamie   Hiya Jeff, Jeff Bernhardt wrote: hmm. must have missed those. not that it helps you too much Jamie, but the IsSorted metadata was added to the pipeline late in development, after the raw files (and the tests for the raw files) were written. Fair enough! Jeff Bernhardt wrote: as ...Show All

• Visual Basic Dataset designer compiler crash

  Help! I am having a problem with the dataset designer in vs2005 that causes a compiler crash. Things were going fine until I made some modifications, first to the underlying database (added new fields to a table), then modifying the corresponding tableAdapter's query to cater for the database mods. After the mods to the dataset designer, the compiler crashes on every re-build. This problem occured before in the early development stage of the project and the only way I could come up with to fix it was to create a new dataset in the designer from scratch. This is ofcourse becoming an increasingly unviable remedy. Some addition details that may be helpful I am using a system DSN in the connectionstring to the database and In ...Show All

• Windows Forms TableLayoutPanel Inserting row

  I've set up a tablelayoutpanel, and can insert rows at the bottom of the table as such: lowestRow = 0; chk = new CheckBox(); // add chk checkbox into column 0, in the bottom row tableLayoutPanel1.Controls.Add(chk,0,lowestRow); but would like to be able to insert into the middle of the table (eg. add items above other items), which would require the rest of the rows to be shifted down. Any help would be greatly appreciated! Sam Hi Wang, The code i've written does work, but when i try to insert in lowestrow - 1 or row 0 it's just a mess. I think because I'm trying to insert a whole row of items, the first .Add is shifting the already existing items across one tableLayoutPanel1.Controls.Add(chk, 0, lowestRow); table ...Show All

• .NET Development Logging WEB Service

  Hello. I am using Web Service with C# .NET application as a client and JAVA Enterprise over JBoss Application server as a server. I'd like to log all traffic of the web service using standard diagnostic mechanism of the .NET. I know to trigger it for tcp and http communication, although it prints a lot of information. The way to do it well documented in the MSDN. My question is what is a way to do it for Web service communication If there is no "standard" way can anybody suggest the shortest implementation path P.S. Please do not advice to take Application logging block or Log4Net 3rd party library. I do not have a time and wish to add into my application a huge chunk of code for this small task. Thank you. I was asking abo ...Show All

• Visual C++ WaitForMultipleObjects doesn't work

  Hello Everyone! Function WaitForMultipleObjects Requirements: Requires Windows Vista, Windows XP, Windows 2000 Professional, Windows NT Workstation, Windows Me, Windows 98, or Windows 95. But this function doesn't work in WinNT. Why Thanks in advance Vladimir GetLastError after CreateWaitableTimer and SetWaitableTimer returns 0. And, as I already told, in WinXp everything is fine, code works, but in WinNT I have problems and can not understand, why ...Show All

• Windows Search Technologies Windows desktop search stopped working after Office 2007

  After I installed office 2007 into XP Pro 64bit, I can no longer use windows desktop search. When I open the search function I get a blank window. If I use the smal Icon on the task bar a dialog says "This app...because MAPI32.dll was not found. Re-installing..." Re-installing what app Office 2007 Can you go to your event logs and see what kind of errors you are getting How about WDS status does it say any indexed items You might want to try uninstalling your WDS and installing it again. Make sure that you are installing the right version of WDS for your machine and let me know. ...Show All

• Visual Studio Visual Studio 2005 Service Pack 1 Beta

  I would like to know exactly what “ Visual Studio 2005 Service Pack 1 Beta” updates. Most importantly does it update the framework If someone could point me in the direction of a specification I would be most grateful. There is no exact specification of what the service pack contains for all products to which it updates. As Ahmedilyas mentioned, it doesn't update the .NET framework and therefore does not update C#, VB.NET, JScript, or J# compilers. The service pack's release notes list some of the bug fixes and the C++ and TFS teams have posted some of changes that have gone into the service pack here: http://blogs.msdn.com/vcblog/archive/2006/06/22/643325.aspx , http://blogs.msdn.com/robcaron/archiv ...Show All

• Visual Studio September CTP?

  Anyone have any idea as to when the Sept CTP will be released Thanks John jhidey, I don't know for sure, but I think RTW means Release To Web (whereas RTM implies that media is released and RTW is just a download). ...Show All

• Visual Studio Express Editions System.Net.ConnectStream?

  I am new to .NET and have been going through the video series for beginning C#. I am working on the RSS reader that is the project. I have been researching the Classes and Methods that connect to the internet. I have used the MSDN and Object browser to learn about the items being used. I am at the point where a System.Net.ConnectStream object is being returned from the HttpWebResponse.GetResponseStream() method. I have tried to find documentation about this object. It does not show up in the object browser or the MSDN (local or online). I have searched and only found problems where this object was referenced but not documented or explained. <p>A ConnectStream is a Stream and should be treated as one. You can use the StreamReader ...Show All

• SQL Server Remote Source and Destination Performance

  Given the following scenario, what kind of performance should be expected in transferring about half a million rows We are seeing about a 9 minute execution time. Is this reasonable for about 460,000 records moving from source to target, with 3 inner joins from the source Source: Server A.OLTPDB Target: ServerA.DataMartDB Server A is running SQL Server 2000. SSIS is running on a different machine, Server B. The reason for this is that we are distributing the SSIS package for use with a BI product built on SSAS 2005 and the requirements are such that the client could very well have the source OLTP database on a different physical machine than the data mart. My understanding is therefore that: 1. SSIS will do all of the hea ...Show All