Marsha,are your SQL servers running on NT 4.0? if so i'm not hugely surprised! i have had no problem with this on 2003 server, or 2000 (from what i can remember).lloyd
2004-11-15
I have 3 tables and I want to use command line interface (DOS prompt) to populate 2 of the 3 tables namely grp, grp_usr and usr tables respectively. I want to be able to add another row to the grp table which has two most important columns i.e. the g_name column which is the grp […]
2004-11-02
"Answer B is just plain wrong"Answer B is only partially wrong. Primary Keys cannot be changed.
2004-11-01
Hi, I wonder if anyone can help here? Objective: 1) Produce an SQL statement that can calculate the distance in miles between a given record in the table and all the other records in the table What i have so far: 1) DB of all the postcodes in the UK Fields postCode '// postcode e.g. AB1postCodeTown '// postcode town e.g. Milton ParkpostCodeCounty […]
2004-10-31
548 reads
Hello I have a problem with reporting services, more specifically the scheduling function within Reporting Services. We have been using this function without a problem for about 2 months now to run reports at specified times and then email the report to the recipients with the report included in the email as an attachment. This […]
2004-10-29
2 reads
HelloIn some of our SQL servers, when creating a maintenance plan, in the 'complete backup' tab, the dropdown for 'delete files older than' (which should contain minutes, hours, days, weeks, months) is empty.Is there a reason for this, such as the SQL Server Agent running without sufficient privileges, is it a known issue, or is there some […]
2004-10-19
3 reads
I think this is a good question, but answer can be changed to:'at least one userdb set recovery mode to simple'. In our practice, on our production server, normally we have one main userdb then a few other small userdbs. If any small userdb is not full recovery,then the plan will fail.
2004-10-13
I agree: Good article, Andy.I'm looking forward to the traffic signal showing how much time is left on the YELLOW (and maybe even FLASHING THE RED to STOP! STOP! STOP! before going solid Red) so drivers stop running Yellow lights and killing people when the light is Red.Thanks for encouraging us to slow down and think. Enjoy life.
2004-10-04
I have a similar situation I resolved by 1) move the files from download directory to work directory. files are renamed with current datetime extension to avoid overwrite. the files I get have multiple "header" records so I have to split it into pieces as well.2) do whatever needs to be done3) archive the files […]
2004-09-21
I have a similar situation I resolved by 1) move the files from download directory to work directory. files are renamed with current datetime extension to avoid overwrite. the files I get have multiple "header" records so I have to split it into pieces as well.2) do whatever needs to be done3) archive the files […]
2004-09-21
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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