Search results for query: *

Good Day All - I am in the process of creating an xml file via a stored procedure and I am wondering what are some of the best methods to doing this. I currently have three main nodes of information Node A, Node B and Node C. Forgive me if the terminology is not correct. What I am trying...

Good Day - I am trying to get a client's SQLBase database to open using the SQLBase 11.0.1. The issue I am running into in SQLTalk when trying to connect I get this error message 00401 DBA COD Cannot open database. I have also seen cannot open log file as well as something like invalid...

Good Day. I was in the process of restoring database B using database A using SQL 2005. The issue I ran into was a power surge that turned my machine off. Which has now put database A in restoring mode. I have tried to run the RESTORE DATABASE A WITH RECOVERY and it is telling me that...

Does anyone know how to script just triggers out of a SQL 2005 database?

So I am running into a problem trying to create a delete script. The below error is what I am receiving: DELETE statement conflicted with COLUMN SAME TABLE REFERENCE constraint What I have noticed is that two fields within this TableA, one being the Primary Key, are set up to be constraints...

I am tyring to figure out how I can run the same query against all databases on the server at one time. I have over 100 databases on this server and I figure there has to be an easy way to run this simple query on all of the databases. For simplicity we will say the query is: SELECT Job_ID...

Hello All, below is some javascript that I am currently running in an ASP application. I continue to get a runtime error saying expected ; near my return statement. Can anyone see what it might be. Thanks in advance. if (intSlots[j] == "1") { if (document.dentry.alertGiven.value == "n")...

I am having trouble running the code listed below in a dll that I am calling from ASP. Can anyone see what I could be missing. This code runs fine in a Standard VB6 exe. Any suggestions would be very helpful. Dim Word If Dir(dstTXTfile) <> "" Then Kill dstTXTfile End If...

I am having trouble running the code listed below in a dll that I am calling from ASP. Can anyone see what I could be missing. I am using the Microsoft Office Object 10.0 Reference as well as the Microsoft Word Object 10.0 reference. Any suggestions would be very helpful. Also note that this...

I may just be having one of those days, but I am trying to run this code in a Crystal Report to set an UnBound field = to the below statement. WhileReadingRecords; {@UnboundCurrency2} * {@UnboundCurrency1}; I keep getting the error message "A number is required here" while it is highlighting...

I have an ADP on an user's system that is connected to a SQL Server 2000 DB. User A runs a report in the application and the report displays without any issue. User B tries to run the report but get a sp_Example is missing. The interesting part is when the user opens the database window of the...

I am trying to run a report in a VB6 application. The report calls an ODBC Data Source. But when I try and run the report I receive this error message. &quot;Unable to Load Query Builder Component&quot;. When I run the report on my development machine it runs great but on the client machine...