Search results for query: *

Hi Terry, The log file shrunk to 1MB after I performed the "backup with truncate_only"? I am not getting the same message ("All logical log files are in use"). Prior to my post on here, I tried the full Veritas back-up and the log back-up method, but neither effected the size...

Thank you very much, Terry, for your prompt and helpful reply. The Backup log with truncate_only then shrinkfile worked perfectly. I did see the FAQ that you mentioned which was informative, but I am still having difficulty understanding the 'Active portion' of the transaction log. What am I...

Hi Everyone, I am running SQL Server which is backed up nightly using a veritas backup exec full database backup. One of my transaction logs has grown to 5GB and I was hoping to truncate it for now and also figure out a system for it to truncate itself in the future. I have tried dbcc shrinkfile...

Try aliasing the table: Select a.field1, a.field2, etc From tblTableName a This way you only need to change the field name and everything update.

I am not sure exactly what is going on here, but maybe you need to explicitly convert the return value to the desired format. Try: SELECT CONTACT1.*, Cast(REPLACE(ZIP, ' ', '') as varchar(10)) AS shrunkZIP FROM CONTACT1 Chris

Try this Update a Set a.field1 = b.field1, a.field2 = b.field2, etc From TABLETOBEUPDATED a inner join tbl2 b on a.UniqueID = b.UniqueID Also, for the insert, I think this might be more efficient INSERT INTO TABLE_A SELECT * FROM TABLE_B b WHERE NOT EXists (SELECT *...

Hi Everyone, I am running an SQL Server 2000 backend with MSAccess projects (*.adp) front-ends and am struggling to find an automated way to send out revisions to the front ends. I have created a *.bat file which deletes the old version, inserts the new and opens the program. Unfortunately (as...

Thanks for the replies. Downwitchyobadself, I would like to close and reopen the form because information is likely to change or records deleted by the time the user returns to the form. Daniel, the open args sounds like a great idea. I have been accomplishing this by storing the form name and...

Hi, I have form listing all appointments on a specified date (or set of dates) and a "cmdOpen" button which opens the appointment details form and closes the appt list form. I would like to set it up so when the user reopens the appt list form, the focus is returned to the same spot on...

I wanted to do the same thing, but could find no property which enabled me to do so. As a work-around (since I have this control set to locked and not enabled), I created a box to hide the arrow portion of the control.

Hi, I am trying to connect to SQL server 2000 using an application created as an access data project (*.adp) and deployed with office developer (Clients Access2002 runtime and WinNT/Server SQLServer 2000 and Win2000 server). The application initally opens the login form and runs code to see if a...

Hi, I have a continuous form (developed within an Access Data Project .adp) which is based on an ADODB recordset (view code at bottom). I have had no difficulties viewing and editing forms populated with this method on my desktop computer, but when I installed the application on my laptop, I...

Hi, I am sorry if I am posting this on the wrong forum; if that is the case, please direct me to the appropriate one. I am trying to use a SQL Server 2000 stored procedure ("dbo.spPatientLTComplications") as the data source to a subform in an access .adp. I set the recordsource using...

Hi, I am new to SQL server from MSAccess and am trying to rewrite some of my old queries. In MSAccess, I could use the Iif function for derived values like "Iif(A=B,1,0)", but I can't figure out the SQL server equivalent. Is there such a function? If so, what is the correct syntax...