joynerCN's Q&A profile

• SQL Server get file names from folder

  Is it possible to write a TSQL statement to obtain the a list of files located in a specified directory Also, if this is possible what additional information can be retrieved - in particular i'd like file size, author and date created (though I'd settle for just the file name). Thanks You can create a CLR FUNCTION that can be used in T-SQL code. See: Function -SQL CLR to Return File List C# - http://blogs.msdn.com/stuartpa/archive/2005/07/21/441468.aspx VB - http://blogs.msdn.com/sqlclr/archive/2005/05/20/420623.aspx ...Show All

• .NET Development .Net Remoting-Server Callback Its Clients By Initiative Way

  If the clients and server are in the same LAN，server can callback any client by a media which is also derived from MarshalBayRef Class,in which there is a delegate that poits to client's callback function. But my problem is that if the clients and server are in different LAN,in which the server can ping any client but each client can't ping the server.I've done lots of xperiments,that kind of callback method does not work! Do you have any good ideas to solve this problem Thank you in advance! .Net Remoting does not provide support for this specific scenario; a common pattern is to setup a broker that can be contacted by the server and can contact the clients. The server would only communicate with the clients thr ...Show All

• Architecture Why return a Success boolean from a web service?

  Jeromy Carriere's MSDN Webcast: Patterns and Anti-Patterns in SOA critiques web services implemented as a Sub (void method), with no indication of success returned. I don't understand why we would want the clutter of in-line checking for success. There's no end to it once you start down this path -- instead, why not catch exceptions thrown by the web method It seems even if you call a method asynchronously, your callback method should catch exceptions and raise them in the usual manner; otherwise, just code for the "happy path" and keep it readable. Now that we have exception support, shouldn't the 80's style manner of in-line error-checking be discarded Thanks. It's all an issue of encapsulation / contracts. Would yo ...Show All

• Visual Studio Express Editions compiling C++ program

  Hi, I would like to know if your project has more than one file if you could compile and run each of them independently. Help is appreciated, Bentsi Dain. Hi, compile: yes. Rightclick the c/cpp file and choose Compile run: no. You just get an obj file which has still to be linked with its dependencies into an exe. -- SvenC ...Show All

• SQL Server Problem with multi-valued parameters since SP1

  Hi, after the installation of SP1 I have a problem with multi-valued report parameters. The option to select all values are gone. Is there a bug within SP1 Before the installtion of SP1 multi-valued report parameters works fine, the option to select all values was added automatically within the preview in Visual Studio 2005 and in published reports on the server. The server was migrated from SQL2000 SP4 to SQL2005. So long Lemmi Hello Robert.  This is really a bummer.  I have just converted over to RS 2005 (from 2000) and implemented multi-select parameters in 15+ reports.  The select all option was a great option.  Something my end users would really use and like.  No ...Show All

• .NET Development Problem while processing XML from Unix hosted web service

  Hi there we need to write web service client in VS2005. For quickstart ".NET WebService Studio 2.0" was used to check the exposed web service. Upon invoking mpayment/getQuote (which has two inputs: in0 and in1) WSS2.0 always throws an exception. Sometimes its exception like this: ************** Exception Text ************** System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Xml.XmlException: Data at the root level is invalid . Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String arg) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocu ...Show All

• Visual Studio Express Editions Can't install Visual C++ 2005 Express

  Everything was fine when the installation just stopped and doesn't want to continue: http://img312.imageshack.us/img312/4356/errorex7.jpg When I look at the logfiles it seem to fail on the .NET 2.0 install. Be sure to install as administrator and avoid running antivirus software and similar that might want to check files while you install. Make sure you have windows installer installed http://www.microsoft.com/downloads/details.aspx familyid=889482fc-5f56-4a38-b838-de776fd4138c&displaylang=en Try to install .NET separatly, either from windows update or download http://www.microsoft.com/downloads/details.aspx FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en Did you have any VS2005 or .NET 2.0 betas in ...Show All

