Search results for query: *

Hi, I'm trying to do the equilivant to a Like or Wildcard search ( '*FRED*' to find any node containing FRED ) on the values in the nodes of an XML document. I've looked at XPath and XQuery and don't seem to be able to do this. Is this the case or is there a way of doing it. Thanks in advance...

Hi Everyone, Ihave a problem with an application that creates a web site on IIS. The problem is that if the user of the app has local admin permissions on the server everything works fine site created etc. But if I just move them out of the Admin group into a new group that has the same NTFS...

Hi Everyone, Ihave a problem with an application that creates a web site on IIS. The problem is that if the user of the app has local admin permissions on the server everything works fine site created etc. But if I just move them out of the Admin group into a new group that has the same NTFS...

Hi, I've currently got a problem with a DTS Package. I have a Data Source which is a stored proedure (that returns a resultset) which goes through a transfermation (just copying the field) to a Text file as the Destination. The stored procedure works fine in SQL analyser and as a SQL Task in...

Hi Everyone, I'm getting the above error message for the following code: DataSet lds_Data = new DataSet(); OracleConnection lo_Conn = new OracleConnection("Data Source=xxxx; User ID=xxxx; Password=xxxx"); string ls_SQL = ""; // Build the SQL Statement ls_SQL = "SELECT *...

Hi There, I have a WinForms app that links to a set of Doc Management Web Services. My problem is this I get back from the Web Service the MIME Type so that I can activate the relevant application. But I can't seem to find a way of find and starting the correct application. Thanks in advance...

Hi, Go a problem at the present with an import application which resides on the Application Server. This app needs to be run everyday, if certain errors occur I want it to reschedule for a specific time. Instead of writing the scheduling into the application I want to use the scheduler in SQL...

Hi, New to Visio Prof (2002 sp 1). In previous data modelling tools I've used there is the ablity to generate the ddl for the physical database model. My question is how do I do this in Visio. I've tried the Help an this seems only to look at entering code into the model sp, function, etc. And...

Hi, I'm trying to validate some data input into a grid. One of the fields contains an image. Does anyone know how I can tell if the cell has a picture in it or not. Many Thanks in Advance Andy (LokiDBA)

Hi, I'm writing a stored proc that calls the bcp or textcopy commands. Both of these utilities require a password as a parameter. In Oracle I can specify an Session variable that passes the current sessions password to a application without it being seen. Does anyone know if there is the same...

Is there any way in a stored procedure to catch a system error message ie Column cannot be null and replace it with a friendly error message. Thanks in Advance LokiDBA

Hi, I'm having a problem with getting a COM component which I'm trying to run on Multiple threads. I have a single class whihc wraps the COM component. I then create a number instances of this class and then run the required COM method on the a number of separatly created threads. I.E there...

Hi, I'm currently building a utility stored proc that is to output the results of a SQL statement or a stored procedure to a file. The problem I have is parsing the SQL statement. In Oracle I'd just call the DBMS_SQL.Parse function. Is there something similiar is SQL Server 2000 or will I...

Hi, Does anyone know how to stop the pressing of the backspace key behaving like the Back button on the browser. Clausing lots of problems on the Site. Thanks in Advance LokiDBA

Hi I'm looking for the best or a workable strategy for using SourceSafe in the following situation: We have a product that has a base architecture (Class library) considing of COM objects, ASP pages, XSL and XML templates. Off this are a number of sub products are developed that combine into...

Hi, I have a stored procedure that is used through-out my database, but I need to use its resultset as part of a query to generate an upload table. Is there any way I can use this result set as part of a SELECT statement. For Example SELECT Name FROM sp_Help Any one got any ideas...

Does anyone know where I can get information about writing a plugin application, like Visual Perl, XSLT, etc for Visual Studio .NET. I've been searching through the knowledge base and MSDN but there seems to be nothing there. I know it can be done, do you need to be a member of on of the...

Does anyone know where I can get information about writing a plugin application, like Visual Perl, XSLT, etc for Visual Studio .NET. I've been searching through the knowledge base and MSDN but there seems to be nothing there. I know it can be done, do you need to be a member of on of the...

I'm trying to find out if this is possible. Can you have SourceSafe repository on SQLServer instead of its native database. We are having problems with the database being locked, so it does not get backed up and we were wondering whether we could start again with SQLServer as the back end...

Hi, We keep getting the Unknown Token error message when we run a large stored procedure either through Query Analyser or SQL Agent. I've looked in Books On-line and it says see the error log which has not details concerning this error. Any ideas Thanks in Advance LokiDBA