We also use Arcserve to run the company backups.It will not backup open files, and as you said, you would have to stop SQL in order to back them up, which is not the most sensible thing to do. Arcserve does have a separate product, an agent that can backup SQL. I believe that it […]
2004-03-12
What is the error? Are you using OLE/DB or ODBC? I assume that the userid you signed on with is a valid login for the server as well as having access to the Wordman database.Check out http://www.able-consulting.com/ADO_Conn.htm for samples of connection strings.
2004-02-23
Ben,I would go your route using an audit table. That's what we do where I work. We store the old and new information together in the same record, what form/page the change was made on, date, by who, etc.I would think if you stored the old and new (revised) records in the same table you will eventually […]
2004-02-23
Have you verified the database connection to make sure that the DB server is responding?
2004-02-20
Also, the query takes 8 seconds to run when I add the rest of the fields to it. Huge difference. The UNION did nothing at all for performance -- exactly the same. If this were the only query running for a particular web page, 8 seconds MAY be acceptable, however, it is one of many, […]
2004-02-10
2004-02-10
I am posting not as a reply to the actual question, but to find out how I can do the opposite of it. ie., if a user generates a report (basically as a result of querying database table(s) via ASP), can I convert it (output report) into excel file on the server side and provide a […]
2004-02-05
1 reads
Neddy,You state: Another table is inserting into the table with Status_Date bya triggerCheck out the trigger, it might be the cause of your problem.-SQLBill
2004-02-03
1 reads
Thanks for the reply. We are moving the direction suggestion already but this change has go through the regular release process and we wanted to understand what is happening with the current implementation until the modification can get to production.Does that mean I cannot trust OPENXML when participating in joins?
2004-02-02
I didn't know that you could license SQL Server to a person. I thought there were only two licensing options.CALPer processorIn my case I deal exclusively with systems accessible via the web so only per processor applies to me.Most people don't give a pair of fetid dingos kidneys about licensing until FAST come knocking at […]
2004-01-29
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers