Barry Kwok's Q&A profile

• SQL Server How get table size?

  I am trying to create a report showing the allocated size of each table. How can I obtain the size of each user table and place in my report Thanks! ...Show All

• Windows Forms how to make a splash?

  I have a main_form which is MDI and I am using thios code in its Form_Shown: frmLogin LoginForm = new frmLogin (); LoginForm.ShowDialog(); in order to display a dialog form for login and I want to show a slash until the login form appears.. where in the Form_Shown or the after InitializeComponent() ...Show All

• SQL Server XML Function fails in SQL job?

  I have written a stored proc that pulls a couple pieces of data from an XML column in a table and returns it to another stored proc as a rowset. When I run it straight from the query window, it works perfectly. When I run the exact same EXEC from a SQL job, it fails. Does anyone have any clue why this is This is the portion of the stored proc in question: SELECT @rows = count (*) FROM #tblTextToXml IF @rows > 0 BEGIN set @rs = cursor forward_only static for SELECT 1 , LastRetryDate AS Time_Failed , Cast ( xmlField . query ( 'data(/Request_Troubleshooting/Entitlement_Information/Contract_Number)' ) AS varchar ( 18 )) AS Contract# , Cast ( xmlField . query ( 'data(/Request_Tro ...Show All

• Visual Studio Problems getting the VCCLCompilerTool object!

  Hi I'm writing some (C#) code to modify the compiler settings on a large number of VC++ projectfiles and I'm having trouble getting the VCCLCompilerTool object. My code looks something like this: VCConfiguration CurrentConfig = <some code to get the config> VCCLCompilerTool Compiler = (( IVCCollection )CurrentConfig.Tools).Item( "VCCLCompilerTool" ) as VCCLCompilerTool ; Now, the Item method returns some object, but the cast to VCCLCompilerTool fails. If I change VCCLCompilerTool to VCLinkerTool everything works as expected and I get a VCLinkerTool object. Is there ANY way to figure out what kind of object I'm, actually getting All I can see is a System.__ComObject which is pretty useless... Pe ...Show All

• SQL Server How to exeute dmx query?

  hi, I am using CLR stored procedure having my dmx query.I need to exeute that Query and get the resultset as dataset how to do this Here is my code sample namespace PredictPerformance { class perf { public static dataset getPredict(int StudID) { ---- return ds; } } } Execute the proc: SELECT PredictPerformance.getPredict(1) FROM [Stud_Model] how to get the result Thanks, Karthik. I think you should be able to start SQL studio and select "New DMX query" -Dennis ...Show All

• .NET Development CLR and thread deadlocks

  Hello, I'm hosting the CLR (.NET 2.0) in an unmanaged C++ app. The CLR is used for calling C# plugin functions through IDispatch. The C# plugins are COM visible classes and are created from the app main UI thread. They are mostly used for accessing the app through a COM primary interop assembly generated with TLBIMP.EXE. The interop between C# and the app is achieved through the default Microsoft COM wrappers. This is all working fine but I'm having a problem when the C# functions are called by the app from a worker thread. At this point the CLR attempts to interop with the app via the UI main thread which is causing a deadlock because that thread is locked while the worker thread is executing. From what I see in the call stack (b ...Show All

• Visual Studio Team System Saving attachments

  To save an attachment you have to open it and then save it from within the application that has opened the attachment. In my experiences, IExplorer is always opening the attachments and sometimes failes to do so. For example: opening xml files for which the specified schema can not be found. Also for other file types like .jpg I rather want to save the files than open them in IE. I tried to change the file type associations as explained in http://support.microsoft.com/kb/905703/en-us , but no luck. (What's more, for file types for which I changed the default open-application, the Advanced button is missing in the 'Details for .. extension' dialog. Only after pressing the 'Restore' button I can select 'Advanced' and then check/uncheck 'Conf ...Show All

• SQL Server SSRS Query Performance = pass through, or ?

  When a user creates a query as Datasource in Visual Studio report designer, does it perform as of a pass through from an application ISSRS is integrated with SQL Server, but the queries used by reports are separate and not stored on the server as views or stored procedures. Is it reasonable to assume report query performance is inferior to the same when written as a SP or view on the SQL Server I ask because I the query designer in VS for reports is so convenient but my reports are running slowly. - ISV I was driving along today thinking about this post and wondering whether I could improve report rendering time by using a stored procedure server-side as compared to wherever SSRS hides the queries that are Report Datasets. I know, ...Show All

• .NET Development HELP: Need to write on a network share - but get UnauthorizedAccessException

  Since I now was googleing for hours without any success I hope I will find an answer in here... This is the (simpilfied) scenario: I wrote an application (C#, .NET 2.0) which needs to create and write write some file (more precisely it needs to save an XML document). The application is hostet on a network share and will be excecuted from there. It writes to local drives as well as to network shares. The problem to get the application running from the network share I solved: I signed all assemblys and gave them FullTrust via CAS and an accordingly codegroup. So this works fine. But the problem I now got is that the application is allowed to create files and write on my local file system without any problems - but when it tries to c ...Show All

• SQL Server Identity column not returnd after AddNew / Update with ADO and SQL 2005

  Hi, I add new records to a table with ADO. The tables contain an auto-increment identity column. I want to retrieve the identity value after the insert operation. This works fine for SQL Server 2000. On SQL Server 2005 this only works if I use a table in the select statement. If I use a view in the select statement, ADO returns no value for the identity column, a trace with profiler shows that there is no Select @@IDENTITY statement. What is the reason for this behavior How can I change this behavior in SQL 2005 so that the behavior is the same as in SQL Server 2000 Best regards, George I have encountered this same problem too. Has anyone found a solution It's used in a complex bound fo ...Show All

• SQL Server Very poor performance with lastnonempty aggregation function

  I have a big problem with a measure that has lastnonempty aggregate function. I set up an analysis services 2005 test cube with 4 dimensions and 2 measures. The dimensions are: Time - Year,HalfYear,Quarter,Month,Day - is a time dimension and has 365 members. Product - ProductCategory level - 1500 members - Product level - 60000 members Branch - Region level - 2 members - Branch level - 200 members Customer - Customer level - 1500 The cube has 8 partitions based an month, each partition has between 30000000 rows and 40000000 rows. All partitions use the same custom aggregations. The January partition has 31000000 rows. The measures are: AmountLastnonempty - lastnonempty aggregate function Amoun ...Show All

• Visual Studio 2008 (Pre-release) Recovering from Faulted State?

  Hi, We have hosted our WCF Service as a Windows Service. What is happening that once it goes into faulted state, we have to restart the service. This will not be possible in production. Can someone help me in finding out a permanent solution to handle this. Thanks, Akhil Jindal You cannot recover from the Faulted state. The only thing you can do with a service that has faulted is close it. The service is an ICommunicationObject and this blog entry has a brief explanation of the states an ICommunicationObject goes through. ...Show All

• Windows Forms Need help with a deployment.

  I would like to first say thank-you in advance for any help you may provide here. I am not sure if this is the proper location to post this but... How do I get the MSinstaller to remove a previous version of an application and install the latest version without adding additional application listings in the registry The project details are below. Using Visual Studio 2005 I am working with a C# non web solution using the single solution model, the solution has multiple project components that are ultimatly built into an msi file that utilizes a bootstrapper setup.exe with dependencies of .Net and SQL Server 2005 Express. Below are the Properties settings for the deployment. Setup:Deployment Project Propertie ...Show All

• Software Development for Windows Vista Exciting Possibilities.

  Hi everyone! I have only just discovered Workflow Foundation and it seems very exciting to me. I would like to ask the wise heads of this forum how to tackle my application. I am developing an IVR (Voice XML) development tool, and would like to use Workflow Foundation (if it makes sense to do so), so it would need to be hosted outside Visual Studio. The application will allow a user to drag an drop activities and behind the scenes the VXML code will be created (so I don't think I need to generate CS or VB code). Also, I don't have any intention of trying to run the VXML in my application, it simply is a creation / editing tool. A very basic IVR script could look like: New Call -> Play Welcome Message (wav file) -> Play Menu Options - ...Show All

• Windows Forms Need to get the .MainWindowHandle

  I am trying to get the mainWindowHandle and store it for later; however, i can not seem to get the handle back from the new process. Before someone suggest , i will let you know that i have also tried the p.WaitForInputIdle(); however, this not only does not work it will throw and error..   private IntPtr mainHandle = IntPtr .Zero; private void button1_Click( object sender, EventArgs e) { Process p = new Process (); ProcessStartInfo ps = new ProcessStartInfo (); ps.FileName = "explorer.exe" ; ps.Arguments = "" ; p.StartInfo = ps; p.Start(); mainHandle = p.MainWindowHandle; } Can someone tell me how to get the mainWindowHandle   Erik Sorry, I guess I was focusing on y ...Show All