Recent content by yeagly21

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...

Denny, Thanks for the reply. Our IT guy removed the database ldf and mdf files by mistake. How this was accomplished I am not sure but he did it. We detached the database and then restored it from a back up. Thanks Again for the assistance. Yeagly

Thanks for the response. I am able to see the database in the Connectivity Admin section. However when I go into SQLConsole it cannot connect to the database. I have looked into the auto conversion that you are referring to however I have not been able to find anything very helpful. Do you...

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...

This is what I ended up creating to give me the result set. I ran it in Management Studio and ran the query to text. Its not the most efficient method so if anyone has a better way to do this that would be great to know. DECLARE @ProcDefinition VARCHAR(MAX),@ProcName VARCHAR(8000) Declare...

I am looking at it right now to see if I can adjust the script to give me that results i am looking for.

Paul - I am looking to script the Table triggers. Sorry I should have included that info.

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

Thanks Paul that was exactly what I was looking for.

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...

Thanks guys that worked great

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...

Silly - I don't think the movefirst call will work when looking at a Tabledef. What you might want to do is look at using recordsets. Below is the CheckSerial snippet in recordsets. Private Sub CheckSerial() Dim rstSerial As DAO.Recordset Dim rstID As DAO.Recordset...

Try Changing the Below: Called Procedure:::: Private Sub CheckSerial() <-------- TO: Called Procedure:::: Public Sub CheckSerial() <-------- --Yeagly21