Search results for query: *

I am responsible for a small domain running ZenApp 5.0, web interface 5.01 and Citrix Delivery Services console 3.0 After the government pushed a security update through, those computers can no longer get to the Citrix portal. They are using Citrix online plug-in-web version 12.3.0.8 All...

YES YES YES BACK IT UP! The time and effort it will save you is worth the 10 minutes of SQL config regardless of how big your farm is. We have a SQL maintenance plan to do a full backup once a week and a transaction log every night at midnight.. Thanks. Will create a plan for it. Thanks...

I am taking over the responsibility for a SQL database with an access front end. We are publishing apps via Citrix 4.5. The sql server has a Citrix Datastore database. My question is what's its function? and should I create a maintenance plan for it. If I should have a maintenance plan, what...

Thanks RiverGuy (and Mitch) Finally got it to work Bernie

The easiest way is to just create a brand new database, and open a query window against this database. Paste in your script to create these objects in the brand new database Having some problems with users not found and constraints that do not exist Will create the script again and let you...

For example, if it is SQL Server 2005, from within Management Studio, right-click on your existing database, choose Tasks, then choose Generate Scripts. A wizard will walk you through selecting your objects to create scripts for. It will generate a script you can run in a query window to...

I manage an SQL database with an access front end. I need to create a duplicate copy of the production database without any of the data. I have created the duplicate database, however I am at a loss as to how to remove the data. Any help appreciated Bernie

You can run them as one query: Where Asset Like "ABC1*" Or Asset Like "ABC2* Or Asset Like "ABC3*" Thanks byurow I believe that will work. Thanks everyone

Try: Like "ABC1*" Or Like "ABC2*" or Like "ABC3*" or Like "ABC4*" This will work if I ran 3 queries. The systems start at 100 and go to 300. Is there a way to join them together? Like abc 1 to 3? Bernie

Thanks Golom. That does not seem to work either Bernie

Thanks for the reply Brenda A space returns no records. The asset is identified as abc100.00 abc101.00 abc102.00 With each asset having a number of records (abc100.00/.01/.02 etc) Bernie

I am not a programmer, however I manage a medium database. It has an access front end connected to an sql back end. I have been asked to export a work order table for specific systems for the analysis group. The asset record determines what systems to export. I need the abc systems only. In the...

I still have a problem with an access database and Acrobat. (reference thread181-1099630) I have searched however I cannot find where Acrobat provided a solution. I need to be able to make PDF files from an access front end SQL back end database. Does anyone know of a solution, or has Acrobat...

Thanks Bill That worked. Bernie

Created another problem. Apparently I am no longer the database owner. Instead it is owned by a user. How can I change this? Is it possible that when I re-attached the database the ownership changed? Bernie

I just now reattached the database. Some more info. I had two databases. Apparently I detached the database that my login defaulted to. This resulted in my inability to log in. Since the database was on my laptop, I did (what someone suggested) and logged in as the administrator. This allowed me...

I am getting this error when I open Enterprise Manager 8.0 Bernie

Yes I am the admin. I installed this sql app on my laptop Bernie

I detached the database from my SQL server running on my laptop to copy the files. I could not figure how to re-attach the database. When I booted the laptop this morning I got the following message. "A connection could not be established to XXXLAPTOP. Reason: Cannot open user default database...

Windows server authentication Bernie