Jim P.'s Q&A profile

• SQL Server Lock in FTS

  Hello, There are some king of lock that stop my search process over a FTS table indOfertaCliente. The Query: SELECT TOP 1 * FROM indOfertacliente Works fine...but SELECT * FROM CONTAINSTABLE ( dbo . indOfertaCliente , (*), 'polar' , LANGUAGE 3082 , 1 ) returns timeout. Also i receive timeout when i try to disable de FTS index over the table. Which resource can be locked Where can i see it Sql 2005. SP1 Tahnks in advance ...Show All

• .NET Development AppVerifier errors understanding

  Hi, I'm trying to make an application pass the AppVerifier test, but I don't understand the resulting error messages. Perhaps someone can help me to understand the error, or even better, to debug it :) Here is the XML : - < avrf:logfile xmlns:avrf =" Application Verifier " > - < avrf:logSession TimeStarted =" 2007-01-26 : 16:51:44 " PID =" 5404 " Version =" 2 " > - < avrf:logEntry Time =" 2007-01-26 : 16:52:06 " LayerName =" Locks " StopCode =" 0x209 " Severity =" Error " > < avrf:message > Critical section over-released or corrupted ...Show All

• SQL Server Sorting makes table invisible

  I have a table which visibility can be toggled by a text box. By default it is invisible. After it is made visible, clicking a sortable column header makes the table invisible. Does this mean sorting makes the table go back to its default visibility Clicking the interactive sort image triggers a re-processing of the report that reverts the toggleable table back to its original visibility state. This is currently by design, but we recognize that this is not desired behavior. We are evaluating the feasibility of changing this in a future release. -Chris ...Show All