• Visual Studio Tools for Office how to insert an image into word 2003 table cell

  How do you insert an image into a table cell in a word document I have the following code that opens a word file and accesses the table. object filename = @"c:\template.doc"; object readOnly = false; object isVisible = false; object missing = System.Reflection.Missing.Value; Microsoft.Office.Interop.Word.ApplicationClass WordApp = new ApplicationClass(); Microsoft.Office.Interop.Word.Document aDoc = WordApp.Documents.Open(ref filename, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ...Show All

• SQL Server RS2k5: Sum(field,scope??) problem

  Hello, I have problem with aggregation methods in RS 2005. I have a query thar returns data set: Department, Storage, Article, Invoice, Quantity, Value, ValueX 3, 1,'Art A' ,'Inv 1',2,30, 5 3, 1,'Art B' ,'Inv 1',4,40, 7 3, 1,'Art A' ,'Inv 2',1,15, 5 3, 1, 'Art B' ,'Inv 2',2,20, 7 3, 2,'Art A' ,'Inv 3',1,18, 3 3, 2,'Art B' ,'Inv 3',2,16, 4 ValueX - this is value returned by UDF. It is unique for every "Article & Storage group". In RS my report looks like this: (grpDepartment) Department, Sum(Quantity), Sum(Value), Sum(ValueX, scope ) (grpStorage) +Storage, Sum(Quantity), Sum(Value), Sum(ValueX, scope ) (grpArticle) ++Article, Sum(Quantity), Sum(Value), ValueX ...Show All

• SQL Server Reporting services and access

  Hi There, I am hoping this is an easy answer as I am not too familiar with reporting services. We have a report in reporting services and we need to give full user access to a couple of peoplefor just the one report and nothing else(the usual care taker is on holidays). I have looked all around at the security links and only see the administrators setup there, however I know that there has been access setup for other individual users, for the purposes of just running the report. can you please let me know how to go about this Thanks, Rhonda Hi, navigate to the properties of the Report > Security. Assign all users which should have access to the report to the Report Browser group. Thats ...Show All

• SQL Server Updating non-clustered index

  Scenario: SQL Server 2000 SP4. A simple table with 2 columns: Column1 is an INT, clustered index Column2 is an INT, non-clustered index. Insert some rows into the table. You want to update one row in Column2: UPDATE [whatevertable] SET Column2=1234 where Column2=0. Assume one row is affected. Question: Why should the above update involve updating the clustered index (look at the suggested query plan) - I actually thought this simple operation would not involve the clustered index, at least as long as page splits are left out of this little exercise. I hope someone can shed some light on this. Thanks Henrik Simply put, the clustered index rows contain all columns from the table; i.e. the leaf level nodes of the b-tree are the d ...Show All

• Visual Basic Autoinserting ()

  On my main code page in the IDE - everytime I press a key it autoinserts a ( ). Example keypress  - D Shows - D( ) keypress - i shows D(i) keypress - m Shows D(i)m and any further keypresses just backspaces and refuses to let me key anything in. What did I do to cause this and what can I do to stop it   Please Help! Dean If its been available for some time - shouldn't it be in the service pack that was just released Just a thought Dean ...Show All

• Visual Studio 2008 (Pre-release) LINQ to SQL Feature Request: Automatic generation of temporary Stored Procedures based on LINQ to SQL statements

  Hi,   I would like to see a feature in LINQ to SQL, where we can group a set of LINQ to SQL statements into an object, which could be converted into a code by compiler that creates a temporary stored procedure in the target database. This way we could run a single or set of LINQ to SQL statements as stored procedures and get the benefits of stored procedures like eliminating round tripping to database, pre-compiled queries, etc. At the same time we will not be dealing with permenant stored procedures.   This technique will have all the benefits of writing stored procedures in C# and being executed inside database, which is a perfect world when compared to straight LINQ to SQL queries and TSQL based stored pr ...Show All

• SQL Server "Select All" error for SP2

  i just installed sp2, running reports off of cubes. when the "Select All" is clicked for a parameter i keep getting the following error. the parameter in question are set to multi-valued, strings. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'DimHierarchySnapshotSeasonDesc1'. (rsErrorExecutingCommand) Query (1, 501) The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated. is there a way to take out the "Select All" option or correct the error Thanks, k ...Show All

• .NET Development Who is using the webservice with certificates?

  Hello, I'm working on a project with client authenticate through 509 certificates. But I would like to know on runtime the user that is using the service. I've gone through all the documentation but I haven't been able to find anything. Because the reply of the service is different dependding on the user. Does anybody have any idea how to do it Thank you! The code in the article below will show you how to accomplish it http://msdn2.microsoft.com/en-us/library/ms996950.aspx ...Show All