• .NET Development With TableAdapters can I get the connection string from a custom method instead of using the app.config file?

  Hello, Is there a way to have the TableAdapter get the connection string from a custom method instead of using the app.config file (and still have the QueryBuilder in the XSD designer work) We are using Typed DataSets and TableAdapters in .NET 2.0. Instead of using the App.Config file we have our own method which returns the connection string. So, I can programmatically say something like: myAdapter.Connection = new SqlConnection(Config.GetConnectionString()); And the code will work just fine (but not the XSD designer). So, there are 2 issues. 1) We have to set the connection every time we create an adapter or we will get a runtime error (I could live with a compile time error, but ...Show All

• SQL Server searching by regular expression in SQL statements?

  Do anybody know SQL server supports regular expression matches in SQL statements ie, contains() and matches() are XPATH standard functions but it seems only contains() works in SQL server, e.g. create table TSTTAB ( recid varchar ( 10 ), xmlrec XML ); insert into TSTTAB values ( '01' , '<row><c1>01test</c1></row>' ); insert into TSTTAB values ( '02' , '<row><c1>02test</c1></row>' ); select recid from TSTTAB where xmlrec . exist ( '/row/c1[contains(.,"test")]' )= 1 worked fine. but matches() complained an error: select recid from TSTTAB where xmlrec . exist ( '/row/c1[matches(.,"test")]' )= 1 ; Msg 2395, Level 16, State 1, ...Show All

• Software Development for Windows Vista Project type is not supported by this installation

  I have been struggling with this the entire day. I just installed for the first time: WinFX Visual Studio 2005 Extensions for Windows Workflow Foundation Beta 2_2 Windows Workflow Foundation Runtime Components Beta 2_2(EN) for x86 WorkflowTemplates - 2006-03-07 If I try to create any WWF project based on the new templates, I receive an error stating that "the project type is not supported by this installation". I have uninstalled everything and installed the Beta 2 version (instead of the Beta 2.2) and I get the same error. I then uninstalled everything again and reinstalled the Beta 2.2 version hoping that it would have worked, but no luck. Has anybody had this problem Any help will be appreciated. P.S. ...Show All

• SQL Server Excel Connection Manager and expressions

  Hello, I have a question regarding which expressions need to be set to have the excel connection manager be able to create/update a file dynamically. I'm reading a path in from a database and storing it in a variable. The path is just the location of an excel file. What I would like to have happen is that the excel connection manager be dynamic so that if I wanted to change where this file went or the name I could simply change the value in the database. I've tried setting the expressions, in the Excel connection Manager: ConnectionString,ExcelFilePath, and Servername to the variable \\path\folder\file.xls with no luck. The ConnectionString seems to be a little funny because it contains Provider=Microsoft.Jet.OLEDB.4.0;Data sourc ...Show All

• Visual C# HttpException:"Cannot have multiple items selected in a DropDownList"

  I am using a DropDownList on my webpage. I have populated it from Database by using DataBind() method after providing him binding informaion. It works fine. But when ever i try to select an item by code. it generates the HttpException with message "Cannot have multiple items selected in a DropDownList". Few things: I am not doing post back, this exceptoin occurs on very first call. I am not selecing more then one values. I have also tried with by calling ClearSelection() before selecting an item. I have tried with multiple ways and i got the same error in every case. by usign .SelectedIndex by using .Text by using .SelectedItem by using .SelectedValue I had debug the c ...Show All

• SQL Server How to stop running DTS package if my view return zero record?

  Hi everyone, I've created a DTS package runs on every day and night, but now my boss was asking if I can insert an exception code to check the view file. So.. I need help from you guys, cause I don't know How. This is my DTS description. My DB will generate a view called "Calls to Add", then it will run the Transform Data Task and insert into a txt file. once it finished, it will run the Batch file. that is it. Now My boss wants me to add a checking code between "View to Txt" procedure. If the view has no record inside, than the DTS package should stop and not run. BUT How Can someone please help Thanks OK. here's another idea....slightly different from Phil's. Give it a shot. (using ...Show All

• SQL Server run openquery(mdx) through a linked server

  Hi, I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error: OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.". Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING". And, I am sure that I have made the MSOLAP provider Allow inprocess. What can i do for this. Ple ...Show All

• SQL Server The Device is not ready error when Executing package on the server

  Hi, I have a package which reads an XML file from a certain folder and parses it. I deployed my package onto the server. Copied XML files on the D:\ drive the following folder on the server. Dim reader As New Xml.XmlTextReader( "D:\Apps\Request\Clients\ClientsStatus.xml" ) is fine. But Do While (reader.Read()) generates "The Device is not ready" I think it is still trying to read it from my desktop on which I don't have a D drive. Any help is appreciated.       Jennifer LaMacchia wrote: Yes, the UNC will not work either, that's why I mapped the drive. What user is the SQL Server running as Likely, that user does not have acc ...Show All

• SQL Server SQL Server Management Studio and Visual SourceSafe

  The develpment team where I work is using Visual Studio 2005, SQL Server 2005 and Team Fundation Server. We want to somehow track changes of the stored procedures. We could create a Solution/Project in the SQL Server Management Studio, add all stored procedures to it and add that Solution/Project to the SourceSafe but nothing will stop developers from directly altering stored procedures. Any ideas on how to prevent developers from making changes to the stored procedures directly Thanks. in SQL Server management studio, 1. right click on any specific stored procedures that you want to set restriction on. 2. Select property 3. Under "Select a page" pane, select "Permissions". And you can setup v ...Show All

• Smart Device Development DataBinding - OnValidation - Failure to fire - Not Firing - Bug? - Incorrect Usage?

  Hi all, Thanks for reading...   I've got a databound textbox which is bound to a property on a "business object". I've set the databinding mode to OnValidation (In the properties window (whilst my textbox is selected>>Expand '(Databindings)' node>>Select the sub-node '(Advanced)'>> click on the '...' button>>set Data Source Update Mode to 'OnValidation' - sorry if that looks like I'm teaching you how to suck eggs. :-) ). Ok. Now, I load the application, the form appears with the databound textbox empty (which is how it should be). I then enter "hello world" into the textbox, this then results in firing the events 'Validating' and 'Validated' (like I expect) - the databinding auto ...Show All

• Visual Studio 2008 (Pre-release) How to debug deserialization errors?

  I've got a service running under a Windows Service, using netTcp, under Beta 2/May. I'm trying to send a parameter that's defined like this: [ Serializable ] public class Container { private byte[] m_Data; public byte[] Data { get {...} set {...} } private Descriptor m_Descriptor; public Descriptor Descriptor { get {...} set {...} } } The get/set methods are simple accessors, and the Descriptor is a simple class, also marked as [Serializable], that has several string, int and Enum members. Usually my call, which sends an array of Containers to the service, works without a problem. Sometimes, though, I get this FaultException on the client: The formatter threw an exception while trying to deserialize the message ...Show All

• Silverlight (formerly WPF/E) News: "WPF/E" Feb 2007 CTP is Live!

    Earlier today, you may have noticed your “WPF/E” December Community Technology Preview (CTP) control expired.  No worries though- we’ve just posted the February CTP for Windows and Mac  to Microsoft's download center and updated the samples on the Channel 9 Playground to work with the new CTP.  Note that to get your samples working with the February CTP, you’ll need to change out the agHost.js file with the new one found here . Tomorrow we’ll update the website with details on what’s new in this release, and an updated SDK and samples will be available soon too. Thanks, "WPF/E" Marketing Correct link to download the aghost file is: http://channel9.msdn.com/playground/wpfe/pageturn/js/ ...Show All